public Order(GeneralInfo.OrderStatus orderStatus, double price, Manager orderManager, Client orderClient, Product orderProduct, int count)
{
OrderStatus = orderStatus;
Price = price;
OrderManager = orderManager;
OrderClient = orderClient;
OrderProduct = orderProduct;
Count = count;
Id = GeneralInfo.DataProvider.AddNewOrder(this);
}
public Order(int newId, GeneralInfo.OrderStatus orderStatus, double price, Manager orderManager, Client orderClient, Product orderProduct, int count)
{
OrderStatus = orderStatus;
Price = price;
OrderManager = orderManager;
OrderClient = orderClient;
OrderProduct = orderProduct;
Count = count;
Id = newId;
}
public Order FindById(int id)
{
conn.Open();
string sql = "SELECT `id`, `status`, `price`, `id_man`, `id_cl`, `id_prod`, `count` FROM `storedb`.`orders` WHERE id = " + id.ToString();
MySqlCommand command = new MySqlCommand(sql, conn);
MySqlDataReader reader = command.ExecuteReader();
List <Order> answer = new List <Order>();
while (reader.Read())
{
int newId = Convert.ToInt32(reader[0].ToString());
GeneralInfo.OrderStatus st = (GeneralInfo.OrderStatus)Convert.ToInt32(reader[1].ToString());
double price = Convert.ToDouble(reader[2].ToString());
Manager mgId = GeneralInfo.DataProvider.GetManager(Convert.ToInt32(reader[3].ToString()));
Client clId = GeneralInfo.DataProvider.GetClient(Convert.ToInt32(reader[4].ToString()));
Product prId = GeneralInfo.DataProvider.GetProduct(Convert.ToInt32(reader[5].ToString()));
int count = Convert.ToInt32(reader[6].ToString());
answer.Add(new Order(newId, st, price, mgId, clId, prId, count));
}
reader.Close();
conn.Close();
return(answer[0]);
}
public void SetStatus(GeneralInfo.OrderStatus newStatus)
{
OrderStatus = newStatus;
GeneralInfo.DataProvider.UpdateOrder(this);
}
