public async Task <IHttpActionResult> RejectSaleMonad(LeaderShip_InputDto leaderShip_Input) { var userId = ((UserIdentity)User.Identity).UserId; LeaderShip leaderShip = new LeaderShip { Id = IdentityManager.NewId(), Sale_Id = leaderShip_Input.Sale_Id, User_DId = userId, Des = leaderShip_Input.Des }; db.LeaderShips.Add(leaderShip); var result = new Product_Sale { Id = leaderShip_Input.Sale_Id }; db.Entry(result).State = EntityState.Unchanged; result.Is_Or = 20;//撤销 if (await db.SaveChangesAsync() > 0) { return(Json(new { code = 200, msg = "确认成功" })); } return(Json(new { code = 210, msg = "确认失败" })); }
public async Task <IHttpActionResult> SetSaleProduct(ProductSaleInput productSaleInput) { Product_Sale product_Sale = new Product_Sale { Id = IdentityManager.NewId(), Behoof = productSaleInput.Behoof, Des = productSaleInput.Des, FishProductId = productSaleInput.FishProductId, ProductNumber = productSaleInput.ProductNumber, QuasiPurchaseNumber = productSaleInput.ProductNumber, Sale_Time = DateTime.Now, Userid = productSaleInput.Userid, Sale_Price = productSaleInput.Sale_Price, SupplierId = productSaleInput.SupplierId, Is_Or = 1 }; db.Product_Sales.Add(product_Sale); if (await db.SaveChangesAsync() > 0) { return(Json(new { code = 200, msg = "添加销售申请成功" })); } return(Json(new { code = 201, msg = "失败" })); }
public async Task <IHttpActionResult> EdditSaleMonad(ProductSaleInput productSaleInput) { Product_Sale type_res = new Product_Sale { Id = productSaleInput.Id }; // var type_res = await Task.Run(() => db.Product_Sales.SingleOrDefaultAsync(p => p.Id == productSaleInput.Id)); type_res.Behoof = productSaleInput.Behoof; type_res.Des = productSaleInput.Des; type_res.ProductNumber = productSaleInput.ProductNumber; type_res.QuasiPurchaseNumber = productSaleInput.QuasiPurchaseNumber; type_res.Sale_Price = productSaleInput.Sale_Price; type_res.SupplierId = productSaleInput.SupplierId; type_res.Userid = productSaleInput.Userid; db.Configuration.ValidateOnSaveEnabled = false; db.Entry(type_res).State = System.Data.Entity.EntityState.Unchanged; //Type type = typeof(ProductSaleInput); //Assembly assembly = Assembly.GetExecutingAssembly(); //object o = assembly.CreateInstance(type.FullName); //PropertyInfo[] propertyInfos = o.GetType().GetProperties(BindingFlags.Instance | BindingFlags.Public); //string str = string.Empty; //str += string.Format("类名称:{0}", type.Name); /* if (item.Name != "Id" && item.Name != "z_FnishedProduct" && item.Name != "Supplier" && item.Name != "userDetails")*/ /*item.GetValue(type_res) != null && !string.IsNullOrWhiteSpace(value.ToString()) && name != "Id"&& (long)item.GetValue(type_res) != 0&& (double)item.GetValue(type_res)!=null*/ foreach (var item in type_res.GetType().GetProperties()) { string name = item.Name; // object value = item.GetValue(type_res); object value = item.GetValue(type_res); if (item.GetValue(type_res) != null && value.ToString() != "" && item.Name != "Id" && value.ToString() != "0" && item.Name != "z_FnishedProduct" && item.Name != "Supplier" && item.Name != "userDetails") { Console.WriteLine(item.Name); db.Entry(type_res).Property(item.Name).IsModified = true; } else { if (item.Name != "z_FnishedProduct" && item.Name != "Supplier" && item.Name != "userDetails") { Console.WriteLine(item.Name); db.Entry(type_res).Property(item.Name).IsModified = false; } } } if (await db.SaveChangesAsync() > 0) { db.Configuration.ValidateOnSaveEnabled = true; return(Json(new { code = 200, msg = "修改成功" })); } return(Json(new { code = 301, msg = "修改失败" })); }
public object removeSaleProduct(int productID, int saleID, int quantity) { db.Configuration.ProxyCreationEnabled = false; dynamic toReturn = new ExpandoObject(); try { Product product = db.Products.Where(x => x.ProductID == productID).FirstOrDefault(); if (product != null) { Sale sale = db.Sales.Where(x => x.SaleID == saleID).FirstOrDefault(); if (sale != null) { Container_Product container_Product = db.Container_Product.Where(x => x.ContainerID == sale.ContainerID && x.ProductID == product.ProductID).FirstOrDefault(); if (container_Product != null) { container_Product.CPQuantity = (container_Product.CPQuantity + quantity); db.SaveChanges(); Product_Sale product_Sale = db.Product_Sale.Where(x => x.ProductID == product.ProductID && x.SaleID == sale.SaleID).FirstOrDefault(); if (product_Sale != null) { db.Product_Sale.Remove(product_Sale); db.SaveChanges(); toReturn.Product_Sale = product_Sale; } } else { toReturn.Error = "Container Not Found"; } } else { toReturn.Error = "Sale Not Found"; } } else { toReturn.Error = "Product Not Found"; } } catch { toReturn.Error = "Product Removal Unsuccessful"; } return(toReturn); }
public object cancelSale(int saleID) { db.Configuration.ProxyCreationEnabled = false; dynamic toReturn = new ExpandoObject(); try { //get sale Sale newSale = db.Sales.Where(x => x.SaleID == saleID).FirstOrDefault(); if (newSale != null) { //get container Container container = db.Containers.Where(x => x.ContainerID == newSale.ContainerID).FirstOrDefault(); //get list of products in Sale List <Product_Sale> product_Sales = db.Product_Sale.Where(x => x.SaleID == newSale.SaleID).ToList(); if (container != null) { if (product_Sales != null) { foreach (var prod in product_Sales) { Product product = db.Products.Where(x => x.ProductID == prod.ProductID).FirstOrDefault(); if (product != null) { Container_Product container_Product = db.Container_Product.Where(x => x.ContainerID == newSale.ContainerID && x.ProductID == product.ProductID).FirstOrDefault(); if (container_Product != null) { container_Product.CPQuantity = (container_Product.CPQuantity + prod.PSQuantity); db.SaveChanges(); Product_Sale product_Sale = db.Product_Sale.Where(x => x.ProductID == product.ProductID && x.SaleID == newSale.SaleID).FirstOrDefault(); if (product_Sale != null) { db.Product_Sale.Remove(product_Sale); db.SaveChanges(); } } } else { toReturn.Error = "Product Not Found"; } //get list of payment List <Payment> payments = db.Payments.Where(x => x.SaleID == newSale.SaleID).ToList(); if (payments.Count != 0) { foreach (Payment payment in payments) { db.Payments.Remove(payment); db.SaveChanges(); } } toReturn.Message = "Sale Cancelled"; } } else { toReturn.Message = "Cancelling Sale Failed"; } } else { toReturn.Error = "Container Not Found"; } } else { toReturn.Error = "Cancel Failed: Sale Not Found"; } } catch { toReturn.Error = "Sale Cancellation Unsuccessfully Completed"; } return(toReturn); }
public object addSaleProduct(int productID, int saleID, int quantity) { db.Configuration.ProxyCreationEnabled = false; dynamic toReturn = new ExpandoObject(); try { Product product = db.Products.Where(x => x.ProductID == productID).FirstOrDefault(); if (product != null) { Sale sale = db.Sales.Where(x => x.SaleID == saleID).FirstOrDefault(); if (sale != null) { Container_Product container_Product = db.Container_Product.Where(x => x.ContainerID == sale.ContainerID && x.ProductID == product.ProductID).FirstOrDefault(); if (container_Product != null) { if (quantity > container_Product.CPQuantity) { toReturn.Error = "Only " + container_Product.CPQuantity + "Of " + product.ProdName + "In Stock"; return(toReturn); } else { container_Product.CPQuantity = (container_Product.CPQuantity - quantity); db.SaveChanges(); Product_Sale product_Sale = db.Product_Sale.Where(x => x.ProductID == product.ProductID && x.SaleID == sale.SaleID).FirstOrDefault(); if (product_Sale == null) { Product_Sale newProduct_Sale = new Product_Sale(); newProduct_Sale.ProductID = product.ProductID; newProduct_Sale.Product = product; newProduct_Sale.SaleID = sale.SaleID; newProduct_Sale.Sale = sale; newProduct_Sale.PSQuantity = quantity; db.Product_Sale.Add(newProduct_Sale); db.SaveChanges(); toReturn.Product_Sale = db.Product_Sale.ToList().LastOrDefault(); } else { product_Sale.PSQuantity = product_Sale.PSQuantity + quantity; db.SaveChanges(); toReturn.Product_Sale = product_Sale; } } } else { toReturn.Error = "Container Not Found"; } } else { toReturn.Error = "Sale Not Found"; } } else { toReturn.Error = "Product Not Found"; } } catch { toReturn.Error = "Product Add Unsuccessful"; } return(toReturn); }