/// <summary>
/// Добавляет нового агента в базу данных
/// </summary>
/// <param name="c">Контрагент для добавления</param>
public static void AddContractor(Contractor c)
{
using (SqliteConnection database = new SqliteConnection($"Filename={DatabasePath}"))
{
database.Open();
SqliteCommand insertCommand = new SqliteCommand("INSERT INTO ContractorTable " +
"(Name, Phonenumber, Email, Photo)" +
"VALUES (@name, @phonenumber, @email, @photo)", database);
insertCommand.Parameters.AddWithValue("@name", c.Name);
insertCommand.Parameters.AddWithValue("@phonenumber", c.PhoneNumber);
insertCommand.Parameters.AddWithValue("@email", c.Email);
byte[] photo = XamlImageConverter.ConvertToByteArray(c.Photo);
if (photo == null)
{
insertCommand.Parameters.AddWithValue("@photo", DBNull.Value);
}
else
{
insertCommand.Parameters.AddWithValue("@photo", photo);
}
insertCommand.ExecuteReader();
c.ID = Convert.ToInt32(new SqliteCommand("SELECT MAX(ID) FROM ContractorTable", database).ExecuteScalar());
database.Close();
}
}
/// <summary>
/// Обновляет данные о контрагенте, присутствующем в базе данных
/// </summary>
/// <param name="c">Объект контрагента, данные которого подлежат обновлению</param>
public static void UpdateContractor(Contractor c)
{
using (SqliteConnection database = new SqliteConnection($"Filename={DatabasePath}"))
{
database.Open();
SqliteCommand updateCommand = new SqliteCommand("UPDATE ContractorTable SET Name=@name, Phonenumber=@phonenumber," +
" Email=@email, Photo=@photo WHERE ID=@id", database);
updateCommand.Parameters.AddWithValue("@id", c.ID);
updateCommand.Parameters.AddWithValue("@name", c.Name);
updateCommand.Parameters.AddWithValue("@phonenumber", c.PhoneNumber);
updateCommand.Parameters.AddWithValue("@email", c.Email);
byte[] photo = XamlImageConverter.ConvertToByteArray(c.Photo);
if (photo == null)
{
updateCommand.Parameters.AddWithValue("@photo", DBNull.Value);
}
else
{
updateCommand.Parameters.AddWithValue("@photo", photo);
}
updateCommand.ExecuteReader();
database.Close();
}
}
