public ActionResult InsertRequestType(RequestTypeListModel model) { HttpSessionStateBase session = HttpContext.Session; try { // update process Tbl_RequestType tg = new Tbl_RequestType(); tg.Description = model.Description; tg.RequestTypeName = model.RequestTypeName; tg.RequestType_ID = model.RequestType_ID; tg.LastUpdateUser_ID = Convert.ToInt32(session["UserID"]); tg.LastUpdateDate = DateTime.Now.ToString("yyyy-MM-dd"); tg.LastUpdateTime = DateTime.Now.ToString("HH:mm"); if (_supportService.AddNewRequestType(tg)) { var gridModel = new DataSourceResult { ExtraData = new RequestTypeListModel { Message = Message.OperationSuccessful, MessageColor = "green", }, Total = 1 }; return(Json(gridModel)); } else { var gridModel = new DataSourceResult { ExtraData = new RequestTypeListModel { Message = Message.OperationUnsuccessful, MessageColor = "red", }, Total = 1 }; return(Json(gridModel)); } } catch (Exception ex) { var gridModel = new DataSourceResult { ExtraData = new RequestTypeListModel { Message = Message.OperationUnsuccessful, MessageColor = "red", }, Total = 1 }; return(Json(gridModel)); } }
public bool AddNewRequestType(Tbl_RequestType reqtyp) { try { //check if user already exists var res = from t in _context.Tbl_RequestType where t.RequestType_ID == reqtyp.RequestType_ID select t; if (res.Count() == 0) { _context.Tbl_RequestType.Add(reqtyp); } else { Tbl_RequestType prod = _context.Tbl_RequestType.First(x => x.RequestType_ID == reqtyp.RequestType_ID); prod.RequestTypeName = reqtyp.RequestTypeName; prod.Description = reqtyp.Description; prod.LastUpdateUser_ID = reqtyp.LastUpdateUser_ID; prod.LastUpdateDate = reqtyp.LastUpdateDate; prod.LastUpdateTime = reqtyp.LastUpdateTime; } if (_context.SaveChanges() > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } }