Example #1
0
 public bool AddNewSoftwareChange(Tbl_ChangeSoftware tu)
 {
     try
     {
         if (tu.Request_ID != 0)
         {
             // user already exists
             Tbl_ChangeSoftware ToBeUpdatedSoftware = _context.Tbl_ChangeSoftware.First(x => x.Request_ID == tu.Request_ID);
             ToBeUpdatedSoftware.Amount            = tu.Amount;
             ToBeUpdatedSoftware.CustomerConnector = tu.CustomerConnector;
             ToBeUpdatedSoftware.Description       = tu.Description;
             ToBeUpdatedSoftware.LastUpdateDate    = tu.LastUpdateDate;
             ToBeUpdatedSoftware.LastUpdateTime    = tu.LastUpdateTime;
             ToBeUpdatedSoftware.LastUpdateUser_ID = tu.LastUpdateUser_ID;
             ToBeUpdatedSoftware.RequestDate       = tu.RequestDate;
             ToBeUpdatedSoftware.Customer_ID       = tu.Customer_ID;
             ToBeUpdatedSoftware.DeliveryDate      = tu.DeliveryDate;
             ToBeUpdatedSoftware.RequiredChanges   = tu.RequiredChanges;
         }
         else
         {
             Tbl_ChangeSoftware ToBeInsertedSoftware = new Tbl_ChangeSoftware();
             ToBeInsertedSoftware.Amount            = tu.Amount;
             ToBeInsertedSoftware.CustomerConnector = tu.CustomerConnector;
             ToBeInsertedSoftware.Description       = tu.Description;
             ToBeInsertedSoftware.LastUpdateDate    = tu.LastUpdateDate;
             ToBeInsertedSoftware.LastUpdateTime    = tu.LastUpdateTime;
             ToBeInsertedSoftware.LastUpdateUser_ID = tu.LastUpdateUser_ID;
             ToBeInsertedSoftware.RequestDate       = tu.RequestDate;
             ToBeInsertedSoftware.Customer_ID       = tu.Customer_ID;
             ToBeInsertedSoftware.DeliveryDate      = tu.DeliveryDate;
             ToBeInsertedSoftware.RequiredChanges   = tu.RequiredChanges;
             _context.Tbl_ChangeSoftware.Add(ToBeInsertedSoftware);
         }
         if (_context.SaveChanges() > 0)
         {
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch (Exception ex)
     {
         return(false);
     }
 }
Example #2
0
        public ActionResult SubmitSoftwareChange(DataSourceRequest command, ChangeSoftwareListModel model)
        {
            HttpSessionStateBase session = HttpContext.Session;

            try
            {
                if (false) // field validation
                {
                    var gridModel = new DataSourceResult
                    {
                        ExtraData = new SoftwareListModel
                        {
                            Message = Message.InvalidCharacter,
                        },
                        Total = 1
                    };
                    return(Json(gridModel));
                }

                Tbl_ChangeSoftware tu = new Tbl_ChangeSoftware();
                tu.Request_ID        = model.Request_ID;
                tu.CustomerConnector = model.CustomerConnector;
                tu.Customer_ID       = model.Customer_ID;
                tu.Description       = model.Description;
                tu.RequestDate       = model.RequestDate;
                tu.RequiredChanges   = model.RequiredChanges;
                tu.DeliveryDate      = model.DeliveryDate;
                tu.Description       = model.Description;
                tu.Amount            = model.Amount;
                tu.LastUpdateUser_ID = Convert.ToInt32(session["UserID"]);
                tu.LastUpdateDate    = DateTime.Now.ToString("yyyy-MM-dd");
                tu.LastUpdateTime    = DateTime.Now.ToString("HH:mm");

                if (_softwareService.AddNewSoftwareChange(tu))
                {
                    var gridModel = new DataSourceResult
                    {
                        ExtraData = new ChangeSoftwareListModel
                        {
                            Message      = Message.OperationSuccessful,
                            MessageColor = "green",
                        },
                        Total = 1
                    };
                    return(Json(gridModel));
                }
                else
                {
                    var gridModel = new DataSourceResult
                    {
                        ExtraData = new ChangeSoftwareListModel
                        {
                            Message      = Message.OperationUnsuccessful,
                            MessageColor = "red",
                        },
                        Total = 1
                    };
                    return(Json(gridModel));
                }
            }
            catch (Exception ex)
            {
                var gridModel = new DataSourceResult
                {
                    ExtraData = new ChangeSoftwareListModel
                    {
                        Message      = Message.OperationUnsuccessful,
                        MessageColor = "red",
                    },
                    Total = 1
                };
                return(Json(gridModel));
            }
            //return "";
        }