private void BtnReportAllStock_Click(object sender, EventArgs e) { Provisions_Report reportPage = new Provisions_Report(); reportPage.addItem("Report on Provisions Stock on Hand"); reportPage.addItem(" On " + DateTime.Now.ToString("yyyy/MM/dd")); string inSQL = "SELECT Item_Name, Item_Description, Retail_Price, Stock_Level" + " From Provisions_Current_Stock ORDER BY Item_Name ASC"; reportPage.addItem("__________________________________________________________"); using (OleDbDataAdapter itemAdapter = new OleDbDataAdapter(inSQL, connect)) { DataSet dsItems = new DataSet(); itemAdapter.Fill(dsItems); foreach (DataRow item in dsItems.Tables[0].Rows) { double quantity = double.Parse(item["Stock_Level"].ToString()); double worthPerItem = double.Parse(item["Retail_Price"].ToString()); double itemTotalWorth = quantity * worthPerItem; reportPage.addItem(item["Item_Name"].ToString() + " (" + item["Item_Description"] + ") | Total Value : R" + itemTotalWorth); reportPage.addItem("\tStock Level: " + quantity); reportPage.addItem("\tRetail Price: R" + worthPerItem); reportPage.addItem(""); } } reportPage.Show(); }
private void BtnMonthlyReport_Click(object sender, EventArgs e) { Provisions_Report reportPage = new Provisions_Report(); reportPage.addItem("Monthly report of " + comboboxMonthlyReport.Text); sql = "SELECT io.ID, io.Date_Received, io.Stakeholder_Type, io.Stakeholder_Name, Input_Type" + " FROM Provisions_In_Out io" + " WHERE("; string inputDate = comboboxMonthlyReport.Text; string monthname = inputDate.Substring(0, inputDate.IndexOf(" ")); int yearNr = int.Parse(inputDate.Substring(inputDate.LastIndexOf(" ") + 1)); int iMonthNo = Convert.ToDateTime("01-" + monthname + "-2011").Month; int dayCount = DateTime.DaysInMonth(yearNr, iMonthNo); DateTime strt = new DateTime(yearNr, iMonthNo, 1); DateTime endd = new DateTime(yearNr, iMonthNo, dayCount); string strtDate = strt.ToString("yyyy/MM/dd 00:00:00"); string endDateOut = endd.ToString("yyyy/MM/dd 23:59:59"); sql += " io.Date_Received >= #" + strtDate + "# AND io.Date_Received <= #" + endDateOut + "#"; sql += ") ORDER BY Date_Received ASC"; using (OleDbDataAdapter adapter = new OleDbDataAdapter(sql, connect)) { DataSet dstemp = new DataSet(); adapter.Fill(dstemp); foreach (DataRow c in dstemp.Tables[0].Rows) { reportPage.addItem("__________________________________________________________"); string add = ""; if (c["Input_Type"].ToString() == "Distributed") { add += "Distributed To "; } else { add += "Donation From "; } add += c["Stakeholder_Name"].ToString() + " (Distribution Type: " + c["Stakeholder_Type"].ToString() + ")"; reportPage.addItem(add); string line = c["Date_Received"].ToString(); add = "Date: " + line.Substring(0, line.IndexOf(" ")); reportPage.addItem(add); reportPage.addItem("Items:"); int itemID = int.Parse(c["ID"].ToString()); string inSQL = "SELECT cs.Item_Name, cs.Item_Description, cs.Retail_Price, st.Quantity" + " FROM Provisions_Support_Table st, Provisions_Current_Stock cs" + " WHERE ((cs.ID = st.Stock_ID) AND (In_Out_ID = " + itemID + "))"; using (OleDbDataAdapter itemAdapter = new OleDbDataAdapter(inSQL, connect)) { DataSet dsItems = new DataSet(); itemAdapter.Fill(dsItems); double donationWorth = 0.0; foreach (DataRow item in dsItems.Tables[0].Rows) { double quantity = double.Parse(item["Quantity"].ToString()); double worthPerItem = double.Parse(item["Retail_Price"].ToString()); double itemTotalWorth = quantity * worthPerItem; donationWorth += itemTotalWorth; string inAdd = "\t" + item["Item_Name"].ToString() + " (" + item["Item_Description"] + ")\t* " + item["Quantity"].ToString() + "\t(Worth R" + itemTotalWorth + ")"; reportPage.addItem(inAdd); } reportPage.addItem("Total Worth of Distribution: R" + donationWorth); } reportPage.addItem(""); } } reportPage.ShowDialog(); }
private void BtnGenerateDistributedReport_Click(object sender, EventArgs e) { Provisions_Report reportPage = new Provisions_Report(); sql = "SELECT io.ID, io.Date_Received, io.Stakeholder_Type, io.Stakeholder_Name" + " FROM Provisions_In_Out io" + " WHERE(io.Input_Type = 'Distributed'"; if (rbApecifyTimeOut.Checked == true) { DateTime strt = new DateTime(); strt = dateTimePickerStartOut.Value; string strtDate = strt.ToString("yyyy/MM/dd 00:00:00"); strt = datetimePickerEndOut.Value; string endDateOut = strt.ToString("yyyy/MM/dd 23:59:59"); sql += " AND io.Date_Received >= #" + strtDate + "# AND io.Date_Received <= #" + endDateOut + "#"; } if (rbSpecifyCategoryOut.Checked == true) { sql += " AND Stakeholder_Type = '" + comboboxDistributionCategory.Text + "'"; } if (rbSpecifyDonorOut.Checked == true) { sql += " AND Stakeholder_Name = '" + comboboxDistributionName.Text + "'"; } sql += ") ORDER BY Date_Received ASC"; using (OleDbDataAdapter adapter = new OleDbDataAdapter(sql, connect)) { DataSet dstemp = new DataSet(); adapter.Fill(dstemp); string reportHeading = "Report on Distributions"; if (rbSpecifyCategoryOut.Checked == true) { if (rbSpecifyDonorOut.Checked == true) { reportHeading += " to " + comboboxDistributionName.Text + " (Distribution Type: " + comboboxDistributionCategory.Text + ")"; } else { reportHeading += " to Distribution Type " + comboboxDistributionCategory.Text; } } else if (rbSpecifyDonorOut.Checked == true) { DataRow temp; temp = dstemp.Tables[0].Rows[0]; reportHeading += " to " + comboboxDistributionName.Text + " (Distribution Type: " + temp["Stakeholder_Type"].ToString() + ")"; } reportPage.addItem(reportHeading); if (rbApecifyTimeOut.Checked == true) { reportPage.addItem(" Between " + dateTimePickerStartOut.Text + " and " + datetimePickerEndOut.Text); } reportPage.addItem(""); foreach (DataRow c in dstemp.Tables[0].Rows) { reportPage.addItem("__________________________________________________________"); string add = "Distributed To " + c["Stakeholder_Name"].ToString() + " (Distribution Type: " + c["Stakeholder_Type"] + ")"; reportPage.addItem(add); string line = c["Date_Received"].ToString(); add = "Date: " + line.Substring(0, line.IndexOf(" ")); reportPage.addItem(add); reportPage.addItem("Items:"); int itemID = int.Parse(c["ID"].ToString()); string inSQL = "SELECT cs.Item_Name, cs.Item_Description, cs.Retail_Price, st.Quantity" + " FROM Provisions_Support_Table st, Provisions_Current_Stock cs" + " WHERE ((cs.ID = st.Stock_ID) AND (In_Out_ID = " + itemID + "))"; using (OleDbDataAdapter itemAdapter = new OleDbDataAdapter(inSQL, connect)) { DataSet dsItems = new DataSet(); itemAdapter.Fill(dsItems); double donationWorth = 0.0; foreach (DataRow item in dsItems.Tables[0].Rows) { double quantity = double.Parse(item["Quantity"].ToString()); double worthPerItem = double.Parse(item["Retail_Price"].ToString()); double itemTotalWorth = quantity * worthPerItem; donationWorth += itemTotalWorth; string inAdd = "\t" + item["Item_Name"].ToString() + " (" + item["Item_Description"] + ")\t* " + item["Quantity"].ToString() + "\t(Worth R" + itemTotalWorth + ")"; reportPage.addItem(inAdd); } reportPage.addItem("Total Worth of Distribution: R" + donationWorth); } reportPage.addItem(""); } } reportPage.ShowDialog(); }