public virtual ActionResult SoftwareChangeList(DataSourceRequest command, ChangeSoftwareListModel model) { HttpSessionStateBase session = HttpContext.Session; Tbl_User user = _userService.GetUserById(Convert.ToInt32(session["UserID"])); if (model.Amount == 0 && string.IsNullOrEmpty(model.CustomerConnector) && model.Customer_ID == 0 && string.IsNullOrEmpty(model.RequestDate) && string.IsNullOrEmpty(model.DeliveryDate) && string.IsNullOrEmpty(model.Description) && string.IsNullOrEmpty(model.RequiredChanges)) { var SoftwareItems = _softwareService.GetAllSoftwareChange(); var gridModel = new DataSourceResult { Data = SoftwareItems.Select(x => new ChangeSoftwareModel { Amount = x.Amount, CustomerName = _customerService.GetCustomerById(x.Customer_ID).CustomerName, CustomerConnector = x.CustomerConnector, RequestDate = x.RequestDate, Description = x.Description, DeliveryDate = x.DeliveryDate, Customer_ID = x.Customer_ID, RowColor = user.Section_ID == 1 && string.IsNullOrEmpty(x.DeliveryDate) ? 1 : user.Section_ID == 3 && !string.IsNullOrEmpty(x.DeliveryDate) && x.Amount == 0 ? 1 : 0, Request_ID = x.Request_ID, RequiredChanges = x.RequiredChanges }), Total = SoftwareItems.Count() }; return(Json(gridModel)); } else { var SoftwareItems = _softwareService.SearchSoftwareChange(model.Amount, model.CustomerConnector, model.Customer_ID, model.RequestDate, model.DeliveryDate, model.Description, model.RequiredChanges); var gridModel = new DataSourceResult { Data = SoftwareItems.Select(x => new ChangeSoftwareModel { Amount = x.Amount, CustomerName = _customerService.GetCustomerById(x.Customer_ID).CustomerName, CustomerConnector = x.CustomerConnector, RequestDate = x.RequestDate, Description = x.Description, DeliveryDate = x.DeliveryDate, Customer_ID = x.Customer_ID, RowColor = user.Section_ID == 1 && string.IsNullOrEmpty(x.DeliveryDate) ? 1 : user.Section_ID == 3 && !string.IsNullOrEmpty(x.DeliveryDate) && x.Amount == 0 ? 1 : 0, Request_ID = x.Request_ID, RequiredChanges = x.RequiredChanges }), Total = SoftwareItems.Count() }; return(Json(gridModel)); } }
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 ""; }