How to disable Delete

With the below code how i can disable Delete button if IsActive = "N"

$('#tblLocation').DataTable({

"ajax": {

"url": '/Location/List',

"type": "get",

"datatype": "json",

dataSrc: ""

paging: true,

sort: true,

pageLength: 10,

searching: true,

"columns": [

{ "data": "Id", "autoWidth": true },

{ "data": "Description", "autoWidth": true },

{ "data": "IsActive", "autoWidth": true },

{

"data": "Id", "render": function (data) {

return " Edit Delete";

}

]

});

Thanks

step 1. Declare an AutoPopulated (Calculated) property in viewModel (Location to LocationVM)

public Class LocationVM
{
public string Id{get;set;}
public string Description{get;set;}
public string IsActive{get;set;}
public string IsDisabled {get{
if(IsActive=="N"){return "disabled"}else{return ""}
}}
}

Step 2. Here you don't need to anything just change the model name


public List GetAllLocation()  
{  
List objLocation = new List();  
using (SqlConnection con = new SqlConnection(cs))  
{  
con.Open();  
SqlCommand com = new SqlCommand("sp_Location", con);  
com.CommandType = CommandType.StoredProcedure;  
com.Parameters.AddWithValue("@Action", "R");  
SqlDataReader rdr = com.ExecuteReader();  
while (rdr.Read())  
{  
objLocation.Add(new LocationVM  
{  
Id = rdr["Id"].ToString(),  
Description = rdr["Description"].ToString(),  
IsActive = rdr["IsActive"].ToString(),  
});  
}  
return objLocation;  
}  
}  
step 3. use the calculated property

{
"data": "Id", "render": function (data,type,full,meta) {
return " + data + " id='btnEdit'>class='fa fa-pencil'> Edit
class='btn btn-danger btn-sm' data-Id=" + data + " id='btnDelete' style='margin-left:5px' disabled="+ full.IsDisabled+">class='fa fa-trash'> Delete";
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
step 1. Declare an AutoPopulated (Calculated) property in viewModel (Location to LocationVM)
public Class LocationVM
{
public string Id{get;set;}
public string Description{get;set;}
public string IsActive{get;set;}

public string IsDisabled {get{
if(IsActive=="N"){return "disabled"}else{return ""}
}}

}
Step 2. Here you don't need to anything just change the model name
public List GetAllLocation() { List objLocation = new List(); using (SqlConnection con = new SqlConnection(cs)) { con.Open(); SqlCommand com = new SqlCommand("sp_Location", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@Action", "R"); SqlDataReader rdr = com.ExecuteReader(); while (rdr.Read()) { objLocation.Add(new LocationVM { Id = rdr["Id"].ToString(), Description = rdr["Description"].ToString(), IsActive = rdr["IsActive"].ToString(), }); } return objLocation; } } step 3. use the calculated property
{
"data": "Id", "render": function (data,type,full,meta) {
return " + data + " id='btnEdit'>class='fa fa-pencil'> Edit
class='btn btn-danger btn-sm' data-Id=" + data + " id='btnDelete' style='margin-left:5px'  disabled="+ full.IsDisabled+">class='fa fa-trash'> Delete";
}
+1