public static string updatetbldata(string id)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
BusinessLayer.SuperAdmin.SuperAdminServiceManager servMgr = new BusinessLayer.SuperAdmin.SuperAdminServiceManager();
Entities.RTOCentre centObj = new Entities.RTOCentre();
try
{
string getid = id;
//dt = da.sgetdataTable("select * from centerdetails_db where Cid='" + getid + "' and ActiveStatus='1'");
dt = servMgr.SuperAdminEditServiceBLL(getid);
//dt = da.sgetdataTable("select * from Tbl_Service where Service_Id='" + getid + "' and Service_Status='1'");
//cmtd abv SPM20072020
ds.Tables.Add(dt);
dt.Columns[0].ColumnName = "col0"; //sl
dt.Columns[1].ColumnName = "col1"; //nam
dt.Columns[2].ColumnName = "col2"; //shnam
dt.Columns[3].ColumnName = "col3"; //stype
dt.Columns[4].ColumnName = "col4"; //cr dt
dt.Columns[5].ColumnName = "col5"; //mod dt
dt.Columns[6].ColumnName = "col6"; //act stats
}
catch
{ }
string JSONString = string.Empty;
JSONString = JsonConvert.SerializeObject(ds);
return(JSONString);
}
public static string deltetabledata(string id)
{
DataSet ds = new DataSet();
BusinessLayer.SuperAdmin.SuperAdminServiceManager servMgr = new BusinessLayer.SuperAdmin.SuperAdminServiceManager();
Entities.RTOService centObj = new Entities.RTOService();
DataTable dt = new DataTable();
string msg = "";
try
{
string getid = id;
//dt = da.sgetdataTable("select * from centerdetails_db where Cid='" + getid + "' and ActiveStatus='1'");
//dt = centMgr.SuperAdminUpdateCentreBLL(getid);
dt = servMgr.SuperAdminEditServiceBLL(getid);
//int retn = da.sExecuteNonQuery("update centerdetails_db set ActiveStatus='0' where Cid='" + getid + "' and ActiveStatus='1'");
int retn = servMgr.SuperAdminDeleteServiceBLL(getid);
ds.Tables.Add(dt);
//string sts=dt.Rows[0]["status"].ToString();
//int retn = da.sExecuteNonQuery("update Tbl_Service set Service_Status='" + 0 + "' where Service_Id='" + getid + "'");
if (retn > 0)
{
msg = "success";
}
else
{
msg = "Fail";
}
}
catch (Exception e)
{ }
string JSONString = string.Empty;
JSONString = JsonConvert.SerializeObject(msg);
return(JSONString);
}
