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