public IEnumerable <Car> Get() { using (CarDBEntities entities = new CarDBEntities()) { return(entities.Cars.ToList()); } }
public void SaveUserDetails() { CompanyDetail companyDe = new CompanyDetail(); companyDe.CompanyName = "IMS Health"; companyDe.CompanyAddress = "Mohakhali"; Customer cus = new Customer(); cus.Name = "Palash"; cus.FatherName = "X"; cus.MobileNo = "019243329321"; cus.CompanyDetail = companyDe; CarDBEntities contex = new CarDBEntities(); //contex.Customers.Add(cus); //contex.SaveChanges(); // CustomerService customerService = new CustomerService(); CompanyService companyService = new CompanyService(); //for insert companyService.InsertCompany(companyDe); customerService.InsertCustomer(cus); //return IEnumerable <Customer> customerList = customerService.GetCustomers(); //error IEnumerable <CompanyDetail> companyList = companyService.GetCompanies(); }
public Car Get(int id) { using (CarDBEntities entities = new CarDBEntities()) { return(entities.Cars.FirstOrDefault(x => x.ID == id)); } }
public List <Car> SearchByMultiple(string carMake, string carModel, string carYear, string carColor) { CarDBEntities ORM = new CarDBEntities(); List <Car> MakeList = ORM.Cars.Where(c => c.carMake.Contains(carMake)).ToList(); List <Car> ModelList = ORM.Cars.Where(c => c.carModel.Contains(carModel)).ToList(); List <Car> YearList = ORM.Cars.Where(c => c.carYear.Contains(carYear)).ToList(); List <Car> ColorList = ORM.Cars.Where(c => c.carColor.Contains(carColor)).ToList(); if (carMake == null) { MakeList.Clear(); //maybe make carMake required } if (carModel == null) { ModelList = new List <Car>(MakeList); } if (carYear == null) { YearList = new List <Car>(ModelList); } if (carColor == null) { ColorList = new List <Car>(YearList); } List <Car> ResultList = MakeList.Intersect(ModelList).Intersect(YearList).Intersect(ColorList).ToList(); return(ResultList); }
public CarReservation InsertCarReservation(int id_vehiculo, int id_cliente, string nombre, string apellido, string telefono, string correo, string horaentrada, string horasalida, string fechaentrada, string fechasalida, string lugar) { CarReservation reservation = new CarReservation(); using (CarDBEntities dc = new CarDBEntities()) { reservation.idVehiculo = id_vehiculo; reservation.idCliente = id_cliente; reservation.nombre = nombre; reservation.apellidos = apellido; reservation.telefono = telefono; reservation.correo = correo; reservation.horaentrada = horaentrada; reservation.horasalida = horasalida; reservation.fechaentrada = fechaentrada; reservation.fechasalida = fechasalida; reservation.lugar = lugar; dc.Configuration.ValidateOnSaveEnabled = false; dc.CarReservations.Add(reservation); dc.SaveChanges(); } return(null); }
// This method will Delete a car public string Delete(int id) { using (CarDBEntities entities = new CarDBEntities()) { var car = entities.Cars.Find(id); entities.Cars.Remove(car); entities.SaveChanges(); return(string.Format("Car with ID={0} is deleted", id)); } }
// This method will Add a new car public void POST(Car car) { using (CarDBEntities entities = new CarDBEntities()) { entities.Cars.Add(car); entities.SaveChanges(); /* * Postman app to test with JSON snippet: * { * "Make": "Peugoet", * "Model": "3008", * "Colour": "Black", * "YearOfManufacturer": 2011 * } */ } }
public void AddCar(Car car) { using (CarDBEntities CarDB = new CarDBEntities()) { var newCar = new EFCar(); { newCar.Id = car.Id; newCar.Make = car.Make; newCar.Model = car.Model; newCar.Year = car.Year; newCar.ImageUrl = car.ImageUrl; newCar.Title = car.Title; newCar.Description = car.Description; newCar.Price = (decimal)car.Price; }; CarDB.EFCars.Add(newCar); CarDB.SaveChanges(); } }
public List <Car> SelectCar() { List <Car> list = new List <Car>(); using (CarDBEntities dc = new CarDBEntities()) { var v = dc.Cars.ToList(); if (v != null) { foreach (var item in v) { list.Add(item); } } else { throw new Exception("Error al intentar traer los registros"); } } return(list); }
public List <Car> SearchCar(int id) { List <Car> list = new List <Car>(); using (CarDBEntities dc = new CarDBEntities()) { var v = dc.Cars.Where(a => a.Id == id).ToList(); if (v != null) { foreach (var item in v) { list.Add(item); } } else { throw new Exception("Error en intentar filtrar el registro"); } } return(list); }
public List<Car> GetAllCars() { List<Car> cars = new List<Car>(); using (CarDBEntities CarDB = new CarDBEntities()) { foreach(var item in CarDB.EFCars) { Car newCar = new Car(); newCar.Id = item.Id; newCar.Make = item.Make; newCar.Model = item.Model; newCar.Year = item.Year; newCar.ImageUrl = item.ImageUrl; newCar.Title = item.Title; newCar.Description = item.Description; newCar.Price = item.Price; cars.Add(newCar); } } return cars; }
// This method will Update a car public void PUT(int id, Car car) { using (CarDBEntities entities = new CarDBEntities()) { var updateCar = entities.Cars.Find(id); updateCar.Make = car.Make; updateCar.Model = car.Model; updateCar.Colour = car.Colour; updateCar.YearOfManufacturer = car.YearOfManufacturer; entities.Entry(updateCar).State = System.Data.Entity.EntityState.Modified; entities.SaveChanges(); /* * Postman app to test with JSON snippet: * { * "Make": "Peugoet update", * "Model": "3008 update", * "Colour": "Black update", * "YearOfManufacturer": 2000 * } */ } }
public CustomerRepository(CarDBEntities contex) { _contex = contex; }
public CompanyRepository(CarDBEntities contex) { _contex = contex; _commonRepository = new CommonRepository(_contex); }
public CustomerService() { _contex = new CarDBEntities(); // _customerRepository=new CustomerRepository(_contex); _commonRepository = new CommonRepository(_contex); }
public List <Car> SearchByModel(string carModel) { CarDBEntities ORM = new CarDBEntities(); return(ORM.Cars.Where(c => c.carModel.Contains(carModel)).ToList()); }
public List <Car> SearchByColor(string carColor) { CarDBEntities ORM = new CarDBEntities(); return(ORM.Cars.Where(c => c.carColor.Contains(carColor)).ToList()); }
public CompanyService() { _contex = new CarDBEntities(); // _companyRepository = new CompanyRepository(_contex); _commonRepository = new CommonRepository(_contex); }