public ActionResult editstatus(tblstatus model) { jobServices _services = new jobServices(); var msg = _services.UpdateStatus(model.Color, model.StatusName, model.Id); if (msg.Contains("Error")) { ViewData["error"] = msg; return(View(model)); } else { TempData["error"] = msg; return(RedirectToAction("statusList")); } }
public ActionResult status(int?id) { tblstatus _model = new tblstatus(); jobServices _services = new jobServices(); if (id.HasValue) { _model = _services.GetStatusbyId(id.Value); return(View("editStatus", _model)); } if (TempData["error"] != null) { ViewData["error"] = TempData["error"].ToString(); } return(View(_model)); }
public tblstatus GetStatusbyId(int id) { tblstatus _profile = new tblstatus(); Global _global = new Database.Global(); CRMClassDataContext _idc = new Database.CRMClassDataContext(_global.con); try { var p = _idc.tblstatus.Where(a => a.Id == id).FirstOrDefault(); return(p); } catch (Exception ex) { } finally { _idc.Dispose(); } return(_profile); }
public string AddNewStatus(string color, string name) { string message = "Status Added Succesfully"; Global _global = new Database.Global(); CRMClassDataContext _idc = new Database.CRMClassDataContext(_global.con); try { tblstatus tbl = new tblstatus { Color = color, StatusName = name }; _idc.tblstatus.InsertOnSubmit(tbl); _idc.SubmitChanges(); } catch (Exception ex) { message = "Error " + ex.Message; } finally { _idc.Dispose(); } return(message); }