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