// Pobieranie z bazy produktów oraz adresu na podstawie ID zamówienia wybranego z historii zamówień
public string GetOrderDetails(OrderObject orderObject)
{
AddressObject address = _conDB.GetAddress(orderObject.ID);
List <OrderProductObject> products = _conDB.GetProducts(orderObject.ID);
return(OrderLogic.CreateOrderDetails(orderObject, address, products));
}
// Funkcja odpowiedzialna za utworzenie zamówienia i wysłanie maila. Zapisuje wszystkie dane na temat zamówienia, produktów i adresu do bazy a następnie wysyła maila z zamówieniem.
public void CreateOrder(OrderObject orderObject, AddressObject addressObject, List <OrderProductObject> products)
{
string date = orderObject.OrderDate;
string sql = string.Format("insert into Orders (Email, Price, ProductCount, OrderDate, Attention) values ('{0}', '{1}', {2}, '{3}', '{4}')",
orderObject.Email, orderObject.Price, orderObject.ProductCount, date, orderObject.AttentionToOrder);
long orderFk = _connectDB.InsertOrderToDatabase(sql);
orderObject.ID = (int)orderFk;
sql = string.Format("insert into Address (Street, HouseNumber, FlatNumber, City, PhoneNumber, OrderFK) values ('{0}', '{1}', '{2}', '{3}', {4}, {5})",
addressObject.Street, addressObject.HouseNumber, addressObject.FlatNumber, addressObject.City, addressObject.PhoneNumber, orderFk);
_connectDB.ExecuteSql(sql);
foreach (OrderProductObject product in products)
{
sql = string.Format("insert into Product (Name, OrderFK) values ('{0}', {1})", product.Name, orderFk);
_connectDB.ExecuteSql(sql);
}
string subject = string.Format(Resources.OrderNumber_Message, orderFk);
string body = OrderLogic.CreateOrderDetails(orderObject, addressObject, products);
SendMail(subject, body, orderObject.Email);
}
