public ActionResult AddCall([FromBody] supCall call) { var now = DateTime.Now; var recordDate = new DateTime(now.Year, now.Month, now.Day, now.Hour, now.Minute, now.Second); call.RecordDate = DateTime.Now; call.UserID = UserID(); call.CallID = 0; var dBCall = CallDB.supCall.Add(call); try { CallDB.SaveChanges(); } catch (Exception e) { return(Json(e.Message)); } var result = CallDB.supCall .Where(call1 => call1.CallID == call.CallID) .Select(call1 => new { call1.CallID, Object = call1.supObject.Name, ObjectID = call1.ObjectID, ShortName = call1.ShortName, Description = call1.Description, PhoneNumber = call1.PhoneNumber, CreateUserID = call1.CreateUserID, ResponsibleUserID = call1.ResponsibleUserID, CallDate = call1.CallDate, RecordDate = call1.RecordDate, UserID = call1.UserID, TaskID = call1.TaskID, Task = call1.supTask.Name, CallerName = call1.CallerName, PriorityID = call1.PriorityID, Priority = call1.supPriority.Name, StatusID = call1.StatusID, Status = call1.supStatus.StatusID }).OrderByDescending(call1 => call1.CallDate); var requestResult = new { success = true, data = result }; return(Json(requestResult)); }
public ActionResult SaveCall([FromBody] supCall call) { var now = DateTime.Now; var recordDate = new DateTime(now.Year, now.Month, now.Day, now.Hour, now.Minute, now.Second); call.RecordDate = DateTime.Now; call.UserID = UserID(); var dBCall = CallDB.supCall.FirstOrDefault(r => r.CallID == call.CallID); CallDB.Entry(dBCall).CurrentValues.SetValues(call); try { CallDB.SaveChanges(); } catch (Exception e) { return(Json(e.Message)); } return(Json(call.CallID)); }