public CommonSettingModel GetMasterSettingDetails(int id)
{
CommonSettingModel mastersetting = new CommonSettingModel();
try
{
connection();
using (SqlCommand cmd = new SqlCommand("PRC_GETDETAILS_MASTERSETTING", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", id);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
mastersetting.F_DESCRIPTION = dr["F_DESCRIPTION"].ToString();
mastersetting.PROJECT_FAMILY = dr["PROJECT_FAMILY"].ToString();
mastersetting.PROJECT_FLOW = dr["PROJECT_FLOW"].ToString();
mastersetting.WORK_CATEGORY = dr["WORK_CATEGORY"].ToString();
mastersetting.STATUS = dr["STATUS"].ToString();
}
con.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(mastersetting);
}
public JsonResult UpdateMasterSetting(CommonSettingModel settingModel)
{
homeModel hm = new homeModel();
string res = "";
try
{
res = admin_layer.Update_MasterSetting(settingModel.ID, settingModel.F_DESCRIPTION, settingModel.WORK_CATEGORY, settingModel.PROJECT_FAMILY, settingModel.PROJECT_FLOW, settingModel.STATUS);
string[] response = res.Split(',');
if (response[0] == "Success")
{
hm.SuccessMsg = response[1];
}
else if (response[0] == "Error")
{
hm.ErrorMsg = response[1];
}
}
catch (Exception ex)
{
hm.ErrorMsg = ex.Message;
}
return(Json(hm, JsonRequestBehavior.AllowGet));
}
public JsonResult bindMaterSetting(int type)
{
List <CommonSettingModel> MasterSettingList = new List <CommonSettingModel>();
try
{
dt = admin_layer.GetMasterSetting_History(type);
foreach (DataRow dr in dt.Rows)
{
CommonSettingModel ms = new CommonSettingModel();
ms.Sr_No = Convert.ToInt32(dr["Sr_No"]);
ms.ID = Convert.ToInt32(dr["ID"]);
ms.F_DESCRIPTION = dr["F_DESCRIPTION"].ToString();
ms.PROJECT_FAMILY = dr["PROJECT_FAMILY"].ToString();
ms.PROJECT_FLOW = dr["PROJECT_FLOW"].ToString();
ms.WORK_CATEGORY = dr["WORK_CATEGORY"].ToString();
ms.STATUS = dr["STATUS"].ToString();
MasterSettingList.Add(ms);
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(MasterSettingList, JsonRequestBehavior.AllowGet));
}
public JsonResult mastersettingedit(int id)
{
CommonSettingModel data = new CommonSettingModel();
data = admin_layer.GetMasterSettingDetails(id);
return(Json(data));
}
