// POST: Users/Remove public ActionResult Remove([FromBody] User user) { if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } var user2 = db.Users.Find(user.Id); db.Users.Remove(user2); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = ex.Message } }); } return(new JsonNetResult { Data = new Msg { Result = "Success", Message = "Removed." } }); }
//Change public ActionResult Change([FromBody] Product product) { ModelState.Remove("DateCreated"); if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }; } Product product2 = db.Products.Find(product.Id); product2.Id = product.Id; product2.VendorId = product.VendorId; product2.VendorPartNumber = product.VendorPartNumber; product2.Name = product.Name; product2.Price = product.Price; product2.Unit = product.Unit; product2.PhotoPath = product.PhotoPath; product2.Active = product.Active; product2.DateCreated = product.DateCreated; try { db.SaveChanges(); } catch (Exception ex) { return new JsonNetResult { Data = new JsonMessage("Failure", ex.Message ) }; //return Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet); } return new JsonNetResult { Data = new JsonMessage("Success", "Product was changed") }; //return Json(new JsonMessage("Success", "Product was changed.")); }
// POST: PurchaseRequests/Change public ActionResult Change([FromBody] PurchaseRequest purchaseRequest) { if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } var purchaseRequest2 = db.PurchaseRequests.Find(purchaseRequest.Id); purchaseRequest2.Copy(purchaseRequest); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = ex.Message } }); } return(new JsonNetResult { Data = new Msg { Result = "Success", Message = "Changed." } }); }
// POST: PurchaseRequestLineitems/Change public ActionResult Change([FromBody] PurchaseRequestLineitem purchaseRequestLineitem) { if (!ModelState.IsValid || purchaseRequestLineitem.Quantity == 0) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } var purchaseRequest2 = db.PurchaseRequestLineitems.Find(purchaseRequestLineitem.Id); purchaseRequest2.Copy(purchaseRequestLineitem); try { db.SaveChanges(); CalculatePurchaseRequestTotal(purchaseRequestLineitem.PurchaseRequestId); } catch (Exception ex) { return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = ex.Message } }); } return(new JsonNetResult { Data = new Msg { Result = "Success", Message = "Changed." } }); }
//Products/Get/2 public ActionResult Get(int?id) { if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } if (id == null) { return(new JsonNetResult { Data = new JsonMessage("Failure", "Id is null") }); } Status status = db.Statuss.Find(id); if (status == null) { return(new JsonNetResult { Data = new JsonMessage("Failure", "Id is not found") }); } return(Json(status, JsonRequestBehavior.AllowGet)); }
//Remove public ActionResult Remove([FromBody] PurchaseRequest purchaserequest) { if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } //if (purchaserequest.Code == null) return new EmptyResult(); PurchaseRequest purchaserequest2 = db.PurchaseRequests.Find(purchaserequest.Id); db.PurchaseRequests.Remove(purchaserequest2); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); //return Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet); } return(new JsonNetResult { Data = new JsonMessage("Success", "Purchase Request was deleted") }); //return Json(new JsonMessage("Success", "Purchase Request was deleted")); }
// POST: Vendors/Change public ActionResult Change([FromBody] Vendor vendor) { if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } var vendor2 = db.Vendors.Find(vendor.Id); vendor2.Copy(vendor); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = ex.Message } }); } return(new JsonNetResult { Data = new Msg { Result = "Success", Message = "Changed." } }); }
//Remove public ActionResult Remove([FromBody] Vendor vendor) { if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } if (vendor.Code == null) { return(new EmptyResult()); } Vendor vendor2 = db.Vendors.Find(vendor.Id); db.Vendors.Remove(vendor2); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); //return Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet); } return(new JsonNetResult { Data = new JsonMessage("Success", "Vendor was deleted") }); //return Json(new JsonMessage("Success", "Vendor was deleted")); }
// Create public ActionResult Create([System.Web.Http.FromBody] Vendor vendor) { ModelState.Remove("DateCreated"); if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } vendor.DateCreated = DateTime.Now; if (!ModelState.IsValid) { return(new JsonNetResult { Data = new JsonMessage("Failure", "Model State is not valid") }); } db.Vendors.Add(vendor); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); } return(new JsonNetResult { Data = new JsonMessage("Success", "Vendor was created.") }); }
// Create public ActionResult Create([System.Web.Http.FromBody] Product product) { ModelState.Remove("DateCreated"); if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }; } product.DateCreated = DateTime.Now; if (!ModelState.IsValid) { return new JsonNetResult { Data = new JsonMessage("Failure", "Model State is not valid" ) }; //return Json(new JsonMessage("Failure", "Model State is not valid"), JsonRequestBehavior.AllowGet); } db.Products.Add(product); try { db.SaveChanges(); } catch (Exception ex) { return new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }; //return Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet); } return new JsonNetResult { Data = new JsonMessage("Success", "Product was created") }; //return Json(new JsonMessage("Success", "Product was created,")); }
// POST: Users/Create public ActionResult Create([FromBody] User user) { user.DateCreated = DateTime.Now; if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } db.Users.Add(user); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = ex.Message } }); } return(new JsonNetResult { Data = new Msg { Result = "Success", Message = "Created." } }); }
//Products/Create public ActionResult Create([FromBody] Status status) { if (status.Id == null) { return(new EmptyResult()); } if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } db.Statuss.Add(status); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); } return(new JsonNetResult { Data = new JsonMessage("Success", "Status was created the new id is:" + status.Id) }); }
// Create [POST] public ActionResult Create([FromBody] User user) { if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } //if (user.UserName == null) return new EmptyResult(); user.DateCreated = DateTime.Now; if (!ModelState.IsValid) { return(new JsonNetResult { Data = new JsonMessage("Fail", "ModelState invalid", ModelState) }); } db.Users.Add(user); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); //return Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet); } return(new JsonNetResult { Data = new JsonMessage("Success", "User was created") }); //return Json(new JsonMessage("Success", "User was created,")); }
// POST: Products/Create public ActionResult Create([FromBody] Product product) { if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } db.Products.Add(product); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = ex.Message } }); } return(new JsonNetResult { Data = new Msg { Result = "Success", Message = "Created." } }); }
//Products/Create public ActionResult Create([FromBody] Product product) { if (product.Name == null) { return(new EmptyResult()); } product.DateCreated = DateTime.Now; if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } db.Products.Add(product); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); } return(new JsonNetResult { Data = new JsonMessage("Success", "Product was created the new id is:" + product.Id) }); }
//Products/Get/2 public ActionResult Get(int?id) { if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } if (id == null) { return(new JsonNetResult { Data = new JsonMessage("Failure", "Id is null") }); } Product product = db.Products.Find(id); if (product == null) { return(new JsonNetResult { Data = new JsonMessage("Failure", "Id is not found") }); } return(new JsonNetResult { Data = product }); }
//PurchaseRequestLineItems/Change public ActionResult Change([FromBody] PurchaseRequestLineItem purchaseRequestLineItem) { if (purchaseRequestLineItem.Product == null) { return(new EmptyResult()); } purchaseRequestLineItem.DateUpdated = DateTime.Now; purchaseRequestLineItem.Product = null; if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } if (purchaseRequestLineItem == null) { return(new JsonNetResult { Data = new JsonMessage("Failure", "The record has already been deleted,not found") }); } PurchaseRequestLineItem purchaseRequestLineItem2 = db.PurchaseRequestLineItems.Find(purchaseRequestLineItem.Id); purchaseRequestLineItem2.Id = purchaseRequestLineItem.Id; purchaseRequestLineItem2.PurchaseRequestId = purchaseRequestLineItem.PurchaseRequestId; purchaseRequestLineItem2.ProductId = purchaseRequestLineItem.ProductId; purchaseRequestLineItem2.Quantity = purchaseRequestLineItem.Quantity; purchaseRequestLineItem2.Active = purchaseRequestLineItem.Active; purchaseRequestLineItem2.UpdatedByUser = purchaseRequestLineItem.UpdatedByUser; purchaseRequestLineItem2.Product = purchaseRequestLineItem.Product; try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); } UpdateTotal(purchaseRequestLineItem.PurchaseRequestId); return(new JsonNetResult { Data = new JsonMessage("Success", "Purchase Request line item " + purchaseRequestLineItem.Id + " was changed") }); }
//Products/Change public ActionResult Change([FromBody] Product product) { if (product.Name == null) { return(new EmptyResult()); } product.DateUpdated = DateTime.Now; if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } if (product == null) { return(new JsonNetResult { Data = new JsonMessage("Failure", "The record has already been deleted,not found") }); } Product product2 = db.Products.Find(product.Id); product2.Id = product.Id; product2.VendorId = product.VendorId; product2.PartNumber = product.PartNumber; product2.Name = product.Name; product2.Price = product.Price; product2.Unit = product.Unit; product2.PhotoPath = product.PhotoPath; product2.Active = product.Active; try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); } return(new JsonNetResult { Data = new JsonMessage("Success", "User " + product.Id + " " + product.Name + ' ' + " was changed") }); }
//Change public ActionResult Change([FromBody] Vendor vendor) { ModelState.Remove("DateCreated"); if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } if (vendor.Code == null) { return(new EmptyResult()); } Vendor vendor2 = db.Vendors.Find(vendor.Id); vendor2.Id = vendor.Id; vendor2.Code = vendor.Code; vendor2.Name = vendor.Name; vendor2.Address = vendor.Address; vendor2.City = vendor.City; vendor2.State = vendor.State; vendor2.Zip = vendor.Zip; vendor2.Phone = vendor.Phone; vendor2.Email = vendor.Email; vendor2.IsPreapproved = vendor.IsPreapproved; vendor2.Active = vendor.Active; vendor2.DateCreated = vendor.DateCreated; try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); } return(new JsonNetResult { Data = new JsonMessage("Success", "Vendor was changed.") }); }
//Products/Change public ActionResult Change([FromBody] Status status) { if (status.Id == null) { return(new EmptyResult()); } if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } if (status == null) { return(new JsonNetResult { Data = new JsonMessage("Failure", "The record has already been deleted,not found") }); } Status status2 = db.Statuss.Find(status.Id); status2.Id = status.Id; status2.MyStatus = status.MyStatus; try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); } return(new JsonNetResult { Data = new JsonMessage("Success", "Status " + status.Id + " was changed") }); }
//Change public ActionResult Change([FromBody] User user) { if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } if (user.UserName == null) { return(new EmptyResult()); } User user2 = db.Users.Find(user.Id); user2.Id = user.Id; user2.UserName = user.UserName; user2.Password = user.Password; user2.FirstName = user.FirstName; user2.LastName = user.LastName; user2.Phone = user.Phone; user2.Email = user.Email; user2.IsReviewer = user.IsReviewer; user2.IsAdmin = user.IsAdmin; user2.Active = user.Active; try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); //return Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet); } return(new JsonNetResult { Data = new JsonMessage("Success", "User was changed") }); //return Json(new JsonMessage("Success", "User was changed.")); }
//Change public ActionResult Change([FromBody] PurchaseRequestLineItem purchaserequestlineitem) { if (purchaserequestlineitem.Id == 0) { return(new EmptyResult()); } if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } PurchaseRequestLineItem purchaserequestlineitem2 = db.PurchaseRequestLineItems.Find(purchaserequestlineitem.Id); purchaserequestlineitem2.Id = purchaserequestlineitem.Id; purchaserequestlineitem2.PurchaseRequestId = purchaserequestlineitem.PurchaseRequestId; purchaserequestlineitem2.ProductId = purchaserequestlineitem.ProductId; purchaserequestlineitem2.Quantity = purchaserequestlineitem.Quantity; purchaserequestlineitem2.Active = purchaserequestlineitem.Active; purchaserequestlineitem2.DateCreated = purchaserequestlineitem.DateCreated; try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); //return Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet); } UpdatePurchaseRequestTotal(purchaserequestlineitem.PurchaseRequestId); return(new JsonNetResult { Data = new JsonMessage("Success", "Purchase Request Line Item was changed") }); //return Json(new JsonMessage("Success", "Purchase Request Line Item was changed.")); }
// Create public ActionResult Create([System.Web.Http.FromBody] PurchaseRequestLineItem purchaserequestlineitem) { if (purchaserequestlineitem.ProductId == null) { return(new EmptyResult()); } purchaserequestlineitem.DateCreated = DateTime.Now; if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } db.PurchaseRequestLineItems.Add(purchaserequestlineitem); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); //return Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet); } UpdatePurchaseRequestTotal(purchaserequestlineitem.PurchaseRequestId); return(new JsonNetResult { Data = new JsonMessage("Success", "Purchase Request Line Item was created", purchaserequestlineitem.Id) }); //return Json(new JsonMessage("Success", "Purchase Request Line Item was created,")); }
//Change public ActionResult Change([FromBody] PurchaseRequest purchaserequest) { if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } PurchaseRequest purchaserequest2 = db.PurchaseRequests.Find(purchaserequest.Id); purchaserequest2.Id = purchaserequest.Id; purchaserequest2.UserId = purchaserequest.UserId; purchaserequest2.Description = purchaserequest.Description; purchaserequest2.Justification = purchaserequest.Justification; purchaserequest2.Status = purchaserequest.Status; purchaserequest2.Total = purchaserequest.Total; purchaserequest2.Active = purchaserequest.Active; purchaserequest2.RejectionReason = purchaserequest.RejectionReason; purchaserequest2.DateCreated = purchaserequest.DateCreated; try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", "ex.Message") }); //return Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet); } return(new JsonNetResult { Data = new JsonMessage("Success", "Purchase request was changed") }); //return Json(new JsonMessage("Success", "Purchase Request was changed.")); }
//PurchaseRequestLineItems/Create public ActionResult Create([FromBody] PurchaseRequestLineItem purchaseRequestLineItem) { if (purchaseRequestLineItem.ProductId == 0) { return(new EmptyResult()); } purchaseRequestLineItem.DateCreated = DateTime.Now; if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } db.PurchaseRequestLineItems.Add(purchaseRequestLineItem); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); } UpdateTotal(purchaseRequestLineItem.PurchaseRequestId); return(new JsonNetResult { Data = new JsonMessage("Success", "Purchase Request line item was created the new id is:" + purchaseRequestLineItem.Id) }); //This will add user id to this string }
//PurchaseRequests/Create public ActionResult Create([FromBody] PurchaseRequest purchaseRequest) { if (purchaseRequest.Description == null) { return(new EmptyResult()); } purchaseRequest.DateCreated = DateTime.Now; if (!ModelState.IsValid) { var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState); return(new JsonNetResult { Data = new Msg { Result = "Failed", Message = "ModelState invalid.", Data = errorMessages } }); } db.PurchaseRequests.Add(purchaseRequest); try { db.SaveChanges(); } catch (Exception ex) { return(new JsonNetResult { Data = new JsonMessage("Failure", ex.Message) }); } return(new JsonNetResult { Data = new Msg { Result = "Success", Message = "Purchase Request was created the new id is:" + purchaseRequest.Id, Data = purchaseRequest } }); //This will add user id to this string }