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