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