public async Task <IActionResult> Edit(int id, [Bind("ID,SalesRepId,Date")] DailySalesModel dailySalesModel) { if (id != dailySalesModel.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(dailySalesModel); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DailySalesModelExists(dailySalesModel.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(dailySalesModel)); }
public IActionResult Index(DateTime sDate, DateTime eDate) { ViewBag.sDate = sDate.Date; ViewBag.eDate = eDate.Date; ViewBag.Period = $"FROM {sDate.Date.ToString("MMM dd, yyyy")} TO {eDate.Date.ToString("MMM dd, yyyy")}"; List <DailySalesModel> dailies = new List <DailySalesModel>(); DailySalesModel obj; var user = _asp.FindBy(c => c.UserName == User.Identity.Name).FirstOrDefault(); var dt = _dailySales.FindBy(c => c.DateSold.Date >= sDate.Date && c.DateSold.Date <= eDate.Date && c.CompanyId == user.CompanyId).ToList(); var objs = dt.GroupBy(c => c.ProductName); foreach (var item in objs) { obj = new DailySalesModel(); obj.Company = item.ToList().FirstOrDefault().Company; obj.CompanyId = item.ToList().FirstOrDefault().CompanyId; obj.ProductName = item.ToList().FirstOrDefault().ProductName; obj.ProductId = item.ToList().FirstOrDefault().ProductId; obj.Quntity = item.Sum(c => c.Quntity); obj.TotalCost = item.Sum(c => c.TotalCost); obj.TotalAmount = item.Sum(c => c.TotalAmount); dailies.Add(obj); } return(View(dailies)); }
public async Task <IActionResult> Create([Bind("ID,SalesRep,Date")] DailySalesModel dailySalesModel) { if (ModelState.IsValid) { _context.Add(dailySalesModel); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(dailySalesModel)); }