public List <CarDM> getStatusControlCar(int ID, DateTime StartDate, DateTime EndDate)
{
List <CarDM> carList = new List <CarDM>();
DBUtilities utility = new DBUtilities();
utility.cn.Open();
utility.cmd.CommandText = "sp_StatusControl";
utility.cmd.Parameters.Add("CarID", ID);
utility.cmd.Parameters.Add("StartDate", StartDate);
utility.cmd.Parameters.Add("EndDate", EndDate);
utility.cmd.ExecuteScalar();
SqlDataReader dr = utility.cmd.ExecuteReader();
while (dr.Read())
{
CarDM cdm = new CarDM();
cdm.ID = Convert.ToInt32(dr["ID"]);
cdm.status = dr["Status"].ToString();
carList.Add(cdm);
}
dr.Close();
utility.endC();
return(carList);
}
public List <CarDM> popCar()
{
List <CarDM> carList = new List <CarDM>();
DBUtilities utility = new DBUtilities();
utility.cn.Open();
utility.cmd.CommandText = "sp_popCar";
utility.cmd.ExecuteScalar();
SqlDataReader dr = utility.cmd.ExecuteReader();
while (dr.Read())
{
CarDM cdm = new CarDM();
cdm.ID = Convert.ToInt32(dr["ID"]);
cdm.licensePlate = dr["LicensePlate"].ToString();
cdm.chassisNumber = dr["ChassisNumber"].ToString();
cdm.color = dr["Color"].ToString();
cdm.amount = dr["Amount"].ToString();
cdm.brand = dr["BrandName"].ToString();
cdm.model = dr["ModelName"].ToString();
cdm.status = dr["Status"].ToString();
cdm.model_year = dr["ModelYear"].ToString();
carList.Add(cdm);
}
dr.Close();
utility.endC();
return(carList);
}
public List <CarDM> getByDateCarList(DateTime StartDate, DateTime EndDate)
{
List <CarDM> carList = new List <CarDM>();
DBUtilities utility = new DBUtilities();
utility.cn.Open();
utility.cmd.CommandText = "sp_getByDateCar";
utility.cmd.Parameters.Add("StartDate", StartDate);
utility.cmd.Parameters.Add("EndDate", EndDate);
utility.cmd.ExecuteScalar();
SqlDataReader dr = utility.cmd.ExecuteReader();
while (dr.Read())
{
CarDM cdm = new CarDM();
cdm.ID = Convert.ToInt32(dr["ID"]);
cdm.licensePlate = dr["LicensePlate"].ToString();
cdm.chassisNumber = dr["ChassisNumber"].ToString();
cdm.amount = dr["ToplamTutar"].ToString();
cdm.color = dr["Color"].ToString();
carList.Add(cdm);
}
dr.Close();
utility.endC();
return(carList);
}
/// <summary>
/// Show view for update car.
/// </summary>
/// <param name="id">Car id</param>
/// <returns>View</returns>
public ActionResult UpdateCar(int?id)
{
if (id == null)
{
return(View("CustomNotFound", "_Layout", "Автомобиль не найден"));
}
var carDTO = _rentService.GetCar(id);
if (carDTO == null)
{
return(View("CustomNotFound", "_Layout", "Автомобиль не найден"));
}
CarDM car = _rentMapperDM.ToCarDM.Map <CarDTO, CarDM>(carDTO);
return(View("CreateCar", new CreateVM()
{
Car = car
}));
}
public void AddCar(CarDM car)
{
DBUtilities utility = new DBUtilities();
utility.cn.Open();
utility.cmd.CommandText = "sp_InsertCar";
utility.cmd.Parameters.Add("brand", car.brand);
utility.cmd.Parameters.Add("model", car.model);
utility.cmd.Parameters.Add("model_year", car.model_year);
utility.cmd.Parameters.Add("LicensePlate", car.licensePlate);
utility.cmd.Parameters.Add("ChassisNumber", car.chassisNumber);
utility.cmd.Parameters.Add("color", car.color);
utility.cmd.Parameters.Add("type", car.type);
utility.cmd.Parameters.Add("amount", car.amount);
utility.cmd.Parameters.Add("amountType", car.amountType);
utility.cmd.Parameters.Add("status", car.status);
utility.cmd.ExecuteScalar();
utility.endC();
}
public ActionResult UpdateCar(CreateVM model)
{
if (model.Car.DateOfCreate.Date > DateTime.Now.Date ||
model.Car.DateOfCreate.Date < DateTime.Now.AddYears(-30).Date)
{
ModelState.AddModelError("Car.DateOfCreate", "Неверная дата");
}
if (ModelState.IsValid)
{
CarDTO carDTO = _createCarDTO(model);
_adminService.UpdateCar(carDTO);
_logWriter.CreateLog("Обновил данные про автомобиль " + model.Car.Id, User.Identity.GetUserId());
return(RedirectToAction("GetCars"));
}
CarDM car = _rentMapperDM.ToCarDM.Map <CarDTO, CarDM>(_rentService.GetCar(model.Car.Id));
model.Car.Properties = car.Properties;
model.Car.Images = car.Images;
return(View("CreateCar", model));
}
