public static CarForRentModel ToObject(DataRow reader) { DateTime dateValue; CarForRentModel carForRentModel = new CarForRentModel(); carForRentModel.rentStartDate = DateTime.Parse(reader[0].ToString()); carForRentModel.rentEndDate = DateTime.Parse(reader[1].ToString()); if (DateTime.TryParse(reader[2].ToString(), out dateValue)) { carForRentModel.rentRealEndDate = DateTime.Parse(reader[2].ToString()); } else { carForRentModel.rentRealEndDate = null; } carForRentModel.userID = reader[3].ToString(); carForRentModel.carNumber = reader[4].ToString(); carForRentModel.rentNumber = int.Parse(reader[5].ToString()); Debug.WriteLine("carForRentModel: " + carForRentModel.ToString()); return(carForRentModel); }
public IActionResult AddCarForRent(CarForRentModel carForRentModel) { try { if (carForRentModel == null) { return(BadRequest("Data is null.")); } if (!ModelState.IsValid) { Errors errors = ErrorsHelper.GetErrors(ModelState); return(BadRequest(errors)); } string id = User.Identity.Name; carForRentModel.userID = id; CarForRentModel addedCarForRent = carForRentRepository.AddCarForRent(carForRentModel); return(StatusCode(StatusCodes.Status201Created, addedCarForRent)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(StatusCode(StatusCodes.Status500InternalServerError, errors)); } }
static public MySqlCommand UpdateCarForRent(CarForRentModel carForRentModel) { if (GlobalVariable.queryType == 0) { return(CreateSqlCommand(carForRentModel, queryCarForRentUpdate)); } else { return(CreateSqlCommand(carForRentModel, procedureCarForRentUpdate)); } }
public CarForRentModel UpdateCarForRent(CarForRentModel carForRentModel) { if (carForRentModel.rentRealEndDate == null) { carForRentModel.rentRealEndDate = carForRentModel.rentStartDate.AddDays(-36); } _carsForRent.ReplaceOne(carsForRent => carsForRent.rentNumber == carForRentModel.rentNumber, carForRentModel); CarForRentModel tmpCarForRentModel = GetOneCarForRentByRentNumber(carForRentModel.rentNumber); return(tmpCarForRentModel); }
public CarForRentModel AddCarForRent(CarForRentModel carForRentModel) { if (carForRentModel.rentRealEndDate == null) { carForRentModel.rentRealEndDate = carForRentModel.rentStartDate.AddDays(-36); } _carsForRent.InsertOne(carForRentModel); CarForRentModel tmpCarForRentModel = GetOneCarForRentByRentNumber(carForRentModel.rentNumber); return(tmpCarForRentModel); }
static private MySqlCommand CreateSqlCommand(CarForRentModel carForRent, string commandText) { MySqlCommand command = new MySqlCommand(commandText); command.Parameters.AddWithValue("@rentNumber", carForRent.rentNumber); command.Parameters.AddWithValue("@userID", carForRent.userID); command.Parameters.AddWithValue("@carNumber", carForRent.carNumber); command.Parameters.AddWithValue("@rentStartDate", carForRent.rentStartDate); command.Parameters.AddWithValue("@rentEndDate", carForRent.rentEndDate); command.Parameters.AddWithValue("@rentRealEndDate", carForRent.rentRealEndDate.HasValue ? carForRent.rentRealEndDate : carForRent.rentStartDate.AddDays(-36)); return(command); }
public CarForRentModel AddCarForRent(CarForRentModel carForRentModel) { DataTable dt = new DataTable(); CarForRentModel carForRentModelSql = new CarForRentModel(); using (MySqlCommand command = new MySqlCommand()) { dt = GetMultipleQuery(CarForRentStringsMySql.AddCarForRent(carForRentModel)); } foreach (DataRow ms in dt.Rows) { carForRentModelSql = CarForRentModel.ToObject(ms); } return(carForRentModelSql); }
public List <CarForRentModel> GetAllCarsForRent() { DataTable dt = new DataTable(); List <CarForRentModel> arrCarsForRent = new List <CarForRentModel>(); using (MySqlCommand command = new MySqlCommand()) { dt = GetMultipleQuery(CarForRentStringsMySql.GetAllCarsForRent()); } foreach (DataRow ms in dt.Rows) { arrCarsForRent.Add(CarForRentModel.ToObject(ms)); } return(arrCarsForRent); }
public CarForRentModel GetOneCarForRentByRentNumber(int rentNumber) { if (rentNumber < 0) { throw new ArgumentOutOfRangeException(); } DataTable dt = new DataTable(); CarForRentModel carForRentModelSql = new CarForRentModel(); using (MySqlCommand command = new MySqlCommand()) { dt = GetMultipleQuery(CarForRentStringsMySql.GetOneCarForRentByRentNumber(rentNumber)); } foreach (DataRow ms in dt.Rows) { carForRentModelSql = CarForRentModel.ToObject(ms); } return(carForRentModelSql); }
public List <CarForRentModel> GetCarsForRentByCarNumber(string carNumber) { if (carNumber.Equals("")) { throw new ArgumentOutOfRangeException(); } DataTable dt = new DataTable(); List <CarForRentModel> arrCarsForRent = new List <CarForRentModel>(); using (MySqlCommand command = new MySqlCommand()) { dt = GetMultipleQuery(CarForRentStringsMySql.GetAllCarsForRentByCarNumber(carNumber)); } foreach (DataRow ms in dt.Rows) { arrCarsForRent.Add(CarForRentModel.ToObject(ms)); } return(arrCarsForRent); }
public CarForRentModel UpdateCarForRent(CarForRentModel carForRentModel) { string id = ""; //string id = HttpContext.Current.User.Identity.Name; carForRentModel.userID = id; DataTable dt = new DataTable(); CarForRentModel carForRentModelSql = new CarForRentModel(); using (MySqlCommand command = new MySqlCommand()) { dt = GetMultipleQuery(CarForRentStringsMySql.UpdateCarForRent(carForRentModel)); } foreach (DataRow ms in dt.Rows) { carForRentModelSql = CarForRentModel.ToObject(ms); } return(carForRentModelSql); }
public IActionResult UpdateForRent(int number, CarForRentModel carForRentModel) { try { if (carForRentModel == null) { return(BadRequest("Data is null.")); } if (!ModelState.IsValid) { Errors errors = ErrorsHelper.GetErrors(ModelState); return(BadRequest(errors)); } carForRentModel.rentNumber = number; CarForRentModel updatedCarForRent = carForRentRepository.UpdateCarForRent(carForRentModel); return(Ok(updatedCarForRent)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(StatusCode(StatusCodes.Status500InternalServerError, errors)); } }