public Motocycle GetMotocycle(int id) { SqlConnection con = new SqlConnection(_connectionString); SqlCommand command = new SqlCommand($"select * from MOTORCYCLE where MOTORCYCLE.ID = {id}", con); Motocycle resultMoto = new Motocycle(); con.Open(); SqlDataReader reader = command.ExecuteReader(); using (reader) { while (reader.Read()) { resultMoto.Id = (int)reader["Id"]; resultMoto.Model = (string)reader["Model"]; resultMoto.MotoName = (string)reader["MotoName"]; resultMoto.Year = !(reader["YearMoto"] is DBNull) ? (int)reader["YearMoto"] : 0; resultMoto.Odometer = (int)reader["Odometer"]; } } con.Close(); Console.WriteLine($"Motorcyle Id is: { resultMoto.Id.ToString()}" + $"\nModel is: { resultMoto.Model.ToString()}" + $"\nName is: { resultMoto.MotoName.ToString()}" + $"\nYear is: { resultMoto.Year.ToString()}" + $"\nOdometr is: { resultMoto.Odometer.ToString()}"); return(resultMoto); }
public void CreateMotocycle(Motocycle moto) { string query = $"insert into MOTORCYCLE values('{moto.Model}','{moto.MotoName}',{moto.Year},{moto.Odometer})"; ExecuteQuery(query); }
static void Main(string[] args) { ILog log = LogManager.GetLogger(typeof(Program)); XmlConfigurator.Configure(); log.Info("The program is running"); MotocycleRepositoryDB rep = new MotocycleRepositoryDB(); log.Info("The process of CRUD operations began"); Motocycle moto1 = new Motocycle(); Motocycle moto2 = new Motocycle(); Motocycle moto3 = new Motocycle(); moto1.Model = "Honda"; moto1.MotoName = "Gold Wings"; moto1.Odometer = 20_222; moto1.Year = 4; log.Info("The process of creating an object №1 in a database"); rep.CreateMotocycle(moto1); moto2.Model = "Susuki"; moto2.MotoName = "H450"; moto2.Odometer = 10_240; moto2.Year = 2; log.Info("The process of creating an object №2 in a database"); rep.CreateMotocycle(moto2); moto3.Model = "Susuki"; moto3.MotoName = "H450"; moto3.Odometer = 10_240; moto3.Year = 2; log.Info("The process of creating an object №3 in a database"); rep.CreateMotocycle(moto3); log.Info("The process of updating an object model in a database"); rep.UpdateMotoCycleModel(17, "X250"); log.Info("The process of updating an object name in a database"); rep.UpdateMotoCycleName(17, "Minsk"); try { log.Debug("Error search"); rep.UpdateMotoCycleName(-1, "Kawasaki"); } catch { log.Error("Update operation failed, no object detected"); } log.Info("The process of updating an object year in a database"); rep.UpdateMotoCycleYear(17, 2018); log.Info("The process of updating an object odometer reading in a database"); rep.UpdateMotoCycleOdometer(17, 21001); try { log.Debug("Error search"); rep.GetMotocycle(0); } catch { log.Error("The object does not exist in the database"); } log.Info("The process of getting an object from a database"); rep.GetMotocycle(18); log.Info("The process of deleting an object from a database"); rep.DeleteMotocycle(19); try { log.Debug("Error search"); rep.DeleteMotocycle(1); } catch { log.Error("The object does not exist in the database"); } log.Info("The program is ended"); Console.ReadLine(); }