public bool AddNewSoftware(Tbl_Software tu) { try { if (tu.Request_ID != 0) { // user already exists Tbl_Software ToBeUpdatedSoftware = _context.Tbl_Software.First(x => x.Request_ID == tu.Request_ID); ToBeUpdatedSoftware.Amount = tu.Amount; ToBeUpdatedSoftware.CustomerConnector = tu.CustomerConnector; ToBeUpdatedSoftware.Description = tu.Description; ToBeUpdatedSoftware.Software_ID = tu.Software_ID; 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.Status = tu.Status; ToBeUpdatedSoftware.DeliveryDate = tu.DeliveryDate; ToBeUpdatedSoftware.DeliveryDescription = tu.DeliveryDescription; } else { Tbl_Software ToBeInsertedSoftware = new Tbl_Software(); ToBeInsertedSoftware.Amount = tu.Amount; ToBeInsertedSoftware.CustomerConnector = tu.CustomerConnector; ToBeInsertedSoftware.Description = tu.Description; ToBeInsertedSoftware.Software_ID = tu.Software_ID; 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.Status = tu.Status; ToBeInsertedSoftware.DeliveryDate = tu.DeliveryDate; ToBeInsertedSoftware.DeliveryDescription = tu.DeliveryDescription; _context.Tbl_Software.Add(ToBeInsertedSoftware); } if (_context.SaveChanges() > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } }
public ActionResult SubmitSoftware(DataSourceRequest command, SoftwareListModel 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_Software tu = new Tbl_Software(); tu.Request_ID = model.Request_ID; tu.CustomerConnector = model.CustomerConnector; tu.Customer_ID = model.Customer_ID; tu.Description = model.Description; tu.Software_ID = model.Software_ID; tu.RequestDate = model.RequestDate; if (model.Check_Delivery && !model.Check_Revocation) { tu.Status = 1; } else if (!model.Check_Delivery && model.Check_Revocation) { tu.Status = 2; } else { tu.Status = 0; } tu.DeliveryDate = model.DeliveryDate; tu.DeliveryDescription = model.DeliveryDescription; 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.AddNewSoftware(tu)) { var gridModel = new DataSourceResult { ExtraData = new SoftwareListModel { Message = Message.OperationSuccessful, MessageColor = "green" }, Total = 1 }; return(Json(gridModel)); } else { var gridModel = new DataSourceResult { ExtraData = new SoftwareListModel { Message = Message.OperationUnsuccessful, MessageColor = "red" }, Total = 1 }; return(Json(gridModel)); } } catch (Exception ex) { var gridModel = new DataSourceResult { ExtraData = new SoftwareListModel { Message = Message.OperationUnsuccessful, MessageColor = "red" }, Total = 1 }; return(Json(gridModel)); } //return ""; }