public List <CarHeaderVm> GetCarsByName(string search)
{
if (String.IsNullOrEmpty(search))
{
return(GetAllCars());
}
var brand = db.Brands;
var model = db.CarModels;
var car = db.Cars;
var petrol = db.PetrolTypes;
var picture = db.Pictures;
using (db = new CarDBEntities1())
{
var cars = (from c in car
join m in model
on c.CarModelId equals m.Id
join b in brand
on c.BrandId equals b.Id
join p in petrol
on c.PetrolTypeId equals p.Id
join pic in picture
on c.Id equals pic.CarId
into g
from result in g.DefaultIfEmpty()
orderby c.Id descending
where b.BrandName.StartsWith(search)
select new CarHeaderVm
{
CarId = c.Id,
Brand = b.BrandName,
Model = m.CarModelName,
Price = c.Price,
City = c.City,
Capacity = c.Capacity,
Distance = c.Distance,
ProductYear = c.Year,
PetrolType = p.PetrolName,
HeaderPicture = result.PicturePath
}
).ToList();
return(cars);
}
}
public CarDetailsVM GetCarById(int id)
{
var brand = db.Brands;
var model = db.CarModels;
var car = db.Cars;
var petrol = db.PetrolTypes;
var body = db.Bodies;
var condition = db.TechnicalConditions;
var transmission = db.Transmissions;
var details = db.CarDetails;
var user = db.Users;
var xrefUserCar = db.XrefUserCars;
using (db = new CarDBEntities1())
{
var carDetail = (from c in car
join m in model
on c.CarModelId equals m.Id
join b in brand
on c.BrandId equals b.Id
join p in petrol
on c.PetrolTypeId equals p.Id
join d in details
on c.Id equals d.CarId
join bo in body
on d.BodyId equals bo.Id
join t in condition
on d.ConditionId equals t.Id
join tran in transmission
on d.TransmissionId equals tran.Id
join x in xrefUserCar
on c.Id equals x.CarId
join u in user
on x.UserId equals u.Id
where c.Id == id
select new CarDetailsVM
{
CarDetailId = d.Id,
CarId = c.Id,
Brand = b.BrandName,
Model = m.CarModelName,
Price = c.Price,
City = c.City,
Capacity = c.Capacity,
Distance = c.Distance,
ProductYear = c.Year,
PetrolType = p.PetrolName,
BodyName = bo.BodyName,
Description = d.Description,
Condition = t.ConditionName,
TransmissionType = tran.TransmissionName,
Email = u.Email,
UserName = u.Name,
Phone = u.Phone
}
).FirstOrDefault();
if (carDetail != null)
{
carDetail.imgList = GetImagesForCarDetails(carDetail.CarDetailId);
}
return(carDetail);
}
}
public bool Insert(CarDetailsVM carDetailsVm)
{
using (db = new CarDBEntities1())
{
var carHeader = db.Cars.Add(new Car
{
BrandId = carDetailsVm.BrandId,
Capacity = carDetailsVm.Capacity,
CarModelId = carDetailsVm.ModelId,
Price = carDetailsVm.Price,
City = carDetailsVm.City,
Year = carDetailsVm.ProductYear,
Distance = carDetailsVm.Distance,
PetrolTypeId = carDetailsVm.PetrolTypeId
});
db.SaveChanges();
var carDetail = db.CarDetails.Add(new CarDetail
{
CarId = carHeader.Id,
BodyId = carDetailsVm.BodyId,
TransmissionId = carDetailsVm.TransmissionTypeId,
ConditionId = carDetailsVm.ConditionId,
Description = carDetailsVm.Description
});
db.SaveChanges();
if (carDetailsVm.imgList != null)
{
db.Pictures.Add(new Picture
{
CarId = carHeader.Id,
PicturePath = carDetailsVm.imgList.FirstOrDefault()
});
foreach (var pic in carDetailsVm.imgList)
{
db.Pictures.Add(new Picture
{
CarDetailsId = carDetail.Id,
PicturePath = pic
});
}
}
var user = GetUserByEmail(carDetailsVm.Email);
if (user == null)
{
user = new User
{
Email = carDetailsVm.Email,
Name = carDetailsVm.UserName,
Phone = carDetailsVm.Phone
};
db.Users.Add(user);
db.SaveChanges();
}
var xrefUserCar = db.XrefUserCars.Add(new XrefUserCar
{
CarId = carHeader.Id,
UserId = user.Id
});
db.SaveChanges();
}
return(true);
}
public Repository()
{
db = new CarDBEntities1();
}