private void Page_Load(object sender, System.EventArgs e)
{
try
{
OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
if (Request.QueryString["id"] == null)
{
Session["lastpage"] = "main.aspx";
Session["error"] = _functions.ErrorMessage(104);
Response.Redirect("error.aspx", false);
return;
}
try
{
OrderId = Convert.ToInt32(Request.QueryString["id"]);
}
catch (FormatException fex)
{
Session["lastpage"] = "main.aspx";
Session["error"] = _functions.ErrorMessage(105);
Response.Redirect("error.aspx", false);
return;
}
// getting the Bread Crumbs from Cookie and add last item
if (Request.Cookies.Count > 0 && Request.Cookies["bfp_navigate"] != null)
{
Header.BrdCrumbsSerialization = Request.Cookies["bfp_navigate"].Value;
}
Header.AddBreadCrumb("Work Order Detail", "/wo_viewWorkOrder.aspx?id=" + OrderId.ToString());
SaveCancelControl.ParentPageURL = ParentPageURL;
SaveCancelControl.IsCancel = true;
SaveCancelControl.CausesValidation = true;
SaveCancelControl.ButtonText = " Check-Out/Sign ";
if (!IsPostBack)
{
order = new clsWorkOrders();
order.cAction = "S";
order.iOrgId = OrgId;
order.iId = OrderId;
if (order.WorkOrderDetails() == -1)
{
Session["lastpage"] = "wo_viewWorkOrder.aspx?id=" + OrderId.ToString();;
Session["error"] = _functions.ErrorMessage(120);
Response.Redirect("error.aspx", false);
return;
}
if (order.iStatusId.Value != (int)WorkOrderStatus.Closed)
{
Signature.sError = _functions.ErrorMessage(138);
Signature.Enabled = false;
tbReleasedTo.Enabled = false;
SaveCancelControl.EnableSave = false;
}
lblWorkOrderId.Text = order.daCreated.Value.ToString("yyyy-MM-dd") + "-" + order.iWorkOrderNumber.Value.ToString();
lblEquipId.Text = order.sEquipId.Value;
lblSpareEquipId.Text = order.sSpareEquipId.Value;
lblTech.Text = order.sTechName.Value;
lblOperator.Text = order.sOperatorName.Value;
lblDroppedOffBy.Text = order.sDropedOffBy.Value;
tbReleasedTo.Text = order.sReleasedTo.Value;
lblCleanliness.Text = order.sCleanliness.Value;
lblScheduledDate.Text = order.daScheduled.IsNull?"":order.daScheduled.Value.ToLongDateString();
if (order.daDeparture.IsNull)
{
adtCheckOut.Date = DateTime.Now;
}
else
{
adtCheckOut.Date = order.daDeparture.Value;
}
order.iItemId = OrderId;
order.iNoteTypeId = (int)NoteTypes.CheckOutNote;
repCheckOutNotes.DataSource = new DataView(order.GetNotesList());
repCheckOutNotes.DataBind();
}
}
catch (Exception ex)
{
_functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
Session["lastpage"] = "wo_viewWorkOrder.aspx?id=" + OrderId.ToString();
Session["error"] = ex.Message;
Session["error_report"] = ex.ToString();
Response.Redirect("error.aspx", false);
}
finally
{
if (order != null)
{
order.Dispose();
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
try
{
OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
if (Request.QueryString["id"] == null)
{
Session["lastpage"] = "main.aspx";
Session["error"] = _functions.ErrorMessage(104);
Response.Redirect("error.aspx", false);
return;
}
try
{
OrderId = Convert.ToInt32(Request.QueryString["id"]);
}
catch (FormatException fex)
{
Session["lastpage"] = "main.aspx";
Session["error"] = _functions.ErrorMessage(105);
Response.Redirect("error.aspx", false);
return;
}
// getting the Bread Crumbs from Cookie and add last item
if (Request.Cookies.Count > 0 && Request.Cookies["bfp_navigate"] != null)
{
Header.BrdCrumbsSerialization = Request.Cookies["bfp_navigate"].Value;
}
Header.AddBreadCrumb("Work Order Detail", "/wo_viewWorkOrder.aspx?id=" + OrderId.ToString());
SaveCancelControl.ParentPageURL = this.ParentPageURL;
SaveCancelControl.ButtonText = " Close & Sign ";
if (!IsPostBack)
{
order = new clsWorkOrders();
user = new clsUsers();
order.cAction = "S";
order.iOrgId = OrgId;
order.iId = OrderId;
if (order.WorkOrderDetails() == -1)
{
Session["lastpage"] = "wo_viewWorkOrder.aspx?id=" + OrderId.ToString();;
Session["error"] = _functions.ErrorMessage(120);
Response.Redirect("error.aspx", false);
return;
}
if (!user.IsTechnician(_functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true)))
{
Session["lastpage"] = "wo_viewWorkOrder.aspx?id=" + OrderId.ToString();
Session["error"] = _functions.ErrorMessage(131);
Response.Redirect("error.aspx", false);
return;
}
if (order.iTechId.Value == 0)
{
Signature.sError = _functions.ErrorMessage(143);
SaveCancelControl.EnableSave = false;
}
if (order.GetCompleteAbleOrder() != 1)
{
Signature.sError = _functions.ErrorMessage(142);
SaveCancelControl.EnableSave = false;
}
lblWorkOrderId.Text = order.daCreated.Value.ToString("yyyy-MM-dd") + "-" + order.iWorkOrderNumber.Value.ToString();
lblEquipId.Text = order.sEquipId.Value;
lblSpareEquipId.Text = order.sSpareEquipId.Value;
lblTech.Text = order.sTechName.Value;
lblOperator.Text = order.sOperatorName.Value;
tbCleanliness.Text = order.sCleanliness.Value;
if (order.daClosed.IsNull)
{
adtClosed.Date = DateTime.Now;
}
else
{
adtClosed.Date = order.daClosed.Value;
}
if (order.iStatusId.Value == (int)WorkOrderStatus.Closed ||
order.iStatusId.Value == (int)WorkOrderStatus.Scheduled)
{
tbCleanliness.Enabled = false;
tbTechNote.Enabled = false;
tbCheckOutNote.Enabled = false;
Signature.Enabled = false;
SaveCancelControl.EnableSave = false;
Signature.sError = _functions.ErrorMessage(141);
}
// show notes
order.iItemId = OrderId;
order.iNoteTypeId = (int)NoteTypes.TechnicianNote;
repTechNotes.DataSource = new DataView(order.GetNotesList());
repTechNotes.DataBind();
order.iNoteId = 0;
order.iNoteTypeId = (int)NoteTypes.CheckOutNote;
if (order.NoteDetails() != -1)
{
tbCheckOutNote.Text = order.sNote.Value;
}
ShowCustomFields();
}
}
catch (Exception ex)
{
_functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
Session["lastpage"] = "wo_viewWorkOrder.aspx?id=" + OrderId.ToString();
Session["error"] = ex.Message;
Session["error_report"] = ex.ToString();
Response.Redirect("error.aspx", false);
}
finally
{
if (user != null)
{
user.Dispose();
}
if (order != null)
{
order.Dispose();
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
try
{
if (Request.QueryString["id"] == null)
{
Session["lastpage"] = "ok_selectWorkOrder.aspx";
Session["error"] = _functions.ErrorMessage(104);
Response.Redirect("error.aspx", false);
return;
}
try
{
OrderId = Convert.ToInt32(Request.QueryString["id"]);
}
catch (FormatException fex)
{
Session["lastpage"] = "ok_selectWorkOrder.aspx";
Session["error"] = _functions.ErrorMessage(105);
Response.Redirect("error.aspx", false);
return;
}
OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
if (Request.UrlReferrer != null)
{
m_sBack = Request.UrlReferrer.AbsoluteUri;
m_sBack = m_sBack.Remove(0, m_sBack.LastIndexOf("/") + 1);
}
else
{
m_sBack = "ok_updateSpare.aspx?id=" + OrderId.ToString();
}
NextBackControl.BackText = "<< Back";
NextBackControl.BackPage = m_sBack;
NextBackControl.NextText = "Continue >>";
NextBackControl.sCSSClass = "ok_input_button";
op = new OperatorInfo(Request.Cookies["bfp_operator"].Value);
if (!IsPostBack)
{
order = new clsWorkOrders();
order.iOrgId = OrgId;
order.iItemId = OrderId;
order.iNoteTypeId = (int)NoteTypes.CheckOutNote;
dtNotes = order.GetNotesList();
if (dtNotes.Rows.Count > 0)
{
repTechNotes.DataSource = new DataView(dtNotes);
repTechNotes.DataBind();
}
else
{
order.iId = OrderId;
CheckOutEquipment();
}
}
}
catch (Exception ex)
{
_functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
Session["lastpage"] = m_sBack;
Session["error"] = ex.Message;
Session["error_report"] = ex.ToString();
Response.Redirect("error.aspx", false);
}
finally
{
if (order != null)
{
order.Dispose();
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
//try
//{
ReportViewerControl.LocalReport.ReportPath = _functions.GetValueFromConfig("SQLRS.DefaultPath") + ".rdlc";
if (Request["Report"] != null)
{
ReportViewerControl.LocalReport.ReportPath = Request["Report"] + ".rdlc";
}
ReportViewerControl.LocalReport.EnableExternalImages = true;
clsWorkOrders wo = new clsWorkOrders();
if (!string.IsNullOrEmpty(Request["OrgId"]))
{
wo.iOrgId = Convert.ToInt32(Request["OrgId"]);
}
if (!string.IsNullOrEmpty(Request["OrderId"]))
{
wo.iId = Convert.ToInt32(Request["OrderId"]);
}
if (!string.IsNullOrEmpty(Request["InspectId"]))
{
wo.iInspectionId = Convert.ToInt32(Request["InspectId"]);
}
string url = string.Empty;
if (!string.IsNullOrEmpty(Request["URL"]))
{
url = Request["URL"];
}
foreach (string dataSource in ReportViewerControl.LocalReport.GetDataSourceNames())
{
switch (dataSource)
{
case "ReportedIssueList":
DataSet ds = wo.GetReportedIssueLists();
if (ds != null && ds.Tables.Count > 0)
{
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, ds.Tables[0]));
}
break;
case "PMItemList":
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetPMServicesListForWorkOrder()));
break;
case "InspectionsList":
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInspectionsListForWorkOrder()));
break;
case "WorkOrderDetail":
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetDetailsForWorkOrder()));
break;
case "CreationNotesList":
wo.iNoteTypeId = 1;
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetNotesList()));
break;
case "OperatorNotesList":
wo.iNoteTypeId = 2;
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetNotesList()));
break;
case "PartsList":
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetPartsUsedListForReport()));
break;
case "ReportedIssuesList":
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetReportedIssues()));
break;
case "PMItemsList":
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetPMItemsList()));
break;
case "RepairsList":
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetRepairsListForReport()));
break;
case "TechNotesList":
wo.iNoteTypeId = 3;
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetNotesList()));
break;
case "CheckOutNotesList":
wo.iNoteTypeId = 4;
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetNotesList()));
break;
case "CheckInDetails":
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.CheckInDetailsForReport(url)));
break;
case "InstructionList":
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInstructionByCheckIn()));
break;
case "InspectionDetail":
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInspectionDetailForReport()));
break;
case "InspectionItemsList":
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInspectionItemsListForReport()));
break;
case "InspectionList":
ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInspectionListForReport()));
break;
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
string sTypeName;
try
{
OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
if (Request.QueryString["id"] == null)
{
Session["lastpage"] = "main.aspx";
Session["error"] = _functions.ErrorMessage(104);
Response.Redirect("error.aspx", false);
return;
}
try
{
OrderId = Convert.ToInt32(Request.QueryString["id"]);
}
catch (FormatException fex)
{
Session["lastpage"] = "main.aspx";
Session["error"] = _functions.ErrorMessage(105);
Response.Redirect("error.aspx", false);
return;
}
NextBackControl.BackPage = "wo_addInspections.aspx?id=" + OrderId.ToString();
NextBackControl.BackVisible = true;
NextBackControl.NextText = "Open/Finish";
if (!IsPostBack)
{
hlStart.NavigateUrl = "wo_openWorkOrder.aspx?id=" + OrderId.ToString();
hlInspections.NavigateUrl = "wo_addInspections.aspx?id=" + OrderId.ToString();
hlIssues.NavigateUrl = "wo_addRepairs.aspx?id=" + OrderId.ToString() + "&back=open";
hlPMItems.NavigateUrl = "wo_addPreventiveMaintenance.aspx?id=" + OrderId.ToString() + "&back=preview";
dtCustomFields = new DataTable();
dtCustomFields.Columns.Add("ValueName");
dtCustomFields.Columns.Add("Value");
order = new clsWorkOrders();
order.cAction = "S";
order.iOrgId = OrgId;
order.iId = OrderId;
if (order.WorkOrderDetails() == -1)
{
Session["lastpage"] = "wo_addInspections.aspx?id=" + OrderId.ToString();
Session["error"] = _functions.ErrorMessage(120);
Response.Redirect("error.aspx", false);
return;
}
if (order.iStatusId.Value != (int)WorkOrderStatus.Scheduled ||
order.iOperatorStatusId.Value != (int)WorkOrderOperatorStatus.Checked_In)
{
Signature.sError = _functions.ErrorMessage(144);
NextBackControl.NextEnabled = false;
}
// showing main info
lblWorkOrderN.Text = order.daCreated.Value.ToString("yyyy-MM-dd") + "-" + order.iWorkOrderNumber.Value.ToString();
lblWOType.Text = order.sType.Value;
lblStatus.Text = order.sStatusId.Value;
lblOperatorStatus.Text = order.sOperatorStatus.Value;
lblOperator.Text = order.sOperatorName.Value;
lblStaying.Text = order.bStaying.IsNull?"not defined":(order.bStaying.Value?"Yes":"No");
lblSpare.Text = order.sSpareEquipId.Value;
lblTech.Text = order.sTechName.Value;
lblDroppedOffBy.Text = order.sDropedOffBy.Value;
lblArrivalDate.Text = order.daArrival.IsNull?"":order.daArrival.Value.ToLongDateString();
lblScheduledDate.Text = order.daScheduled.Value.ToLongDateString();
hlEquipId.Text = order.sEquipId.Value;
hlEquipId.NavigateUrl = "e_view.aspx?id=" + order.iEquipId.Value.ToString();
lblType.Text = order.sEquipTypeName.Value;
lblMakeModel.Text = order.sEquipMakeModel.Value;
lblYear.Text = (order.sEquipYear.Value == "0")?"unknown":order.sEquipYear.Value;
lblUnits.Text = Convert.ToDouble(order.dmMileage.Value).ToString();
// showing issues
dsRepairs = order.GetReportedIssueLists();
if (dsRepairs.Tables[0].Rows.Count > 0)
{
html_tblNoneIssues.Visible = false;
}
else
{
html_tblNoneIssues.Visible = true;
}
repIssues.DataSource = new DataView(dsRepairs.Tables[0]);
repIssues.DataBind();
// showing the pm items
dwPMItems = new DataView(order.GetPMServicesListForWorkOrder());
dwPMItems.RowFilter = "IsChecked='True'";
if (dwPMItems.Count > 0)
{
html_tblNonePMItems.Visible = false;
}
else
{
html_tblNonePMItems.Visible = true;
}
repPMItems.DataSource = dwPMItems;
repPMItems.DataBind();
// showing the inspections
dwInspections = new DataView(order.GetInspectionsListForWorkOrder());
dwInspections.RowFilter = "IsChecked='True'";
if (dwInspections.Count > 0)
{
html_tblNoneInspections.Visible = false;
}
else
{
html_tblNoneInspections.Visible = true;
}
repInspections.DataSource = dwInspections;
repInspections.DataBind();
// showing notes
order.iItemId = OrderId;
order.iNoteTypeId = (int)NoteTypes.CreationNote;
repCreationNotes.DataSource = new DataView(order.GetNotesList());
repCreationNotes.DataBind();
order.iNoteTypeId = (int)NoteTypes.OperatorNote;
repOperatorNotes.DataSource = new DataView(order.GetNotesList());
repOperatorNotes.DataBind();
#region Showing custom fields of order on screen
dtCustomFieldsFromDB = order.WorkOrderDetail_CustomFields(null);
if (dtCustomFieldsFromDB.Rows.Count > 0)
{
arrCFD = _functions.GetCustomFields(CFDataType.WorkOrder, 0, HttpContext.Current.User.Identity.Name);
if (arrCFD.Count > 0)
{
// fill custom fields
for (int j = 0; j < arrCFD.Count; j++)
{
cfd = (clsCustomFieldsDef)arrCFD[j];
sTypeName = _functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString();
switch (cfd.FieldTypeId)
{
case DBFieldType._lookup:
switch (cfd.NameLookupTable)
{
case "EquipModels":
if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value)
{
dtCustomFields.Rows.Add(new object [] { "Make/Model", "" });
}
else
{
mm = new clsMakesModels();
mm.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
mm.iModelId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]);
mm.GetModelMakes();
dtCustomFields.Rows.Add(new object [] { "Make/Model", mm.sMakeName + "/" + mm.sModelName });
if (mm != null)
{
mm.Dispose();
}
}
break;
case "Departments":
if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value)
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, "" });
}
else
{
dep = new clsDepartments();
dep.cAction = "S";
dep.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
dep.iId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]);
if (dep.DepartmentDetail() == 0)
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, dep.sName.Value });
}
else
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, "" });
}
if (dep != null)
{
dep.Dispose();
}
}
break;
case "Locations":
if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value)
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, "" });
}
else
{
loc = new clsLocations();
loc.cAction = "S";
loc.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
loc.iId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]);
if (loc.LocationDetail() == 0)
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, loc.sName.Value });
}
else
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, "" });
}
if (loc != null)
{
loc.Dispose();
}
}
break;
default:
break;
}
break;
case DBFieldType._datetime:
if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value)
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, "" });
}
else
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, ((DateTime)dtCustomFieldsFromDB.Rows[0][sTypeName]).ToShortDateString() });
}
break;
case DBFieldType._bit:
if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value)
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, "" });
}
else
{
if (((bool)dtCustomFieldsFromDB.Rows[0][sTypeName]) == true)
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, "Yes" });
}
else
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, "No" });
}
}
break;
default:
if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value)
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, "" });
}
else
{
dtCustomFields.Rows.Add(new object [] { cfd.NameText, dtCustomFieldsFromDB.Rows[0][sTypeName] });
}
break;
}
cfd = null;
}
// showing a Equipment's data from custom fields
repCustomFields.DataSource = new DataView(dtCustomFields);
repCustomFields.DataBind();
}
}
#endregion
}
}
catch (Exception ex)
{
_functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
Session["lastpage"] = "wo_addInspections.aspx?id=" + OrderId.ToString();
Session["error"] = ex.Message;
Session["error_report"] = ex.ToString();
Response.Redirect("error.aspx", false);
}
finally
{
if (order != null)
{
order.Dispose();
}
}
}
