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));
}
