public void ExportPDF(string customer, string id, string state)
{
Kitbox.Models.Database.Json.Order orderJson = new Kitbox.Models.Database.Json.Order();
DataTable dtbl = Kitbox.PDF.PDFUtils.MakeBill(OurOrder, orderJson);
UpdateStock(customer, id, orderJson.Command, state);
float cost = Kitbox.PDF.PDFUtils.CalculateCost(OurOrder, orderJson);
CreateAndOpenPDF(dtbl, customer, id, cost, state);
}
public static DataTable MakeBill(Order order, Kitbox.Models.Database.Json.Order orderDataBase)
{
DataTable bill = new DataTable();
float TotalBill = 0;
//Define columns
bill.Columns.Add("Code");
bill.Columns.Add("Pièce");
bill.Columns.Add("Dimension");
bill.Columns.Add("Quantité");
bill.Columns.Add("Prix unitaire (€)");
bill.Columns.Add("Prix total (€)");
List <List <string> > a = order.MakeOrder();
foreach (List <string> item in a)
{
float cost = 1;
string price = "";
MySqlConnection conn = MethodsDB.DBUtils.GetDBConnection("customer", "groupe2020");
conn.Open();
MySqlDataReader reader = MethodsDB.DataBaseMethods.SqlSearch("Piece", "Code", string.Format("'{0}'", item[0]), conn);
while (reader.Read())
{
price = reader["Prix-Client"].ToString();
}
cost *= Int32.Parse(item[3]) * float.Parse(price);
TotalBill += cost;
reader.Close();
conn.Close();
Console.WriteLine(price);
item.Add(price);
item.Add(cost.ToString());
Console.WriteLine(item[4]);
bill.Rows.Add(item.ToArray());
//Création du JSON
orderDataBase.Command.Add(item[0], Int32.Parse(item[3]));
}
return(bill);
}
public static float CalculateCost(Order order, Kitbox.Models.Database.Json.Order orderDataBase)
{
float TotalBill = 0;
foreach (List <string> item in order.MakeOrder())
{
float cost = 1;
string price = "";
MySqlConnection conn = MethodsDB.DBUtils.GetDBConnection("customer", "groupe2020");
conn.Open();
MySqlDataReader reader = MethodsDB.DataBaseMethods.SqlSearch("Piece", "Code", string.Format("'{0}'", item[0]), conn);
while (reader.Read())
{
price = reader["Prix-Client"].ToString();
}
cost *= Int32.Parse(item[3]) * float.Parse(price);
TotalBill += cost;
reader.Close();
}
return(TotalBill);
}
