private void frmManageMenu_Load(object sender, EventArgs e) { this.Text = "Reporting"; if (clientnamE == "PO") { this.Text = clientnamE + " event"; CrystalReport2 eventss = new CrystalReport2(); eventss.SetDataSource(eventDetails); CrystalDecisions.Shared.ExcelFormatOptions XLSFormatOptions = new CrystalDecisions.Shared.ExcelFormatOptions(); XLSFormatOptions.ShowGridLines = true; XLSFormatOptions.ExportPageBreaksForEachPage = true; crystalReportViewer1.ReportSource = eventss; } else if (clientnamE == "Summary") { this.Text = clientnamE + " event"; SummaryReport eventss = new SummaryReport(); eventss.SetDataSource(eventDetails); crystalReportViewer1.ReportSource = eventss; } else if (clientnamE == "OverallReport") { this.Text = "Selected events Summary"; OverallReport eventss = new OverallReport(); eventss.SetDataSource(eventDetails); crystalReportViewer1.ReportSource = eventss; } else { CrystalReport1 eventss = new CrystalReport1(); int exportFormatFlags = (int)(CrystalDecisions.Shared.ViewerExportFormats.PdfFormat | CrystalDecisions.Shared.ViewerExportFormats.ExcelFormat); crystalReportViewer1.AllowedExportFormats = exportFormatFlags; eventss.SetDataSource(eventDetails); crystalReportViewer1.ReportSource = eventss; } }
private void dateTimePicker2_ValueChanged(object sender, EventArgs e) { SupplierBL BL = new SupplierBL(); SupplierBO BO = new SupplierBO(); RecBO = new RecipeBO(); RecBL = new RecipeBL(); IngBO = new IngredientBO(); IngBL = new IngredientBL(); CatBO = new CateringBO(); CatBL = new CateringBL(); DataTable eventdetail; DataTable eventDishes; DataTable dishesrecipe; DataTable Others = new DataTable(); Others.Columns.Add("1"); Others.Columns.Add("2"); Others.Columns.Add("3"); Others.Columns.Add("4"); Others.Columns.Add("5"); Others.Columns.Add("6"); DataTable ingredients = new DataTable(); ingredients.Columns.Add("1", typeof(String)); ingredients.Columns.Add("2"); ingredients.Columns.Add("3"); ingredients.Columns.Add("4"); ingredients.Columns.Add("5"); ingredients.Columns.Add("6"); ingredients.PrimaryKey = new DataColumn[] { ingredients.Columns["1"] }; DataTable popoy = new DataTable(); popoy.Columns.Add("name", typeof(String)); popoy.Columns.Add("2"); popoy.Columns.Add("3"); popoy.Columns.Add("4"); popoy.Columns.Add("5"); popoy.Columns.Add("6"); popoy.Columns.Add("7"); DataTable cdad = new DataTable(); cdad.Columns.Add("name", typeof(String)); cdad.Columns.Add("2"); cdad.Columns.Add("3"); cdad.Columns.Add("4"); cdad.Columns.Add("5"); cdad.Columns.Add("6"); cdad.Columns.Add("7"); DataTable supps = new DataTable(); supps.Columns.Add("name", typeof(String)); supps.Columns.Add("2"); supps.Columns.Add("3"); supps.Columns.Add("4"); supps.Columns.Add("5"); supps.Columns.Add("6"); supps.Columns.Add("7"); List <string> Categories = new List <string>(); DataTable Excel = new DataTable(); Excel.Columns.Add("1"); Excel.Columns.Add("2"); Excel.Columns.Add("3"); Excel.Columns.Add("4"); Excel.Columns.Add("5"); Excel.Columns.Add("6"); Excel.Columns.Add("7"); Excel.Columns.Add("8"); string pax = ""; int categoryshower = 0; int categoryshowerO = 0; string lastCat = ""; string lastCatOther = ""; List <double> popoyP = new List <double>(); List <double> cdadP = new List <double>(); List <double> suppP = new List <double>(); List <double> popoyPO = new List <double>(); List <double> cdadPO = new List <double>(); List <double> suppPO = new List <double>(); List <decimal> Total = new List <decimal>(); List <string> nameEvents = new List <string>(); string typeofservice = ""; string category = ""; int eventcount = 0; double popoyFP = 0; double cdadFP = 0; double suppFP = 0; string guestType = ""; int indicator = 0; decimal OverAll = 0; int categorysorter = 0; int counter = 0; int foreachcutter = 0; string sampleevent = ""; int showfirst = 0; DataTable suppliers = new DataTable(); suppliers.Columns.Add("Supp"); foreach (DataRow supp in BL.getSupplier().Rows) { suppliers.Rows.Add(supp.ItemArray[0].ToString()); } CatBO.dateF = dateTimePicker1.Value.ToString("yyyy-MM-dd"); CatBO.dateT = dateTimePicker2.Value.ToString("yyyy-MM-dd"); if (comboBox1.Text == "Future event") { CatBO.Status = "ACTIVE"; } else if (comboBox1.Text == "Past event") { CatBO.Status = "DONE"; } else { CatBO.Status = ""; } DataTable eventsdetails = CatBL.getCatDetailByPeriod(CatBO); eventcount = eventsdetails.Rows.Count; foreach (DataRow events in eventsdetails.Rows) { nameEvents.Add(events.ItemArray[1].ToString()); } foreach (DataRow passed in eventsdetails.Rows) { sampleevent = passed.ItemArray[1].ToString(); CatBO.catID = passed.ItemArray[0].ToString(); foreach (DataRow item in CatBL.getCategoryOfRecipes(CatBO).Rows) { Categories.Add(item.ItemArray[0].ToString()); } eventdetail = CatBL.getCatDetailByPeriod(CatBO); eventcount = eventdetail.Rows.Count; foreach (DataRow row in eventdetail.Rows) { vip = vip + Convert.ToInt32(row.ItemArray[3].ToString()); guest = guest + Convert.ToInt32(row.ItemArray[4].ToString()); kids = kids + Convert.ToInt32(row.ItemArray[5].ToString()); crew = crew + Convert.ToInt32(row.ItemArray[6].ToString()); Other = Other + Convert.ToInt32(row.ItemArray[7].ToString()); typeofservice = row.ItemArray[12].ToString(); contractfilename = row.ItemArray[1].ToString(); date = row.ItemArray[9].ToString(); showfirst++; } if (showfirst == eventcount) { Excel.Rows.Add("P.O Of Ingredients", "", "", "", ""); Excel.Rows.Add("", "", ""); Excel.Rows.Add("From: " + dateTimePicker1.Value.ToString("MM-dd-yyyy"), "", ""); Excel.Rows.Add("To: " + dateTimePicker2.Value.ToString("MM-dd-yyyy"), "", ""); Excel.Rows.Add("", "", ""); Excel.Rows.Add("No. Of event selected : " + nameEvents.Count(), "", "", "", "", "", "", ""); Excel.Rows.Add("List of event selected : ", "", "", "", "", "", "", ""); foreach (string eventnames in nameEvents) { Excel.Rows.Add(" " + eventnames, date, "", "", "", "", "", ""); } Excel.Rows.Add("", "", "", "", ""); Excel.Rows.Add(guest + " Guest, " + vip + " Vip, " + kids + " Kids", "", "", "", "", ""); Excel.Rows.Add(crew + " Crew, " + Other + " Other", "", "", "", "", ""); Excel.Rows.Add("", "", "", "", ""); Excel.Rows.Add("Ingredient", "Quantity", " Budget"); } int rowcounter = 0; categorysorter = Categories.Count(); string recid = ""; while (counter < categorysorter) { CatBO.catID = passed.ItemArray[0].ToString(); CatBO.category = Categories[counter]; eventDishes = CatBL.getCateringDish(CatBO); foreach (DataRow row in eventDishes.Rows) { category = row.ItemArray[2].ToString(); guestType = row.ItemArray[0].ToString(); RecBO.recipe = row.ItemArray[1].ToString(); foreach (DataRow rec in RecBL.searchRecipeByName(RecBO).Rows) { recid = rec.ItemArray[0].ToString(); } CatBO.recipeid = recid; CatBO.guest = row.ItemArray[0].ToString(); dishesrecipe = CatBL.getRecipeNameAndFormulaAndPrice(CatBO); foreach (DataRow ing in dishesrecipe.Rows) { string paxx = row.ItemArray[3].ToString(); rowcounter++; string ins = ing[0].ToString(); decimal b = getPrice(ing.ItemArray[1].ToString(), paxx); if (typeofservice == "Plated" && category == "Main dish") { b = b * Properties.Settings.Default.Plated; } //decimal b = getPrice(ing.ItemArray[1].ToString(), paxx); if (ingredients.Rows.Contains(ins)) { for (int i = 0; i < ingredients.Rows.Count; i++) { string temp = ingredients.Rows[i][0].ToString(); if (ins == temp) { ingredients.Rows[i][2] = Convert.ToDecimal(ingredients.Rows[i][2].ToString()) + b; i = ingredients.Rows.Count; } } } else { ingredients.Rows.Add(ing[0].ToString(), ing[2].ToString(), b); } } } categoryshower = categoryshower + 1; counter = counter + 1; indicator = indicator + 1; } } if (indicator != 0) { Excel.Rows.Add("", "", "", "", "", ""); categoryshower = 0; counter = counter + 1; DataView ingredientSorted = new DataView(ingredients); ingredientSorted.Sort = "[1] ASC"; foreach (DataRow supplier in suppliers.Rows) { Excel.Rows.Add(supplier.ItemArray[0].ToString().ToUpper(), "", ""); foreach (DataRowView ingredient in ingredientSorted) { IngBO.ing = ingredient[0].ToString(); DataTable dt = IngBL.searchIngredientReturnPrice(IngBO); string suppliedby = ingredient[1].ToString(); if (supplier.ItemArray[0].ToString() == suppliedby) { foreach (DataRow price in dt.Rows) { Total.Add(Convert.ToDecimal(ingredient[2].ToString()) * Convert.ToDecimal(price.ItemArray[4].ToString())); Excel.Rows.Add(" " + ingredient[0].ToString(), ingredient[2].ToString() + " " + price.ItemArray[2].ToString(), "P " + (Convert.ToDecimal(ingredient[2].ToString()) * Convert.ToDecimal(price.ItemArray[4].ToString())).ToString("0.##")); } } } Excel.Rows.Add("", "", ""); Excel.Rows.Add("Budget for " + supplier.ItemArray[0].ToString(), "", "P " + (Total.Sum()).ToString("0.##")); Excel.Rows.Add("", "", ""); Excel.Rows.Add("", "", ""); OverAll = OverAll + Total.Sum(); Total.Clear(); } Excel.Rows.Add("", "Grand Total", "P " + OverAll.ToString("0.##")); vip = 0; guest = 0; kids = 0; crew = 0; Other = 0; indicator = 0; OverAll = 0; CrystalReport2 cr = new CrystalReport2(); cr.SetDataSource(Excel); crystalReportViewer1.ReportSource = cr; } else { MessageBox.Show("No event can be shown!"); } }