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); }