public ActionResult SubmitSoftwareType(SoftwareTypeListModel model) { HttpSessionStateBase session = HttpContext.Session; try { Tbl_SoftwareType tu = new Tbl_SoftwareType(); tu.Description = model.Description; tu.SoftwareName = model.SoftwareName; tu.SoftwarePrice = model.SoftwarePrice; tu.Software_ID = model.Software_ID; tu.Products_ID = model.Products_ID; tu.LastUpdateUser_ID = Convert.ToInt32(session["UserID"]); tu.LastUpdateDate = DateTime.Now.ToString("yyyy-MM-dd"); tu.LastUpdateTime = DateTime.Now.ToString("HH:mm"); if (_softwareService.AddNewSoftwareType(tu)) { var gridModel = new DataSourceResult { ExtraData = new SoftwareTypeListModel { Message = Message.OperationSuccessful, MessageColor = "green" }, Total = 1 }; return(Json(gridModel)); } else { var gridModel = new DataSourceResult { ExtraData = new SoftwareTypeListModel { Message = Message.OperationUnsuccessful, MessageColor = "red" }, Total = 1 }; return(Json(gridModel)); } } catch (Exception ex) { var gridModel = new DataSourceResult { ExtraData = new SoftwareTypeListModel { Message = Message.OperationUnsuccessful, MessageColor = "red" }, Total = 1 }; return(Json(gridModel)); } //return ""; }
public bool AddNewSoftwareType(Tbl_SoftwareType tu) { try { if (tu.Software_ID != 0) { // user already exists Tbl_SoftwareType ToBeUpdatedHardware = _context.Tbl_SoftwareType.First(x => x.Software_ID == tu.Software_ID); ToBeUpdatedHardware.Description = tu.Description; ToBeUpdatedHardware.SoftwareName = tu.SoftwareName; ToBeUpdatedHardware.SoftwarePrice = tu.SoftwarePrice; ToBeUpdatedHardware.Software_ID = tu.Software_ID; ToBeUpdatedHardware.Products_ID = tu.Products_ID; ToBeUpdatedHardware.LastUpdateDate = tu.LastUpdateDate; ToBeUpdatedHardware.LastUpdateTime = tu.LastUpdateTime; ToBeUpdatedHardware.LastUpdateUser_ID = tu.LastUpdateUser_ID; } else { Tbl_SoftwareType ToBeInsertedHardware = new Tbl_SoftwareType(); ToBeInsertedHardware.Description = tu.Description; ToBeInsertedHardware.SoftwareName = tu.SoftwareName; ToBeInsertedHardware.SoftwarePrice = tu.SoftwarePrice; ToBeInsertedHardware.Software_ID = tu.Software_ID; ToBeInsertedHardware.Products_ID = tu.Products_ID; ToBeInsertedHardware.LastUpdateDate = tu.LastUpdateDate; ToBeInsertedHardware.LastUpdateTime = tu.LastUpdateTime; ToBeInsertedHardware.LastUpdateUser_ID = tu.LastUpdateUser_ID; _context.Tbl_SoftwareType.Add(ToBeInsertedHardware); } if (_context.SaveChanges() > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } }