public IActionResult Post([FromRoute] int id, [FromBody] BuyerProduct buyerProduct) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } OrderProduct orderProduct = new OrderProduct() { OrderId = id, ProductId = buyerProduct.ProductId }; _context.OrderProduct.Add(orderProduct); try { _context.SaveChanges(); } catch (DbUpdateException) { if (OrderExists(id)) { return(new StatusCodeResult(StatusCodes.Status409Conflict)); } else { throw; } } return(new StatusCodeResult(StatusCodes.Status204NoContent)); }
public List <BuyerProductModel> DeleteBuyerProduct(long Id, long buyerID) { List <BuyerProductModel> lstbulkproducts = new List <BuyerProductModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { BuyerProduct product = GetProduct(db, Id); db.BuyerProducts.Remove(product); db.SaveChanges(); var lstproducts = db.BuyerProducts.Where(m => m.BuyerID == buyerID).ToList(); foreach (var cusprod in lstproducts) { BuyerProductModel objcsproducts = new BuyerProductModel(); cusprod.CopyProperties(objcsproducts); lstbulkproducts.Add(objcsproducts); } } catch (Exception) { } return(lstbulkproducts); } }
public List <BuyerProductModel> AddBuyerProduct(BuyerProductModel productModel) { List <BuyerProductModel> lstcsproducts = new List <BuyerProductModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { productModel.BuyerID = productModel.BuyerID == null ? 0 : productModel.BuyerID; BuyerProduct buyerproduct = null; int? oldUnits = 0; if (productModel.BuyerProductlD > 0) { buyerproduct = db.BuyerProducts.Where(m => m.BuyerProductlD == productModel.BuyerProductlD).FirstOrDefault(); oldUnits = buyerproduct.Units == null ? 0 : buyerproduct.Units; var diffUnit = oldUnits - productModel.Units; var product = db.Products.Where(m => m.ProductName == productModel.ProductName).FirstOrDefault(); if (product != null) { product.Unit += diffUnit; } } else { buyerproduct = new BuyerProduct(); } productModel.CopyProperties(buyerproduct); if (productModel.BuyerProductlD == 0) { db.BuyerProducts.Add(buyerproduct); if (productModel.BuyerID > 0) { var oldproduct = db.Products.Where(m => m.ProductName == productModel.ProductName && m.Type == productModel.Type).FirstOrDefault(); if (oldproduct != null) { oldproduct.Unit -= productModel.Units; } } } db.SaveChanges(); var lstproducts = db.BuyerProducts.Where(m => m.BuyerID == productModel.BuyerID).ToList(); foreach (var cusprod in lstproducts) { BuyerProductModel objcsproduct = new BuyerProductModel(); cusprod.CopyProperties(objcsproduct); lstcsproducts.Add(objcsproduct); } return(lstcsproducts); } catch (Exception) { return(lstcsproducts); } } }
public BuyerProduct GetProduct(ShopDevEntities db, long Id) { BuyerProduct objProduct = null; try { objProduct = db.BuyerProducts.Where(m => m.BuyerProductlD == Id).FirstOrDefault(); } catch (Exception) { } return(objProduct); }
public IActionResult Post([FromBody] BuyerProduct buyerProduct) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Order order = new Order() { CustomerId = buyerProduct.BuyerId }; _context.Order.Add(order); OrderProduct orderProduct = new OrderProduct() { OrderId = order.OrderId, ProductId = buyerProduct.ProductId }; _context.OrderProduct.Add(orderProduct); try { _context.SaveChanges(); } catch (DbUpdateException) { if (OrderExists(order.OrderId)) { return(new StatusCodeResult(StatusCodes.Status409Conflict)); } else { throw; } } return(CreatedAtRoute("GetOrder", new { id = order.OrderId }, order)); }
public IHttpActionResult test() { var prod = new ProductMaster() { GenerateDate = DateTime.Now, Name = "CorporateHealth", State = true, }; var Buyer = new BuyerMaster() { ApiUrl = "", CompanyName = "Syne Craft", Email = "*****@*****.**", Name = "SyneCraft", State = EntityObjects.Enaum.EntityState.active, CreatedDateTime = DateTime.Now, }; var buyerProd = new BuyerProduct() { BuyerApiUrl = "https://vmleads.co.uk/integrations/rest?is_test=1", BuyerMasterId = 1, EndDate = DateTime.Now.AddDays(25), IntegrationType = EntityObjects.Enaum.BuyerIntegrationType.xml, ProductMasterId = 3, Piority = 1, Quata = 100, StartDate = DateTime.Now, State = true, }; //var buyer = new BuyerMaster() //{ // ApiUrl= "http://leadbee.leadspediatrack.com/post.do", // CompanyName ="SuneCraft", // CreatedDateTime = DateTime.Now, //}; //_dbContext.ProductMasters.Add(prod); // _dbContext.SaveChanges(); var v = _dbContext.ProductMasters.ToList(); var prods = _dbContext.BuyerMasters.ToList(); var prodBuyer = _dbContext.BuyerProducts.ToList(); // var v = _dbContext.CommonLeads.ToList().OrderByDescending(m=>m.Id).Where(m=>m.ProductName == "Funeral"); // _dbContext.ProductMasters.Add(prod); // _dbContext.BuyerMasters.Add(Buyer); // _dbContext.BuyerProducts.Add(buyerProd); // _dbContext.SaveChanges(); // CommonLead cmn = UtilityMethods.GetCommonLeads(1276); // cmn.Email = "*****@*****.**"; // _dbContext.Entry(cmn).State = EntityState.Modified; // _dbContext.SaveChanges(); // LeadTransferById(1276); //LifeLead life = UtilityMethods.GetProductLeadByLeadId<LifeLead>(1276, "Life"); //life.DOB = new DateTime(1865, 2, 12); //_dbContext.Entry(life).State = EntityState.Modified; //_dbContext.SaveChanges(); // var vc = _dbContext.CommonLeads.Where(m => m.Id == 2321).ToList(); // BuyerProduct bPod = _dbContext.BuyerProducts.Where(m => m.Id == 4).FirstOrDefault(); // bPod.BuyerApiUrl = "http://leadbee.leadspediatrack.com/post.do"; // _dbContext.Entry(bPod).State = EntityState.Modified; // _dbContext.SaveChanges(); //LeadTransfer(2387); return(Ok(prods)); }