// UPDATE - TRANSAKCJA /// <summary> /// Edytuje wpis -> Transakcja /// </summary> /// <param name="personModel"></param> public static void Edit(PersonModel personModel) { var sqlCommand = new SqlCommand(); // Gdy ktoś nie poda mail-a if (string.IsNullOrWhiteSpace(personModel.Email)) { sqlCommand.CommandText = @"UPDATE People SET FirstName = @FirstName, LastName = @LastName, Phone = @Phone, Email = null, Updated = GETDATE() WHERE ID = @ID;" ; } // Gdy ktoś poda mail else { sqlCommand.CommandText = @"UPDATE People SET FirstName = @FirstName, LastName = @LastName, Phone = @Phone, Email = @Email, Updated = GETDATE() WHERE ID = @ID;" ; // Dodawanie mail-a AddEmailParam(sqlCommand, personModel); } // Dodawanie pozostałych parametrów AddNamesAndPhoneParam(sqlCommand, personModel); // Dodanie parametru ID AddIDParam(sqlCommand, personModel.ID); // Transakcja SqlTransactionTool.Transaction(sqlCommand); }
// INSERT - TRANSAKCJA /// <summary> /// Dodaje nowy wpis -> Transakcja /// </summary> /// <param name="personModel"></param> public static void Add(PersonModel personModel) { var sqlCommand = new SqlCommand(); // Gdy ktoś nie poda mail-a if (string.IsNullOrWhiteSpace(personModel.Email)) { sqlCommand.CommandText = @"INSERT INTO People (FirstName, LastName, Phone, Email, Created, Updated) VALUES (@FirstName, @LastName, @Phone, null, GETDATE(), null); SELECT CAST(scope_identity() AS int)" ; } // Gdy ktoś poda mail else { sqlCommand.CommandText = @"INSERT INTO People (FirstName, LastName, Phone, Email, Created, Updated) VALUES (@FirstName, @LastName, @Phone, @Email, GETDATE(), null); SELECT CAST(scope_identity() AS int)" ; // Dodawanie mail-a AddEmailParam(sqlCommand, personModel); } // Dodawanie pozostałych parametrów AddNamesAndPhoneParam(sqlCommand, personModel); // Transakcja SqlTransactionTool.Transaction(sqlCommand); }
// DELETE - TRANSAKCJA /// <summary> /// Usuń wpis -> Transakcja /// </summary> /// <param name="personModel"></param> public static void Remove(PersonModel personModel) { var sqlCommand = new SqlCommand(); // Komenda sqlCommand.CommandText = @"DELETE FROM People WHERE ID = @ID;"; // Dodanie parametru ID AddIDParam(sqlCommand, personModel.ID); // Transakcja SqlTransactionTool.Transaction(sqlCommand); }