public ActionResult DeleteConfirmed(long id) { BulkBuy bulkBuy = db.BulkBuys.Find(id); db.BulkBuys.Remove(bulkBuy); db.SaveChanges(); TempData["Message"] = "Bulk deleted Successfully !"; return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "BulkBuyID,CustomerName,Address,TakenAmount,Rate,GWeight,SWeight,Status")] BulkBuy bulkBuy) { if (ModelState.IsValid) { db.Entry(bulkBuy).State = EntityState.Modified; db.SaveChanges(); TempData["Message"] = "Bulk updated Successfully !"; return(RedirectToAction("Index")); } ViewBag.ProductTypeID = new SelectList(db.ProductTypes, "TypeName", "TypeName"); return(View(bulkBuy)); }
// GET: BulkBuys/Details/5 public ActionResult Details(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BulkBuy bulkBuy = db.BulkBuys.Find(id); if (bulkBuy == null) { return(HttpNotFound()); } return(View(bulkBuy)); }
public IActionResult New(CreateVm model) { if (!ModelState.IsValid) { return(View(model)); } var bulkBuy = new BulkBuy() { DisplayId = _shortCodeService.GenerateId(IdPrefix.BULK_BUY), Name = model.Name, Description = model.Description, DueDate = model.ClosingDate, OwnerId = _userManager.GetUserId(User), CreatedDate = DateTime.UtcNow }; _context.BulkBuys.Add(bulkBuy); _context.SaveChanges(); return(RedirectToAction("Details", new { id = bulkBuy.DisplayId })); }
public void AddBulkBuy(BulkBuyModel BulkInfo) { using (ShopDevEntities db = new ShopDevEntities()) { try { if (BulkInfo.CustomerCode == null) { Customer customer = new Customer { CustmerName = BulkInfo.CustomerName, Address = BulkInfo.Address }; db.Customers.Add(customer); db.SaveChanges(); BulkInfo.CustomerCode = customer.CustCode; } var todayYear = DateTime.Now.Year; var CurrentMonth = DateTime.Now.Month; // calculation for interst if (BulkInfo.InterestRate != null && BulkInfo.InterestRate != 0) { var buyMonth = BulkInfo.StartDate.Value.Month; var buyYear = BulkInfo.StartDate.Value.Year; var monthDiff = ((todayYear - buyYear) * 12) + CurrentMonth - buyMonth; decimal? interst = 0; if (BulkInfo.InterstableAmount > 0) { interst = BulkInfo.InterstableAmount * BulkInfo.InterestRate * monthDiff / 100; } else { BulkInfo.InterstableAmount = BulkInfo.TakenAmount; interst = BulkInfo.TakenAmount * BulkInfo.InterestRate * monthDiff / 100; } BulkInfo.Interest = interst; BulkInfo.OustandingAmont = BulkInfo.TakenAmount + interst; } BulkBuy bulkbuy = null; if (BulkInfo.BulkBuyID == 0) { bulkbuy = new BulkBuy(); BulkInfo.CopyProperties(bulkbuy); db.BulkBuys.Add(bulkbuy); } else { bulkbuy = db.BulkBuys.Where(m => m.BulkBuyID == BulkInfo.BulkBuyID).FirstOrDefault(); BulkInfo.CopyProperties(bulkbuy); } db.SaveChanges(); List<BulkBuyProduct> lstNewproducts = db.BulkBuyProducts.Where(m => m.BulkBuyID == 0).ToList(); lstNewproducts.ForEach(m => m.BulkBuyID = bulkbuy.BulkBuyID); List<VendorDetail> lstvendors = db.VendorDetails.Where(m => m.BulkByID == 0).ToList(); lstvendors.ForEach(m => m.BulkByID = bulkbuy.BulkBuyID); List<BulkBuyInstallment> lstinstallments = db.BulkBuyInstallments.Where(m => m.BulkBuyID == 0).ToList(); lstinstallments.ForEach(m => m.BulkBuyID = bulkbuy.BulkBuyID); db.SaveChanges(); } catch { } } }