Ejemplo n.º 1
0
        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));
        }
Ejemplo n.º 2
0
        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));
        }