public IActionResult AddNewPurchase(Purchase c) { c.Tdate = DateTime.Today.Date; Products p = dbContext.Products.Where(pp => pp.ProductCode == c.ProductCode).FirstOrDefault(); Vendors v = dbContext.Vendors.Where(cc => cc.VendorCode == c.VendorCode).FirstOrDefault(); if (p.Quantity == null) { p.Quantity = 0; } p.Quantity = p.Quantity + c.Quantity; dbContext.Products.Update(p); dbContext.Purchase.AddAsync(c); dbContext.SaveChanges(); string msgBody = "<p>New Purchase From " + v + " <br/> " + "Item=" + c.ProductCodeNavigation.ProductName + " <br/> " + "Quantity =" + c.Quantity + " <br/> " + "Total Amount=" + c.LineTotal + " </p>"; EmailSending ES = new EmailSending(); ES.SendEmail("New Purchase on" + DateTime.Now, msgBody, ""); return(RedirectToAction(nameof(Index))); }
public IActionResult AddNewSale(Sale s) { Products p = dbContext.Products.Where(pp => pp.ProductCode == s.ProductCode).FirstOrDefault(); Customers c = dbContext.Customers.Where(cc => cc.CustomerCode == s.CustomerCode).FirstOrDefault(); if (s != null) { if (p.Quantity == null || p.Quantity == 0 || (p.Quantity < s.Quantity)) { ViewBag.ErrorMessage = "Quantity is Greater Than Existing Stock"; return(View()); } p.Quantity = p.Quantity - s.Quantity; dbContext.Products.Update(p); dbContext.Sale.AddAsync(s); dbContext.SaveChanges(); } string msgBody = "<p>Thanks From Your Visit " + c.CustomerName + " <br/> " + "Item=" + p.ProductName + " <br/> " + "Quantity =" + s.Quantity + " <br/> " + "Total Amount=" + s.LineTotal + " </p>"; EmailSending ES = new EmailSending(); ES.SendEmail("Sale on" + DateTime.Now, msgBody, c.Email); return(RedirectToAction(nameof(Index))); }
public IActionResult AddNewUser(Users c) { c.Tdate = DateTime.Today.Date; dbContext.Users.Add(c); dbContext.SaveChanges(); string msgBody = "<p>New User Created by User Id <br/>" + c.UserName + "</p>"; EmailSending ES = new EmailSending(); ES.SendEmail("New User Creation Confirmation", msgBody, c.UserName); return(RedirectToAction(nameof(UserLogin))); }