public List <Roles> GetAllRoles()
{
List <Roles> roles = new List <Roles>();
using (_ctx = new GuildCarsEntities())
{
try
{
var list = _ctx.GetAllRoles();
foreach (var role in list)
{
Roles addRole = new Roles();
addRole.RoleId = role.Id;
addRole.RoleName = role.Name;
roles.Add(addRole);
}
}
catch (Exception ex)
{
throw ex;
}
}
return(roles);
}
public List <InventoryReport> GetUsedInventoryList()
{
List <InventoryReport> list = new List <InventoryReport>();
using (_ctx = new GuildCarsEntities())
{
try
{
var newList = _ctx.UsedInventoryReport();
foreach (var car in newList)
{
InventoryReport report = new InventoryReport();
report.Year = car.Year;
report.CarMake = car.MakeName;
report.CarModel = car.ModelName;
report.Count = car.TotalVehicles;
report.StockValue = car.TotalValue;
list.Add(report);
}
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
}
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 int AddVehicle(Vehicle addCar)
{
int id = 0;
var test = new List <decimal?>();
using (_ctx = new GuildCarsEntities())
{
try
{
var newId = _ctx.AddVehicle(addCar.Year,
addCar.CarMakeId, addCar.CarModelId, addCar.CarTypeId,
addCar.BodyStyleId, addCar.TransmissionId, addCar.ColorId,
addCar.InteriorId, addCar.Mileage, addCar.VINnumber, addCar.SalePrice,
addCar.MSRP, addCar.CarDescription, addCar.ImageFileName, addCar.IsFeatured,
addCar.IsPurchased);
test = newId.ToList();
}
catch (Exception ex)
{
throw ex;
}
}
if (test != null && test.Count > 0)
{
id = int.Parse(test[0].ToString());
}
return(id);
}
public List <Models.Tables.CarModel> GetCarModelsByMakeId(int id)
{
//Need to implement this.
List <Models.Tables.CarModel> newModels = new List <Models.Tables.CarModel>();
using (_ctx = new GuildCarsEntities())
{
try
{
var modelList = _ctx.GetCarModelsByMakeId(id);
foreach (var mdl in modelList)
{
Models.Tables.CarModel model = new Models.Tables.CarModel();
model.CarModelId = mdl.CarModelId;
model.ModelName = mdl.ModelName;
newModels.Add(model);
}
}
catch (Exception ex)
{
throw ex;
}
}
return(newModels);
}
public List <Models.Tables.CarMake> GetCarMakesWUsers()
{
List <Models.Tables.CarMake> list = new List <Models.Tables.CarMake>();
var makeView = new Models.Tables.CarMake();
using (_ctx = new GuildCarsEntities())
{
var carMakes = _ctx.GetCarMake();
foreach (var make in carMakes)
{
CarMake carMake = new CarMake();
carMake.CarMakeId = make.CarMakeId;
carMake.MakeName = make.MakeName;
carMake.User = make.User;
carMake.DateAdded = make.DateAdded;
makeView = MakeView.Make(carMake);
list.Add(makeView);
}
}
return(list);
}
public List <User> GetAllUsers()
{
List <User> users = new List <User>();
using (_ctx = new GuildCarsEntities())
{
var listOfUsers = _ctx.GetAllUsers();
foreach (var user in listOfUsers)
{
User userToList = new User();
userToList.UserId = user.Id;
userToList.Email = user.Email;
userToList.Role = user.Name;
string userName = user.UserName;
string[] splitName = userName.Split(' ');
userToList.FirstName = splitName[0];
if (splitName.Length > 1)
{
userToList.LastName = splitName[1];
}
users.Add(userToList);
}
}
return(users);
}
public void AddSpecial(Models.Tables.Special special)
{
using (_ctx = new GuildCarsEntities())
{
try
{
_ctx.AddSpecial(special.SpecialTitle, special.SpecialDescription);
}
catch (Exception ex)
{
throw ex;
}
}
}
public void SaveImageToCar(int id, string image)
{
using (_ctx = new GuildCarsEntities())
{
try
{
_ctx.SaveImageToCar(id, image);
}
catch (Exception ex)
{
throw ex;
}
}
}
public void DeleteVehicle(int id)
{
using (_ctx = new GuildCarsEntities())
{
try
{
_ctx.DeleteVehicle(id);
}
catch (Exception ex)
{
throw ex;
}
}
}
public IEnumerable <CarModelView> GetCarModelsWUsers()
{
var list = new List <CarModelView>();
using (_ctx = new GuildCarsEntities())
{
var carModels = _ctx.GetCarModel();
foreach (var model in carModels)
{
list.Add(ModelView.Model(model));
}
}
return(list);
}
public Vehicle GetAllByCarId(int id)
{
Vehicle editCar = new Vehicle();
using (_ctx = new GuildCarsEntities())
{
try
{
var getCar = _ctx.GetAllByCarId(id).FirstOrDefault();
editCar = VehicleData.Car(getCar);
}
catch (Exception ex)
{
throw ex;
}
}
return(editCar);
}
public List <GetInterior> GetInterior()
{
List <GetInterior> list = new List <GetInterior>();
using (_ctx = new GuildCarsEntities())
{
var interiors = _ctx.GetInterior();
foreach (var interior in interiors)
{
GetInterior c = new GetInterior();
c.InteriorId = interior.InteriorId;
c.InteriorName = interior.InteriorName;
list.Add(c);
}
}
return(list);
}
public List <GetTransmission> GetTransmission()
{
List <GetTransmission> list = new List <GetTransmission>();
using (_ctx = new GuildCarsEntities())
{
var trans = _ctx.GetTransmission();
foreach (var t in trans)
{
GetTransmission c = new GetTransmission();
c.TransmissionId = t.TransmissionId;
c.TransmissionName = t.TransmissionName;
list.Add(c);
}
}
return(list);
}
public List <GetBodyStyle> GetBodyStyle()
{
List <GetBodyStyle> list = new List <GetBodyStyle>();
using (_ctx = new GuildCarsEntities())
{
var bodyStyles = _ctx.GetBodyStyle();
foreach (var style in bodyStyles)
{
GetBodyStyle c = new GetBodyStyle();
c.BodyStyleId = style.BodyStyleId;
c.BodyStyleName = style.BodyStyleName;
list.Add(c);
}
}
return(list);
}
public List <GetColor> GetColor()
{
List <GetColor> list = new List <GetColor>();
using (_ctx = new GuildCarsEntities())
{
var colors = _ctx.GetColor();
foreach (var color in colors)
{
GetColor c = new GetColor();
c.ColorId = color.ColorId;
c.ColorName = color.ColorName;
list.Add(c);
}
}
return(list);
}
public List <GetCarType> GetCarType()
{
List <GetCarType> list = new List <GetCarType>();
using (_ctx = new GuildCarsEntities())
{
var carTypes = _ctx.GetCarType();
foreach (var type in carTypes)
{
GetCarType c = new GetCarType();
c.TypeId = type.TypeId;
c.TypeName = type.TypeName;
list.Add(c);
}
}
return(list);
}
public void EditVehicle(Vehicle editCar)
{
Car newCar = new Car();
using (_ctx = new GuildCarsEntities())
{
try
{
_ctx.EditVehicle(editCar.CarId, editCar.Year, editCar.CarMakeId,
editCar.CarModelId, editCar.CarTypeId, editCar.BodyStyleId,
editCar.TransmissionId, editCar.ColorId, editCar.InteriorId,
editCar.Mileage, editCar.VINnumber, editCar.SalePrice, editCar.MSRP,
editCar.CarDescription, editCar.ImageFileName, editCar.IsFeatured, editCar.IsPurchased);
}
catch (Exception ex)
{
throw ex;
}
}
}
public List <Models.Tables.Special> GetAllSpecials()
{
List <Models.Tables.Special> specials = new List <Models.Tables.Special>();
using (_ctx = new GuildCarsEntities())
{
var listOfSpecials = _ctx.GetAllSpecials();
foreach (var s in listOfSpecials)
{
Models.Tables.Special hp = new Models.Tables.Special();
hp.SpecialId = s.SpecialId;
hp.SpecialTitle = s.SpecialTitle;
hp.SpecialDescription = s.SpecialDescription;
specials.Add(hp);
}
}
return(specials);
}
public void AddMake(Models.Tables.CarMake carMake)
{
User user = new User();
using (_ctx = new GuildCarsEntities())
{
try
{
var userInfo = _ctx.GetUserByName(carMake.User);
foreach (var u in userInfo)
{
user.Email = u.Email;
}
_ctx.AddVehicleMake(carMake.MakeName, user.Email);
}
catch (Exception ex)
{
throw ex;
}
}
}
public void AddModel(CarModelView carModel)
{
User user = new User();
using (_ctx = new GuildCarsEntities())
{
try
{
var userInfo = _ctx.GetUserByName(carModel.User);
foreach (var u in userInfo)
{
user.Email = u.Email;
}
_ctx.AddVehicleModel(carModel.ModelName, carModel.CarMakeId, user.Email);
}
catch (Exception ex)
{
throw ex;
}
}
}
public List <GetCarModel> GetCarModel()
{
List <GetCarModel> list = new List <GetCarModel>();
using (_ctx = new GuildCarsEntities())
{
var carModels = _ctx.GetCarModel();
foreach (var model in carModels)
{
GetCarModel c = new GetCarModel();
c.CarModelId = model.CarModelId;
c.CarMakeId = model.CarMakeId;
c.DateAdded = model.DateAdded;
c.ModelName = model.ModelName;
list.Add(c);
}
}
return(list);
}
public List <GetCarMake> GetCarMake()
{
List <GetCarMake> list = new List <GetCarMake>();
var makeView = new Models.Tables.CarMake();
using (_ctx = new GuildCarsEntities())
{
var carMakes = _ctx.GetCarMake();
foreach (var make in carMakes)
{
GetCarMake c = new GetCarMake();
c.CarMakeId = make.CarMakeId;
c.DateAdded = make.DateAdded;
c.MakeName = make.MakeName;
list.Add(c);
}
}
return(list);
}
public List <GetSpecials> GetAllSpecials()
{
List <GetSpecials> specials = new List <GetSpecials>();
using (_ctx = new GuildCarsEntities())
{
var listOfSpecials = _ctx.GetAllSpecials();
foreach (var s in listOfSpecials)
{
GetSpecials hp = new GetSpecials();
hp.SpecialId = s.SpecialId;
hp.SpecialTitle = s.SpecialTitle;
hp.SpecialDescription = s.SpecialDescription;
specials.Add(hp);
}
}
return(specials);
//throw new NotImplementedException();
}
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);
}
public InventoryRepoEF()
{
_ctx = new GuildCarsEntities();
}
public AdminRepoEF()
{
_ctx = new GuildCarsEntities();
}
public HomeRepoEF()
{
_ctx = new GuildCarsEntities();
}
public SalesRepoEF()
{
_ctx = new GuildCarsEntities();
}
public EFTests()
{
_ctx = new GuildCarsEntities();
}
