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);
}
