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);
}
