public ActionResult Salesreports(string username)
{
EmployeeRepo erepo = new EmployeeRepo();
SaleReportVM model = new SaleReportVM();
List <SalesReport> reports = new List <SalesReport>();
List <Employee> Users = erepo.GetAllEmployees();
model.InventoryReport = erepo.GetInventoryReport();
foreach (Employee u in Users.Where(u => u.RoleName.ToLower() == "sales"))
{
SalesReport current = erepo.GetSalesReportByName(u.UserName);
current.Sales = erepo.GetListofSales(u.UserName);
reports.Add(current);
}
model.Reports = reports;
model.SetSalesStaff(reports);
return(View(model));
}
public ActionResult SpecifiedSalesReport(SaleReportVM model)
{
EmployeeRepo erepo = new EmployeeRepo();
List <SalesReport> reports = new List <SalesReport>();
SalesReport current = erepo.GetSalesReportByName(model.SelectedUser);
SaleReportVM model2 = new SaleReportVM();
model2.SelectedUser = model.SelectedUser;
model2.FromDateString = model.FromDateString;
model2.ToDateString = model.ToDateString;
model2.Reports = new List <SalesReport>();
List <Sales> sales = erepo.GetListofSales(model2.SelectedUser);
if (string.IsNullOrWhiteSpace(model.ToDateString) && string.IsNullOrWhiteSpace(model.FromDateString))
{
current.Sales = sales;
model2.Reports.Add(current);
}
if (!string.IsNullOrWhiteSpace(model2.FromDateString) && string.IsNullOrWhiteSpace(model2.ToDateString))
{
DateTime FromDate = new DateTime();
bool isdatefrom = DateTime.TryParse(model2.FromDateString, out FromDate);
List <Sales> salesfrom = new List <Sales>();
if (isdatefrom)
{
foreach (Sales s in sales)
{
if (DateTime.Compare(s.DateSold, FromDate) >= 0)
{
salesfrom.Add(s);
}
}
current.Sales = salesfrom;
model2.Reports.Add(current);
}
else
{
current.Sales = sales;
model2.Reports.Add(current);
}
}
if (!string.IsNullOrEmpty(model2.ToDateString) && string.IsNullOrWhiteSpace(model2.FromDateString))
{
DateTime ToDate = new DateTime();
List <Sales> salesto = new List <Sales>();
bool isdateto = DateTime.TryParse(model2.ToDateString, out ToDate);
if (isdateto)
{
foreach (Sales s in sales)
{
if (DateTime.Compare(s.DateSold, ToDate) <= 0)
{
salesto.Add(s);
}
}
current.Sales = salesto;
model2.Reports.Add(current);
}
else
{
current.Sales = sales;
model2.Reports.Add(current);
}
}
if ((!string.IsNullOrEmpty(model.ToDateString) && (!string.IsNullOrWhiteSpace(model.FromDateString))))
{
DateTime FromDate = new DateTime();
DateTime ToDate = new DateTime();
bool isdatefrom = DateTime.TryParse(model.FromDateString, out FromDate);
bool isdateto = DateTime.TryParse(model.ToDateString, out ToDate);
List <Sales> spansales = new List <Sales>();
if (isdateto && isdatefrom)
{
foreach (Sales s in sales)
{
if (DateTime.Compare(s.DateSold, ToDate) <= 0 && DateTime.Compare(s.DateSold, FromDate) >= 0)
{
spansales.Add(s);
}
}
current.Sales = spansales;
model2.Reports.Add(current);
}
else
{
current.Sales = sales;
model2.Reports.Add(current);
}
}
return(View(model2));
}
