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