protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
InventoryStatusController inventory = new InventoryStatusController();
List <InventoryStatusReport> inventoryList = inventory.GetInventoryList();
// Microsoft
DataSetReorderBySupplier ds2 = new DataSetReorderBySupplier();
DataTable t2 = ds2.DataTable4;
DataRow r2;
foreach (InventoryStatusReport s in inventoryList)
{
r2 = t2.NewRow();
r2["ItemCode"] = s.ItemCode;
r2["ItemName"] = s.ItemName;
r2["Description"] = s.Description;
r2["Location"] = s.Location;
r2["Balance"] = s.Balance;
r2["UnitOfMeasurement"] = s.UnitOfMeasurement;
r2["ReorderLevel"] = s.ReorderLevel;
t2.Rows.Add(r2);
}
ReportDataSource rds = new ReportDataSource("DataSet1", t2);
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.DataSources.Add(rds);
reportViewer1.LocalReport.Refresh();
}
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
if (phMonth.Controls.Count == 1)
{
TextBox month =
Master.FindControl("body").FindControl("textbox" + 1) as TextBox;
if (month.Text != "")
{
monthList.Add(month.Text);
}
}
else
{
for (int i = 1; i <= phMonth.Controls.Count; i++)
{
TextBox month =
Master.FindControl("body").FindControl("textbox" + i) as TextBox;
if (month.Text != "")
{
if (monthList.Count != 0)
{
if (!CheckDuplicate(month.Text))
{
monthList.Add(month.Text);
}
}
else
{
monthList.Add(month.Text);
}
}
}
}
if (monthList.Count > 0)
{
supplierOrderReport = generateReorderController.GetReportBySupplier(ddlItems.SelectedValue, monthList);
}
DataSetReorderBySupplier ds2 = new DataSetReorderBySupplier();
DataTable t2 = ds2.DataTable1;
DataRow r2;
foreach (SupplierOrderReport s in supplierOrderReport)
{
r2 = t2.NewRow();
r2["OrderDate"] = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(s.OrderDate.Month) + "-" + s.OrderDate.Year;
r2["SupplierOne"] = s.SupplierOne;
r2["SupplierTwo"] = s.SupplierTwo;
r2["SupplierThree"] = s.SupplierThree;
t2.Rows.Add(r2);
}
ReportDataSource rds = new ReportDataSource("DataSet1", t2);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.Refresh();
pnlContents.Visible = true;
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
try
{
var monthList = new List <String>();
if (monthList.Count == 1)
{
TextBox month =
Master.FindControl("body").FindControl("textbox" + 1) as TextBox;
if (month.Text != "")
{
monthList.Add(month.Text);
}
}
else
{
for (int i = 1; i <= phMonth.Controls.Count; i++)
{
TextBox month =
Master.FindControl("body").FindControl("textbox" + i) as TextBox;
if (month.Text != "")
{
monthList.Add(month.Text);
}
}
}
if (monthList.Count > 0)
{
departmentRequisitionReportList = generateRequisitionTrendReportController.GetReportByDepartment(monthList);
}
// Microsoft
DataSetReorderBySupplier ds2 = new DataSetReorderBySupplier();
DataTable t2 = ds2.Tables.Add("SupplierOrderReport");
t2.Columns.Add("RequisitionDate", Type.GetType("System.String"));
t2.Columns.Add("CommerceDept", Type.GetType("System.Int32"));
t2.Columns.Add("ComputerScience", Type.GetType("System.Int32"));
t2.Columns.Add("EnglishDept", Type.GetType("System.Int32"));
t2.Columns.Add("RegistrarDept", Type.GetType("System.Int32"));
t2.Columns.Add("ZoologyDept", Type.GetType("System.Int32"));
DataRow r2;
foreach (DepartmentRequisitionReport d in departmentRequisitionReportList)
{
r2 = t2.NewRow();
r2["RequisitionDate"] = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(d.RequisitionDate.Month) + "-" + d.RequisitionDate.Year;
r2["CommerceDept"] = d.CommerceDept;
r2["ComputerScience"] = d.ComputerScience;
r2["EnglishDept"] = d.EnglishDept;
r2["RegistrarDept"] = d.RegistrarDept;
r2["ZoologyDept"] = d.ZoologyDept;
t2.Rows.Add(r2);
}
ReportDataSource rds = new ReportDataSource("DataSet1", t2);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.Refresh();
pnlContents.Visible = true;
}
catch
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Something wrong!')", true);
}
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
var monthList = new List <String>();
var categoryStringList = new List <String>();
if (phMonth.Controls.Count == 1)
{
TextBox month =
Master.FindControl("body").FindControl("textbox" + 1) as TextBox;
if (month.Text != "")
{
monthList.Add(month.Text);
}
}
else
{
for (int i = 1; i <= phMonth.Controls.Count; i++)
{
TextBox month =
Master.FindControl("body").FindControl("textbox" + i) as TextBox;
if (month.Text != "")
{
monthList.Add(month.Text);
}
}
}
for (int i = 1; i <= phCategory.Controls.Count; i++)
{
CheckBox category =
Master.FindControl("body").FindControl("checkBox" + i) as CheckBox;
if (category.Checked)
{
categoryStringList.Add(category.Text);
}
}
if (monthList.Count > 0)
{
categpryOrderReport = generateReorderController.GetReportByCategory(categoryStringList, monthList);
}
DataSetReorderBySupplier ds2 = new DataSetReorderBySupplier();
DataTable t = ds2.DataTable2;
foreach (CategoryOrderReport c in categpryOrderReport)
{
DataRow r2 = t.NewRow();
r2["OrderDate"] = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(c.OrderDate.Month) + "-" + c.OrderDate.Year;
r2["Clip"] = c.Clip;
r2["Envelope"] = c.Envelope;
r2["Eraser"] = c.Eraser;
r2["Exercise"] = c.Exercise;
r2["File"] = c.File;
r2["Pen"] = c.Pen;
r2["Puncher"] = c.Puncher;
r2["Pad"] = c.Pad;
r2["Paper"] = c.Paper;
r2["Ruler"] = c.Ruler;
r2["Scissors"] = c.Scissors;
r2["Tape"] = c.Tape;
r2["Sharpener"] = c.Sharpener;
r2["Shorthand"] = c.Shorthand;
r2["Stapler"] = c.Stapler;
r2["Tacks"] = c.Tacks;
r2["Tparency"] = c.Tparency;
r2["Tray"] = c.Tray;
t.Rows.Add(r2);
}
ReportDataSource rds = new ReportDataSource("DataSet1", t);
ReportViewer2.LocalReport.DataSources.Clear();
ReportViewer2.LocalReport.DataSources.Add(rds);
ReportViewer2.LocalReport.Refresh();
pnlContents.Visible = true;
}