public List<CarModel> GetAllCars(string status,int pageIndex, int pageSize) { try { List<CarModel> list=new List<CarModel>(); IQueryable<Car> cars = context.Car.Where(c=>c.Statu==status).OrderBy(c => c.ID).Skip((pageIndex - 1) * pageSize).Take(pageSize); foreach (var car in cars) { CarModel model=new CarModel(); model.ID = car.ID; model.BrandName = car.BrandName; model.CarType = car.CarType; model.Color = car.Color; model.Price = car.Price; model.Status = car.Statu; model.UserInfo_ID = car.UserInfo_ID; model.Year = car.Year; list.Add(model); } return list; } catch (Exception) { return null; } }
public void OwnCar(CarModel car) { if (Category.Any(category => category == car.Category) ) { this.Car = car; } else { throw new NullReferenceException("У водителя нет прав данной категории"); } }
public int AddCar(int userID,string brandName,string carType,decimal price,string color,int year,string status) { var newCar = new CarModel(); newCar.UserInfo_ID = userID; newCar.BrandName = brandName; newCar.CarType = carType; newCar.Price = price; newCar.Color = color; newCar.Year = year; newCar.Status = status; return dal.AddCar(newCar); }
public int EditCar(int id,int userID, string brandName, string carType, decimal price, string color, int year, string status) { var editCar = new CarModel(); editCar.ID = id; editCar.UserInfo_ID = userID; editCar.BrandName = brandName; editCar.CarType = carType; editCar.Price = price; editCar.Color = color; editCar.Year = year; editCar.Status = status; return dal.EditCar(editCar); }
static void Main(string[] args) { var car = new CarModel("Лада",'D'); Console.WriteLine("Автосалон приобрел автомобиль: {0}, Kатегории: {1}, Цвет: {2}\n", car.Model, car.Category,car.color.Name); car.color = Color.BlueViolet; Console.WriteLine("Автомобиль перекрашен в {0} цвет\n", car.color.Name); try { Console.WriteLine(car.CarPassport.Owner.Name); } catch (NullReferenceException ex) { Console.WriteLine("Невозможно вывести имя владельца Лады. Сообщение: {0}\n",ex.Message); } var driver = new DriverModel(new DateTime(2011,11,11), "Вольдемар" ); Console.WriteLine("Нанят новый инструктор: {0} \n", driver.Name ); driver.Category.Add('B'); driver.Category.Add('C'); Console.WriteLine("Инструктор Вольдемар имеет {0} {1} категории\n", driver.Category[0], driver.Category[1]); try { Console.WriteLine("Смена водителя Лады на Вольдемара;\n"); car.ChangeOwner(driver, "о777о"); } catch (NullReferenceException ex) { Console.WriteLine("Невозможно изменить водителя: {0};\n",ex.Message); } driver.Category.Add('D'); Console.WriteLine("Вольдемар получил {0} категорию\n", driver.Category[2]); car.ChangeOwner(driver, "о777о"); Console.WriteLine("Номер машины Вольдемара: {0}\n", car.CarNumber); Console.WriteLine("{0} владелец машины Лада\n", car.CarPassport.Owner.Name); Console.ReadLine(); }
public int EditCar(CarModel car) { try { int id = car.ID; var editCar = context.Car.FirstOrDefault(c => c.ID == id); editCar.BrandName = car.BrandName; editCar.CarType = car.CarType; editCar.Color = car.Color; editCar.Price = car.Price; editCar.Statu = car.Status; editCar.UserInfo_ID = car.UserInfo_ID; editCar.Year = car.Year; context.SaveChanges(); return 1; } catch (Exception) { return 0; } }
public int AddCar(CarModel car) { try { Car newCar=new Car(); newCar.BrandName = car.BrandName; newCar.CarType = car.CarType; newCar.Color = car.Color; newCar.Price = car.Price; newCar.Statu = car.Status; newCar.UserInfo_ID = car.UserInfo_ID; newCar.Year = car.Year; context.AddToCar(newCar); context.SaveChanges(); return 1; } catch (Exception) { return 0; } }
public CarModel GetCarById(int id) { var car = context.Car.FirstOrDefault(c => c.ID == id); CarModel model=new CarModel(); if (car != null) { model.ID = car.ID; model.BrandName = car.BrandName; model.CarType = car.CarType; model.Color = car.Color; model.Price = car.Price; model.Status = car.Statu; model.UserInfo_ID = car.UserInfo_ID; model.Year = car.Year; return model; } else { return null; } }
/// <summary> /// 根据出售者的ID获取该用户出售的所有车辆 /// </summary> /// <param name="userid"></param> /// <returns></returns> public List<CarModel> GetCarsByUserId(int userid) { CarSaleEntities context=new CarSaleEntities(); var cars=context.Car.Where(c => c.UserInfo_ID == userid); List<CarModel> list=new List<CarModel>(); foreach (var car in cars) { CarModel model=new CarModel(); model.ID = car.ID; model.BrandName = car.BrandName; model.CarType = car.CarType; model.Color = car.Color; model.Price = car.Price; model.Status = car.Statu; model.Year = car.Year; list.Add(model); } return list; }
public CarPassportModel(CarModel car) { Car = car; }