public int SaveClientStatus(crm_clientStatuses element) { try { if (element.id == 0) { db.crm_clientStatuses.Add(element); db.SaveChanges(); } else { try { db.Entry(element).State = EntityState.Modified; db.SaveChanges(); } catch (OptimisticConcurrencyException ex) { RDL.Debug.LogError(ex); } } } catch (Exception ex) { RDL.Debug.LogError(ex); } return(element.id); }
/*public string GetClientStatusColor(int clientID) * { * string res = ""; * try * { * if (GetClient(clientID).statusID != null) * { * var color = GetClient(clientID).crm_clientStatuses.color; * if (color != null) * res = color; * } * } * catch (Exception ex) * { * RDL.Debug.LogError(ex); * } * return res; * }*/ #endregion #region clientStatus public crm_clientStatuses GetClientStatus(int id) { var res = new crm_clientStatuses(); res = db.GetClientStatus(id); return(res); }
public crm_clientStatuses GetClientStatus(int id) { var res = new crm_clientStatuses(); res = db.crm_clientStatuses.FirstOrDefault(x => x.id == id); return(res); }
public void SaveClientStatus(crm_clientStatuses item) { try { db.SaveClientStatus(item); } catch (Exception ex) { RDL.Debug.LogError(ex); } }
public ActionResult ClientStatuses_save() { var parameters = AjaxModel.GetAjaxParameters(HttpContext); var mng = new CRMManager(); try { var fields = (parameters["fields"] as ArrayList).ToArray().ToList().Select(x => x as Dictionary<string, object>).ToList(); var newClientStatuses = new crm_clientStatuses { id = (AjaxModel.GetValueFromSaveField("id", fields) == "") ? 0 : int.Parse(AjaxModel.GetValueFromSaveField("id", fields)), name = (AjaxModel.GetValueFromSaveField("name", fields)), code = (AjaxModel.GetValueFromSaveField("code", fields)), color = (AjaxModel.GetValueFromSaveField("color", fields)), state = (AjaxModel.GetValueFromSaveField("state", fields)) }; mng.SaveClientStatus(newClientStatuses); return Json(new { result = true, id = newClientStatuses.id, mng = "Операция прошла успешно" },JsonRequestBehavior.AllowGet); } catch(Exception ex) { RDL.Debug.LogError(ex); return Json(new { result = false, id = 0, mng = "Ошибка" }, JsonRequestBehavior.AllowGet); } }