public User GetUserById(string id)
{
User user = new User();
using (_ctx = new GuildCarsEntities())
{
try
{
var getUser = _ctx.GetUserById(id).FirstOrDefault();
user.UserId = getUser.Id;
string userName = getUser.UserName;
string[] splitName = userName.Split(' ');
user.FirstName = splitName[0];
if (splitName[1] != null)
{
user.LastName = splitName[1];
}
user.Email = getUser.Email;
user.Role = getUser.Name;
user.Password = getUser.PasswordHash;
}
catch (Exception ex)
{
throw ex;
}
}
return(user);
}
public List <SalesReport> GetSalesReports(string user, DateTime startDate, DateTime endDate)
{
List <SalesReport> report = new List <SalesReport>();
using (_ctx = new GuildCarsEntities())
{
try
{
if (user != null)
{
var getUser = _ctx.GetUserById(user).FirstOrDefault();
string userName = getUser.UserName;
var list = _ctx.SalesReport(userName, startDate, endDate).ToList();
foreach (var r in list)
{
SalesReport newReport = new SalesReport();
newReport.User = r.SalesPerson;
newReport.TotalSales = decimal.Parse(r.TotalValue.ToString());
newReport.TotalVehicles = int.Parse(r.TotalVehicles.ToString());
report.Add(newReport);
}
report = report.Where(u => u.User == userName).ToList();
}
if (user == null && startDate.ToString() == "1/1/1970 12:00:00 AM" && endDate.ToString() == "1/1/2150 12:00:00 AM")
{
var list = _ctx.AllSalesReports().ToList();
foreach (var r in list)
{
SalesReport newReport = new SalesReport();
newReport.User = r.SalesPerson;
newReport.TotalSales = decimal.Parse(r.TotalValue.ToString());
newReport.TotalVehicles = int.Parse(r.TotalVehicles.ToString());
report.Add(newReport);
}
}
if (user == null && startDate.ToString() != "1/1/1970 12:00:00 AM" || endDate.ToString() != "1/1/2150 12:00:00 AM")
{
var list = _ctx.SalesReportByDate(startDate, endDate).ToList();
foreach (var r in list)
{
SalesReport newReport = new SalesReport();
newReport.User = r.SalesPerson;
newReport.TotalSales = decimal.Parse(r.TotalValue.ToString());
newReport.TotalVehicles = int.Parse(r.TotalVehicles.ToString());
report.Add(newReport);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
return(report);
}