/// <summary> /// Загружает вид ремонта. /// </summary> /// <param name="reader"></param> /// <returns></returns> private static TypeRepair LoadRepair(SqlDataReader reader) { TypeRepair typeRepair = new TypeRepair(); try { typeRepair.Note = reader.GetString(reader.GetOrdinal("Note")); typeRepair.NameRepair = reader.GetString(reader.GetOrdinal("NameRepairs")); typeRepair.IDRepair = reader.GetInt32(reader.GetOrdinal("IDRepair")); object decease1 = reader["Length"]; if (decease1 != DBNull.Value) { typeRepair.Lenght = Convert.ToDouble(decease1); } object decease2 = reader["Cost"]; if (decease2 != DBNull.Value) { typeRepair.Cost = Convert.ToDouble(decease2); } } catch (Exception exc) { MessageBox.Show(exc.Message, "Ошибка"); } return(typeRepair); }
/// <summary> /// Добавляет текущий вид ремонта. /// </summary> /// <param name="typeRepair"></param> public void Add(TypeRepair typeRepair) { try { using (var conn = GetConnection()) { conn.Open(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = "INSERT INTO TypeRepair(Note, NameRepairs, Length, Cost) VALUES(@Note, @NameRepair, @Lenght, @Cost)"; cmd.Parameters.AddWithValue("@Note", typeRepair.Note); cmd.Parameters.AddWithValue("@NameRepair", typeRepair.NameRepair); object decease1 = typeRepair.Lenght.HasValue ? (object)typeRepair.Lenght.Value : DBNull.Value; cmd.Parameters.AddWithValue("@Lenght", decease1); object decease2 = typeRepair.Cost.HasValue ? (object)typeRepair.Cost.Value : DBNull.Value; cmd.Parameters.AddWithValue("@Cost", decease2); cmd.ExecuteNonQuery(); } } } catch (Exception exc) { MessageBox.Show(exc.Message, "Ошибка"); } }
/// <summary> /// Обновляет текущий вид ремонта. /// </summary> /// <param name="typeRepair"></param> public void Update(TypeRepair typeRepair) { try { using (var conn = GetConnection()) { conn.Open(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = "UPDATE TypeRepair SET Note = @Note, NameRepairs = @NameRepairs, Length=@Length, Cost=@Cost WHERE IDRepair = @ID1"; cmd.Parameters.AddWithValue("@Note", typeRepair.Note); cmd.Parameters.AddWithValue("@NameRepairs", typeRepair.NameRepair); cmd.Parameters.AddWithValue("@ID1", typeRepair.IDRepair); object decease1 = typeRepair.Lenght.HasValue ? (object)typeRepair.Lenght.Value : DBNull.Value; cmd.Parameters.AddWithValue("@Length", decease1); object decease2 = typeRepair.Cost.HasValue ? (object)typeRepair.Cost.Value : DBNull.Value; cmd.Parameters.AddWithValue("@Cost", decease2); cmd.ExecuteNonQuery(); } } } catch (Exception exc) { MessageBox.Show(exc.Message, "Ошибка"); } }