public bool Delete(Servcabs servcabsData) { bool isSuccess = false; SqlConnection conn = DBUtils.GetDBConnection(); try { string sqlExpression = "DELETE FROM servcabs WHERE cab_num=@cab_num AND serv_id=@serv_id"; SqlCommand command = new SqlCommand(sqlExpression, conn); command.Parameters.AddWithValue("@cab_num", servcabsData.Cab_num); command.Parameters.AddWithValue("@serv_id", servcabsData.Serv_id); conn.Open(); int rows = command.ExecuteNonQuery(); // если все ок, значение строк будут > 0 if (rows > 0) { isSuccess = true; } } catch (Exception ex) { MessageBox.Show("Произошла ошибка при удалении", "Ошибка", MessageBoxButtons.OK); } finally { conn.Close(); } return(isSuccess); }
public bool Insert(Servcabs servcabsData) { bool isSuccess = false; SqlConnection conn = DBUtils.GetDBConnection(); try { string sqlExpression = "INSERT INTO servcabs (cab_num, serv_id) VALUES (@cab_num, @serv_id)"; SqlCommand command = new SqlCommand(sqlExpression, conn); command.Parameters.AddWithValue("@cab_num", servcabsData.Cab_num); command.Parameters.AddWithValue("@serv_id", servcabsData.Serv_id); conn.Open(); int rows = command.ExecuteNonQuery(); // если все ок, значение строк будут > 0 if (rows > 0) { isSuccess = true; } } catch (Exception ex) { MessageBox.Show($"Произошла ошибка при добавлении {ex}", "Ошибка", MessageBoxButtons.OK); } finally { conn.Close(); } return(isSuccess); }