public void CreateCar(Car car) { using (var uow = new UnitOfWork(_appConfigConnection)) { uow.CarRepository.Create(car); } }
/// <summary> /// Create new car record /// </summary> /// <param name="car">Car model</param> public void Create(Car car) { using (var command = new SqlCommand("sp_CreateCar", _connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Brand", car.CarBrand); command.Parameters.AddWithValue("@Year", car.CarYear); command.Parameters.AddWithValue("@StartWorkTime", car.StartWorkTime); command.Parameters.AddWithValue("@FinishWorkTime", car.FinishWorkTime); command.Parameters.AddWithValue("@Latitude", car.Latitude); command.Parameters.AddWithValue("@Longitude", car.Longitude); command.Parameters.AddWithValue("@CarId", car.Id); command.ExecuteNonQuery(); } }
public static Car Map(SqlDataReader record) { if (record == null) throw new ArgumentNullException("record"); var car = new Car { Id = (int)record["Id"], CarBrand = (string)record["Brand"], CarYear = (string)record["Year"], StartWorkTime = (DateTime)record["StartWorkTime"], FinishWorkTime = (DateTime)record["FinishWorkTime"], Latitude = (string)record["Latitude"], Longitude = (string)record["Longitude"] }; return car; }
/// <summary> /// Get car by id /// </summary> /// <param name="id"></param> /// <returns></returns> public Car GetCarById(int id) { using (var command = new SqlCommand("sp_GetCarById", _connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@CarID", id); var findCar = new Car(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var car = CarMapper.Map(reader); findCar = car; } } return findCar; } }
public bool IsCarIdBooked(int id) { using (var command = new SqlCommand("sp_GetCarById", _connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@CarID", id); var car = new Car(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { car = CarMapper.Map(reader); } } if (car.Id == id) { return true; } } return false; }
protected void btnSaveEdit_Click(object sender, EventArgs e) { IAdminBl adminBl = HttpContext.Current.Application.GetContainer().Resolve<IAdminBl>(); string UserId; if (hiddenId.Value != "") { UserId = hiddenId.Value; hiddenId.Value = ""; } else { UserId = tbxFindTaxiDriverByCategory.Text; } var updatedUser = new User() { Id = Convert.ToInt32(UserId), UserName = tbxEditTaxiDriverName.Text, LastName = tbxEditLastName.Text, Login = tbxEditLogin.Text, PhoneNumber = tbxEditPhoneNumber.Text, Email = tbxEditEmail.Text, Password = tbxEditPassword.Text, Role = (int)RolesEnum.Driver, Status = (int)Enum.Parse(typeof(UserStatusEnum), ddlEditStatus.Text), DriverStatus = (int?)DriverStatusEnum.Free }; if (!adminBl.IsLoginBookedByOtherId(updatedUser.Login, updatedUser.Id)) { adminBl.UpdateUser(updatedUser); var updatedCar = new Car() { Id = updatedUser.Id, CarBrand = tbxCarBrand.Text, CarYear = tbxCarYear.Text, StartWorkTime = DateTime.Parse(tbxCarStartWorkTime.Text), FinishWorkTime = DateTime.Parse(tbxCarFinishWorkTime.Text), Latitude = tbxCarLatitude.Text, Longitude = tbxCarLongitude.Text }; if (adminBl.IsCarIdBooked(updatedCar.Id)) { adminBl.UpdateCar(updatedCar); } else { adminBl.CreateCar(updatedCar); } Response.Redirect("~/WebForms/TaxiDrivers.aspx"); } else { loginBooked.InnerText = "Login is booked!"; } }