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