/// <summary>
/// Удаляет из БД указанную записи
/// </summary>
public static int DeleteRecord(ChangeRecordParams parameters)
{
using (var connection = new SqlConnection(CONNECTION_STRING))
{
connection.Open();
return(new SqlCommand($"DELETE FROM Invoice.dbo.Main_table WHERE ID = {parameters.id}", connection).ExecuteNonQuery());
}
}
/// <summary>
/// Изменяет данные указанной записи
/// </summary>
public static int ChangeRecord(ChangeRecordParams parameters)
{
using (var connection = new SqlConnection(CONNECTION_STRING))
{
connection.Open();
return(new SqlCommand($"UPDATE Invoice.dbo.Main_table SET Date = '{parameters.date}', LastName = '{parameters.last_name}', FirstName = '{parameters.first_name}'," +
$"Patronymic = '{parameters.patronymic}', Sum = {parameters.sum.ToString().Replace(',', '.')} WHERE ID = {parameters.id}", connection).ExecuteNonQuery());
}
}
/// <summary>
/// Добаваляет в БД данные указанной записи
/// </summary>
public static int AddRecord(ChangeRecordParams parameters)
{
using (var connection = new SqlConnection(CONNECTION_STRING))
{
connection.Open();
object current_id = new SqlCommand("SELECT MAX(ID) FROM Main_table", connection).ExecuteScalar();
current_id = Convert.DBNull == current_id ? 0 : Convert.ToInt32(current_id) + 1;//новый ID должен быть на единицу больше текущего в БД
return(new SqlCommand($"INSERT INTO Main_table VALUES({current_id}, '{parameters.date}', '{parameters.last_name}', '{parameters.first_name}'," +
$" '{parameters.patronymic}', {parameters.sum.ToString().Replace(',', '.')})", connection).ExecuteNonQuery());
}
}
