public ActionResult AddPlant(string Sys_Plant_name)
{
try
{
using (var db = new SAEntities())
{
TM_SysPlant plant = new TM_SysPlant();
plant.Sys_Plant_name = Sys_Plant_name;
plant.del_flag = false;
plant.update_dt = DateTime.Now;
plant.update_by = Session["SA_Auth"].ToString();
db.TM_SysPlant.Add(plant);
db.SaveChanges();
}
//var db = new PCREntities();
//PCR_Impact plant = new PCR_Impact();
//plant.imp_name = Sys_Plant_name;
//db.PCR_Impact.Add(plant);
return(Json(true));
}
catch (Exception)
{
// Do some error logging stuff, handle exception, etc.
return(Json(false));
}
}
public JsonResult CreatePlant()
{
try
{
var formData = Request.Form["Sys_Plant_name"];
var dbData = dbSA.TM_SysPlant.Where(w => w.Sys_Plant_name == formData).FirstOrDefault();
if (dbData == null)
{
TM_SysPlant data = new TM_SysPlant();
data.Sys_Plant_name = Request.Form["Sys_Plant_name"];
data.update_dt = DateTime.Now;
data.update_by = Session["SA_Auth"].ToString();
data.del_flag = false;
dbSA.TM_SysPlant.Add(data);
}
else
{
dbData.del_flag = false;
}
dbSA.SaveChanges();
return(Json(new { Result = "OK", Record = dbSA.TM_SysPlant.OrderByDescending(o => o.Sys_Plant_id).FirstOrDefault() }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
