/// <summary>
/// Помечает клиента как удалённого.
/// </summary>
/// <param name="CustomerToDelete"></param>
public void DeleteCustomer(CustomerClass CustomerToDelete)
{
using (SQLiteConnection DBConnection = new SQLiteConnection("data source=" + DBFileName))
{
DBConnection.Open();
using (SQLiteCommand Command = new SQLiteCommand(DBConnection))
{
Command.CommandText = @"UPDATE client SET deleted = 1 WHERE ID = " + CustomerToDelete.IDcustomer + ";";
MyDBLogger("Delete customer by ID: " + Command.CommandText);
Command.ExecuteNonQuery();
}
}
}
/// <summary>
/// Редактирует в базе клиента. Автор: Марина.
/// </summary>
public void EditCustomerDB(CustomerClass EditCustomer)
{
using (SQLiteConnection DBConnection = new SQLiteConnection("data source=" + DBFileName))
{
DBConnection.Open();
using (SQLiteCommand Command = new SQLiteCommand(DBConnection))
{
Command.CommandText = @"UPDATE client SET name = '" + EditCustomer.FIOcustomer.ToUpper() + "', " +
"phoneNumber ='" + EditCustomer.PhoneCustomer + "', " +
"city = '" + EditCustomer.CityCustomer + "' " +
"WHERE ID = '" + EditCustomer.IDcustomer + "';";
MyDBLogger("Edit client whis SQL-command: " + Command.CommandText);
Command.ExecuteNonQuery();
}
}
}
/// <summary>
/// Записывает в базу нового клиента.
/// </summary>
/// <param name="NewCostomer"></param>
public void AddNewCustomerDB(CustomerClass NewCostomer)
{
using (SQLiteConnection DBConnection = new SQLiteConnection("data source=" + DBFileName))
{
DBConnection.Open();
using (SQLiteCommand Command = new SQLiteCommand(DBConnection))
{
Command.CommandText = @"INSERT INTO client (name, phoneNumber, city) VALUES ('" +
NewCostomer.FIOcustomer.ToUpper() + "','" +
NewCostomer.PhoneCustomer + "','" +
NewCostomer.CityCustomer.ToUpper() + "');";
MyDBLogger("Create client with SQL-command: " + Command.CommandText);
Command.ExecuteNonQuery();
}
}
}
/// <summary>
/// Считывает из базы клиента. Автор: Марина.
/// </summary>
public CustomerClass ReadCustomerDB(string CustomerID)
{
CustomerClass ReadedCustomer = new CustomerClass();
ReadedCustomer.IDcustomer = CustomerID;
using (SQLiteConnection DBConnection = new SQLiteConnection("data source=" + DBFileName))
{
DBConnection.Open();
using (SQLiteCommand Command = new SQLiteCommand(DBConnection))
{
// Считываем информацию о водителе
Command.CommandText = @"SELECT name, phoneNumber, city FROM client WHERE ID = '" + ReadedCustomer.IDcustomer + "';";
MyDBLogger("Select Client by ID: " + Command.CommandText);
using (SQLiteDataReader Reader = Command.ExecuteReader())
{
Reader.Read();
ReadedCustomer.FIOcustomer = Reader.GetString(0);
ReadedCustomer.PhoneCustomer = Reader.GetValue(1).ToString();
ReadedCustomer.CityCustomer = Reader.GetString(2);
}
}
}
return(ReadedCustomer);
}