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