private void btnReport_Click(object sender, System.EventArgs e)
{
try
{
order = new clsWorkOrders();
order.iOrgId = OrgId;
order.sEquipId = tbEquipId.Text;
order.daMinDate = adtStartDate.Date;
order.daMaxDate = adtEndDate.Date;
order.iTypeId = Convert.ToInt32(ddlWOTypes.SelectedValue);
order.iRepairCatId = Convert.ToInt32(ddlRepairCats.SelectedValue);
order.iTechId = Convert.ToInt32(ddlTech.SelectedValue);
order.iOperatorId = Convert.ToInt32(ddlOperators.SelectedValue);
DataTable dtReport = order.GetEquipWorkOrderReport();
repWorkOrders.DataSource = new DataView(dtReport);
repWorkOrders.DataBind();
double dmTotalCost = 0.0;
foreach(DataRow _row in dtReport.Rows)
{
dmTotalCost += Convert.ToDouble(_row["TotalCost"]);
}
lblTotalCost.Text = "$" + dmTotalCost.ToString();
}
catch(Exception ex)
{
_functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
Session["lastpage"] = "wo_viewEquipWorkOrderReport.aspx";
Session["error"] = ex.Message;
Session["error_report"] = ex.ToString();
Response.Redirect("error.aspx", false);
}
finally
{
if(order != null)
order.Dispose();
}
}
