private void btNext_FormSubmit(object sender, EventArgs e) { try { order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; CheckOutEquipment(); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "ok_viewNotes.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 btnSave_Click(object sender, System.EventArgs e) { try { order = new clsWorkOrders(); order.cAction = "U"; if(((DateTime)ViewState["Date"]).CompareTo(adtLastTime.Date) <= 0) { lblError.Text = "The date cannot more then " + ((DateTime)ViewState["Date"]).ToShortDateString(); } else { order.iInspectHistoryId = HistoryId; order.iOrgId = OrgId; order.iInspectSchedDetailId = InspectSchedDetailId; order.iId = OrderId; order.iEquipId = (Int32)ViewState["EquipId"]; order.daDateHistory = adtLastTime.Date; if(order.InspectHistoryDetail() != -1) { // closing the current window and reloading the parent window sOnLoad = "window.close();opener.document.formSelectInspect.submit();"; Session["reload"] = true; } } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); } finally { if(order != null) order.Dispose(); } }
private void Page_Load(object sender, System.EventArgs e) { try { SourcePageName = "wo_viewDates.aspx.cs"; Header.MainMenuVisible = false; Header.Visible = false; OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); OrderId = Convert.ToInt32(Request.QueryString["id"]); order = new clsWorkOrders(); order.cAction = "S"; order.iOrgId = OrgId; order.iId = OrderId; if(order.WorkOrderDetails() != -1) { lblDateCreated.Text = order.daCreated.Value.ToLongDateString(); lblArrivalDate.Text = order.daArrival.IsNull?"":order.daArrival.Value.ToLongDateString(); lblDateScheduled.Text = order.daScheduled.IsNull?"":order.daScheduled.Value.ToLongDateString() + " " + order.daScheduled.Value.ToLongTimeString(); lblDateOpened.Text = order.daOpened.IsNull?"":order.daOpened.Value.ToLongDateString(); lblDateClosed.Text = order.daClosed.IsNull?"":order.daClosed.Value.ToLongDateString(); lblDepartureDate.Text = order.daDeparture.IsNull?"":order.daDeparture.Value.ToLongDateString(); } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); } finally { if(order != null) order.Dispose(); } }
private void btNext_FormSubmit(object sender, EventArgs e) { try { order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; order.sInitials = Signature.sInitials; order.sPIN = Signature.sPIN; order.daCurrentDate = DateTime.Now; switch(order.SigningWorkOrderOpen()) { case -1: Signature.sError = _functions.ErrorMessage(140); break; case -2: Session["lastpage"] = "wo_preview.aspx?id=" + OrderId.ToString(); Session["error"] = _functions.ErrorMessage(120); Response.Redirect("error.aspx", false); return; case 0: // redirect to the finish screen BackFinishScreen finish = new BackFinishScreen(); finish.sMainText = "The Work Order opened successfully!"; finish.bMainMenuVisible = true; finish.sMainMenuText = "[Return to Main Menu]"; finish.sMainMenuURL = "main.aspx"; finish.bContinueVisible = false; finish.bViewVisible = true; finish.sViewText = "[View the Opened Work Order]"; finish.sViewURL = "wo_viewWorkOrder.aspx?id=" + OrderId.ToString(); finish.bAdditionalVisible = false; finish.bPrintVisible = true; finish.sPrintText = "[Print the Opened Work Order]"; finish.sPrintURL = "ReportViewer.aspx?Report=FleetProReports%2fWorkOrderRequest&rs:Command=Render&rc:Parameters=false&OrderId=" + OrderId.ToString() + "&OrgId=" + OrgId.ToString(); Session["BackFinish"] = finish; Response.Redirect("wo_finish.aspx", false); break; } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_preview.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 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(); } }
private void btSave_FormSubmit(object sender, EventArgs e) { try{ OrderId = (int)ViewState["OrderId"]; RepairId = (int)ViewState["RepairId"]; InspectId = (int)ViewState["InspectId"]; order = new clsWorkOrders(); order.cAction = "U"; order.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); order.iId = OrderId; order.iRepairId = RepairId; order.sRepairDesc = tbNotes.Text; if(ddlRepairItems.SelectedValue != "0") order.iRepairItemId = Convert.ToInt32(ddlRepairItems.SelectedValue); if(order.RepairCommonDetails() == -1) { Session["lastpage"] = "wo_editPartsUsed.aspx?id=" + OrderId.ToString() + "&repairid=" + RepairId.ToString() + "&inspectid=" + InspectId.ToString(); Session["error"] = _functions.ErrorMessage(123); Response.Redirect("error.aspx", false); return; } if(InspectId != 0) Response.Redirect("wo_viewCompleteInspection.aspx?id=" + OrderId.ToString()+ "&inspectid=" + InspectId.ToString(), false); else Response.Redirect("wo_viewWorkOrder.aspx?id=" + OrderId.ToString(), false); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_editPartsUsed.aspx?id=" + OrderId.ToString() + "&repairid=" + RepairId.ToString() + "&inspectid=" + InspectId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(order != null) order.Dispose(); } }
private void dgRepairs_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { try { dgRepairs.EditItemIndex = e.Item.ItemIndex; order = new clsWorkOrders(); order.iOrgId = OrgId; ShowIssues(OrderId); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = m_sBackUrl; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(order != null) order.Dispose(); } }
/// <summary> /// The common procedure what will save filled Repair // and his used parts both Add mode and Edit mode. /// </summary> private void UpdateRepair(bool newRepair) { double Hours = 0.0; try { // if(tbNotes.Text.Length > 0) // { if (tbMinutes.Text.Length > 0 && Convert.ToDouble(tbMinutes.Text) >= 60) { Header.ErrorMessage = _functions.ErrorMessage(206); return; } if (tbHours.Text.Length > 0 || tbMinutes.Text.Length > 0) { if (tbHours.Text.Length > 0) Hours += Convert.ToDouble(tbHours.Text); if (tbMinutes.Text.Length > 0) Hours += Convert.ToDouble(tbMinutes.Text) / 60; } if (Hours >= 1000) { Header.ErrorMessage = _functions.ErrorMessage(203); return; } order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; order.sTypeService = sType; order.iItemId = ItemId; if (ServiceResult == "Repair") order.iServiceResultId = (int)ServiceResults._Repaired; else order.iServiceResultId = (int)ServiceResults._Replaced; if (Mode) // Add mode { order.iRepairId = 0; } else // Edit mode order.iRepairId = RepairId; if (RepairId == 0 && newRepair) { order.iRepairId = preRepairId; order.iInsert = true; } order.sRepairDesc = tbNotes.Text; order.iRepairItemId = Convert.ToInt32(ddlRepairItems.SelectedValue); order.iRepairCatId = Convert.ToInt32(ddlRepairCats.SelectedValue); if (order.UpdateRepair() == -1) { Session["lastpage"] = sCurrentPage; Session["error"] = _functions.ErrorMessage(128); Response.Redirect("error.aspx", false); return; } RepairId = order.iRepairId.Value; // saving the parts for entered repair dtParts = (DataTable)ViewState["PartsUsed"]; foreach (DataRow item in dtParts.Rows) { if ((int)item["IsNew"] == 1) { order.cAction = "U"; order.iPartUsedId = 0; order.iPartUsedQty = (int)item["Qty"]; order.sPartUsedStock = (string)item["Stock"]; order.sPartUsedDesc = (string)item["Desc"]; order.dmPartUsedCost = (decimal)item["Cost"]; order.PartsUsedDetails(); } if ((int)item["IsDeleted"] == 1) { order.cAction = "D"; order.iPartUsedId = (int)item["Id"]; if (order.PartsUsedDetails() == -1) { Session["lastpage"] = sCurrentPage; Session["error"] = _functions.ErrorMessage(125); Response.Redirect("error.aspx", false); return; } } } if (Mode && html_chNewRepair.Checked && sType == "II") { order.iInspectItemId = ItemId; foreach (RepeaterItem item in repReportedIssues.Items) { CheckBox cbTmp = (CheckBox)item.FindControl("cbIssue"); if (cbTmp.Checked && cbTmp.Enabled) { order.iReportedIssueId = Convert.ToInt32(cbTmp.Attributes["CommandArgument"]); order.SetAssociationsIssue(); } } } if (Hours > 0.0) { user = new clsUsers(); user.iOrgId = OrgId; user.iOrderId = OrderId; if (user.GetTechnicianInfo() != -1) { order.cAction = "U"; order.iTimeLogId = 0; order.iTechId = user.iId; order.daStartTime = SqlDateTime.Null; order.daStopTime = SqlDateTime.Null; order.dmHours = Convert.ToDecimal(Hours); order.dmHourlyRate = user.dmHourlyRate; order.sNote = tbNotes.Text; order.TimeLogDetails(); } } // } // else // lblRequestor.Visible = true; } catch (FormatException fex) { Header.ErrorMessage = _functions.ErrorMessage(205); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { if (user != null) user.Dispose(); if (order != null) order.Dispose(); } }
private void btSave_FormSubmit(object sender, EventArgs e) { DateTime daCurrentDate; try { daCurrentDate = DateTime.Now; order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; order.sInitials = Signature.sInitials; order.sPIN = Signature.sPIN; order.dmMileage = Convert.ToDecimal(tbMileage.Text); order.bStaying = Convert.ToBoolean(rblStaying.SelectedValue); order.sDropedOffBy = tbDroppedOffBy.Text; order.daCurrentDate = _functions.CorrectDate(adtCheckIn.Date); if(order.SigningEquipmentCheckIn() == -1) { Signature.sError = _functions.ErrorMessage(140); } else { order.cAction = "U"; order.iNoteId = 0; order.iItemId = OrderId; order.daCreated = daCurrentDate; if(tbNotes.Text.Length > 0) { order.iNoteTypeId = (int)NoteTypes.OperatorNote; order.sNote = tbNotes.Text; order.NoteDetails(); } // redirect to the finish screen BackFinishScreen finish = new BackFinishScreen(); finish.sMainText = "The Equipment has been checked-in successfully!"; finish.bMainMenuVisible = true; finish.sMainMenuText = "[Return to Main Menu]"; finish.sMainMenuURL = "main.aspx"; finish.bContinueVisible = true; finish.sContinueText = "[Continue to Open Work Order]"; finish.sContinueURL = "wo_openWorkOrder.aspx?id=" + OrderId.ToString(); finish.bViewVisible = true; finish.sViewText = "[Return to Work Order Detail]"; finish.sViewURL = "wo_viewWorkOrder.aspx?id=" + OrderId.ToString(); finish.bAdditionalVisible = false; finish.bPrintVisible = false; Session["BackFinish"] = finish; Response.Redirect("wo_finish.aspx", false); } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_viewCheckIn.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 btNext_FormSubmit(object sender, EventArgs e) { try { DateTime dtCurrentTime = DateTime.Now; order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; order.iOperatorId = op.Id; if(Operation == "AddIssueReOpen") order.iReOpenCategoryId = 2; //Forgot to report an issue else if(Operation == "AddCommentReOpen") order.iReOpenCategoryId = 1; //Issue not resolved else { Header.ErrorMessage = _functions.ErrorMessage(166); return; } order.daCurrentDate = dtCurrentTime; if(order.UpdateReOpenWorkOrder() == -1) { Session["lastpage"] = "ok_reopenWorkOrder.aspx?id=" + OrderId.ToString() + "&op=Issue"; Session["error"] = _functions.ErrorMessage(120); Response.Redirect("error.aspx", false); return; } order.iUserId = op.Id; if(order.SigningWorkOrderReOpen() == -1) { Session["lastpage"] = "ok_reopenWorkOrder.aspx?id=" + OrderId.ToString() + "&op=Issue"; Session["error"] = _functions.ErrorMessage(120); Response.Redirect("error.aspx", false); return; } Response.Redirect("ok_viewReOpen.aspx?id=" + OrderId.ToString(), false); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "ok_reopenWorkOrder.aspx?id=" + OrderId.ToString() + "&op=Issue"; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(order != null) order.Dispose(); } }
/// <summary> /// Saving the history for current PM item /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, System.EventArgs e) { try { order = new clsWorkOrders(); order.cAction = "U"; order.iPMHistoryId = HistoryId; order.iOrgId = OrgId; order.iSchedDetailId = SchedDetailId; order.iId = OrderId; order.iEquipId = (Int32)ViewState["EquipId"]; if(tblMain.Rows[4].Visible == false) order.daDateHistory = DateTime.Now; else order.daDateHistory = adtLastTime.Date; if(tblMain.Rows[5].Visible == false) order.dmUnitsHistory = (SqlDecimal)0; else order.dmUnitsHistory = Convert.ToDecimal(tbUnits.Text); if(order.PMHistoryDetail() != -1) { // closing current window and relaod parent window sOnLoad = "window.close();opener.document.formAddPMItems.submit();"; Session["reload"] = true; } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); } finally { if(order != null) order.Dispose(); } }
private void btnAddRepair_Click(object sender, System.EventArgs e) { try { order = new clsWorkOrders(); equip = new clsEquipment(); equip.iId = EquipId; equip.iOrgId = OrgId; order.cAction = "U"; order.iOrgId = OrgId; order.iEquipId = EquipId; order.iReportedIssueId = 0; order.iRepairCatId = Convert.ToInt32(ddlCategory.SelectedValue); order.sReportDesc = tbDesc.Text; order.iId = SqlInt32.Null; order.iServiceResultId = SqlInt32.Null; order.iServiceCheckId = SqlInt32.Null; order.iRepairMultId = SqlInt32.Null; if(order.WorkOrderReportedIssuesDetail() == -1) { Session["lastpage"] = sCurrentPage; Session["error"] = _functions.ErrorMessage(121); Response.Redirect("error.aspx", false); } tbDesc.Text = ""; ddlCategory.SelectedIndex = 0; ShowIssues(); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = sCurrentPage; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(equip != null) equip.Dispose(); if(order != null) order.Dispose(); } }
private void dgUnAssignedIssues_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { try { order = new clsWorkOrders(); equip = new clsEquipment(); equip.iId = EquipId; equip.iOrgId = OrgId; order.cAction = "S"; order.iOrgId = OrgId; order.iReportedIssueId = Convert.ToInt32(((Label)e.Item.FindControl("lblReportIssueId")).Text); if(order.WorkOrderReportedIssuesDetail() == -1) { Session["lastpage"] = sCurrentPage; Session["error"] = _functions.ErrorMessage(121); Response.Redirect("error.aspx", false); return; } order.cAction = "U"; order.sReportDesc = ((TextBox)e.Item.FindControl("tbIssueName")).Text; if(order.WorkOrderReportedIssuesDetail() == -1) { Session["lastpage"] = sCurrentPage; Session["error"] = _functions.ErrorMessage(121); Response.Redirect("error.aspx", false); return; } dgUnAssignedIssues.EditItemIndex = -1; ShowIssues(); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = sCurrentPage; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(equip != null) equip.Dispose(); if(order != null) order.Dispose(); } }
/// <summary> /// Procedure is showing completed work orders on screen /// </summary> private void ShowCompletedOrders() { try { order = new clsWorkOrders(); order.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); order.sEquipId = ""; //tbEquipId.Text; order.iOperatorId = 0; //Convert.ToInt32(ddlDrivers.SelectedValue); dgCompletedWorkOrders.DataSource = new DataView(order.GetWOCompletedList()); dgCompletedWorkOrders.DataBind(); } catch(Exception ex) { throw new Exception(ex.Message, ex); } finally { if(order != null) order.Dispose(); } }
private void ShowWorkOrders() { try { lblCurrentDate.Text = dtCurrentDate.ToLongDateString(); order = new clsWorkOrders(); order.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); switch(dtCurrentDate.DayOfWeek) { case DayOfWeek.Monday: l_iWeekDay = 0; break; case DayOfWeek.Tuesday: l_iWeekDay = 1; break; case DayOfWeek.Wednesday: l_iWeekDay = 2; break; case DayOfWeek.Thursday: l_iWeekDay = 3; break; case DayOfWeek.Friday: l_iWeekDay = 4; break; case DayOfWeek.Saturday: l_iWeekDay = 5; break; case DayOfWeek.Sunday: l_iWeekDay = 6; break; } lblMondayDate.Text = "Monday " + dtCurrentDate.AddDays(-(l_iWeekDay)).ToShortDateString(); lblTuesdayDate.Text = "Tuesday " + dtCurrentDate.AddDays(1-l_iWeekDay).ToShortDateString(); lblWednesdayDate.Text = "Wednesday " + dtCurrentDate.AddDays(2-l_iWeekDay).ToShortDateString(); lblThursdayDate.Text = "Thursday " + dtCurrentDate.AddDays(3-l_iWeekDay).ToShortDateString(); lblFridayDate.Text = "Friday " + dtCurrentDate.AddDays(4-l_iWeekDay).ToShortDateString(); lblWeekendDate.Text = "Saturday/Sunday " + dtCurrentDate.AddDays(5-l_iWeekDay).ToShortDateString() + " - " + dtCurrentDate.AddDays(6-l_iWeekDay).ToShortDateString(); order.daMaxDate = dtCurrentDate.AddDays(7-l_iWeekDay); order.daMinDate = dtCurrentDate.AddDays(-(l_iWeekDay)); dtWorkOrders = order.GetWOListForDate(); // Monday dwOrderMonday = new DataView(dtWorkOrders); dwOrderMonday.RowFilter = "[WeekDay] = 2"; dgWorkOrdersMonday.DataSource = dwOrderMonday; dgWorkOrdersMonday.DataBind(); // Tuesday dwOrderTuesday = new DataView(dtWorkOrders); dwOrderTuesday.RowFilter = "[WeekDay] = 3"; dgWorkOrdersTuesday.DataSource = dwOrderTuesday; dgWorkOrdersTuesday.DataBind(); // Wednesday dwOrderWednesday = new DataView(dtWorkOrders); dwOrderWednesday.RowFilter = "[WeekDay] = 4"; dgWorkOrdersWednesday.DataSource = dwOrderWednesday; dgWorkOrdersWednesday.DataBind(); // Thursday dwOrderThursday = new DataView(dtWorkOrders); dwOrderThursday.RowFilter = "[WeekDay] = 5"; dgWorkOrdersThursday.DataSource = dwOrderThursday; dgWorkOrdersThursday.DataBind(); // Friday dwOrderFriday = new DataView(dtWorkOrders); dwOrderFriday.RowFilter = "[WeekDay] = 6"; dgWorkOrdersFriday.DataSource = dwOrderFriday; dgWorkOrdersFriday.DataBind(); // Weekend dwOrderWeekend = new DataView(dtWorkOrders); dwOrderWeekend.RowFilter = "[WeekDay] in (1,7)"; dgWorkOrdersWeekend.DataSource = dwOrderWeekend; dgWorkOrdersWeekend.DataBind(); Session["CurrentDay"] = dtCurrentDate; } catch(Exception ex) { throw new Exception(ex.Message, ex); } finally { if(order != null) order.Dispose(); } }
private void SelectXmlTimeSheet() { XslTransform trans = null; XmlDocument doc = null; XsltArgumentList agr = null; string _input; TimeSpan times; int iTime = 0; try { GetTimeFromRS(ref iTime); times = Cal.SelectedDate.Subtract(new DateTime(1970, 1, 1)); order = new clsWorkOrders(); order.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); order.daCurrentDate = Cal.SelectedDate; doc = new XmlDocument(); doc.LoadXml(order.GetWOListForTime()); trans = new XslTransform(); trans.Load(Server.MapPath("ShowTime.xsl")); agr = new XsltArgumentList(); agr.AddParam("selected", "", ((long)(times.Ticks/10000)).ToString()); agr.AddParam("formname", "", (string)ViewState["formname"]); agr.AddParam("id", "", (string)ViewState["id"]); agr.AddParam("postBack", "", (string)ViewState["postBack"]); agr.AddParam("TimeSelected", "", iTime); xmlTimeSheet.Document = doc; xmlTimeSheet.Transform = trans; xmlTimeSheet.TransformArgumentList = agr; } catch(Exception ex) { throw new Exception(ex.Message, ex); } finally { if(order != null) order.Dispose(); } }
private void dgRepairs_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { try { switch(e.CommandName) { case "Unassign": order = new clsWorkOrders(); order.cAction = "S"; order.iOrgId = OrgId; order.iReportedIssueId = Convert.ToInt32(e.Item.Cells[0].Text); if(order.WorkOrderReportedIssuesDetail() == -1) { Session["lastpage"] = m_sBackUrl; Session["error"] = _functions.ErrorMessage(121); Response.Redirect("error.aspx", false); return; } order.cAction = "U"; order.iLastWorkOrderId = order.iId; order.iId = SqlInt32.Null; order.WorkOrderReportedIssuesDetail(); ShowIssues(OrderId); break; case "Delete": order = new clsWorkOrders(); order.cAction = "D"; order.iOrgId = OrgId; order.iReportedIssueId = Convert.ToInt32(e.Item.Cells[0].Text); if(order.WorkOrderReportedIssuesDetail() == -1) { Session["lastpage"] = m_sBackUrl; Session["error"] = _functions.ErrorMessage(121); Response.Redirect("error.aspx", false); return; } ShowIssues(OrderId); break; default: break; } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = m_sBackUrl; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(order != null) order.Dispose(); } }
/// <summary> /// Procedure is showing all work orders for current date /// </summary> private void ShowWorkOrders() { try { lblCurrentDate.Text = dtCurrentDate.ToLongDateString(); order = new clsWorkOrders(); order.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); order.daMaxDate = dtCurrentDate.AddDays(1); order.daMinDate = dtCurrentDate; dgWorkOrders.DataSource = new DataView(order.GetWOListForDate()); dgWorkOrders.DataBind(); Session["CurrentDay"] = dtCurrentDate; } catch(Exception ex) { throw new Exception(ex.Message, ex); } finally { if(order != null) order.Dispose(); } }
/// <summary> /// Procedure is adding a new work order into database and redirecting to finish screen /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btNext_FormSubmit(object sender, EventArgs e) { string sDataGridName; DBFieldType FieldType; DateTime daTmpForFixBug, daCurrent; try { daCurrent = DateTime.Now; if(adtScheduled.Date < daCurrent) { lblErrorScheduled.Text = "The Scheduled date must be in future"; return; } order = new clsWorkOrders(); order.iOrgId = OrgId; order.iEquipId = EquipId; if(adtScheduled.Date.Hour == 0 || adtScheduled.Date.Hour == 12) { daTmpForFixBug = adtScheduled.Date; if(daTmpForFixBug.Hour == 0)daTmpForFixBug = daTmpForFixBug.AddHours(12); else daTmpForFixBug = daTmpForFixBug.AddHours(-12); } else daTmpForFixBug = adtScheduled.Date; order.daScheduled = daTmpForFixBug; order.iInspectSchedDetailId = InspectSchedDetailId; order.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); order.daCurrentDate = daCurrent; order.SetInspectWorkOrder(); if(tbNotes.Text.Length > 0) { order.cAction = "U"; order.iNoteId = 0; order.iNoteTypeId = (int)NoteTypes.CreationNote; order.iItemId = order.iId; order.daCreated = daCurrent; order.sNote = tbNotes.Text; order.NoteDetails(); } BackFinishScreen finish = new BackFinishScreen(); finish.sMainText = "The Work Order with Inspection has been created successfully."; finish.bMainMenuVisible = true; finish.sMainMenuText = "[Return to Main Menu]"; finish.sMainMenuURL = "main.aspx"; finish.bContinueVisible = true; finish.sContinueText = "[Create a New Future Work Order with Inspection]"; finish.sContinueURL = "wo_showEquipsForInspect.aspx"; finish.bViewVisible = true; finish.sViewText = "[View a new Work Order with Inspection]"; finish.sViewURL = "wo_viewWorkOrder.aspx?id=" + order.iId.Value.ToString(); finish.bAdditionalVisible = false; finish.bPrintVisible = false; Session["BackFinish"] = finish; Response.Redirect("wo_finish.aspx", false); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_addInspectForecast.aspx?equipid=" + EquipId.ToString() + "&sid=" + InspectSchedDetailId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(order != null) order.Dispose(); } }
/// <summary> /// Selecting or creating of the Work Order for /// current Equipment if for current equipment there aren't /// the scheduled work order then it will be created. /// If there are one work order then select him. /// If them more than one then we are selecting the one that has /// the scheduled time by closer to the current moment. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btNext_FormSubmit(object sender, EventArgs e) { try { order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; order.iEquipId = EquipId; order.daCurrentDate = DateTime.Now; order.dmMileage = Convert.ToDecimal(tbUnits.Text); order.iUserId = op.Id; order.SelectWorkOrder(); Response.Redirect("ok_addIssues.aspx?orderid=" + order.iId.Value.ToString() + "&equipid=" + EquipId.ToString(), false); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "ok_editCurrentUnits.aspx?orderid=" + OrderId.ToString() + "&equipid=" + EquipId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(order != null) order.Dispose(); } }
private void lbSaveNotes_Click(object sender, System.EventArgs e) { try { Header.BodyOnloadScript = "javascript:document.location='#Notes'"; //Header.Render(); order = new clsWorkOrders(); order.cAction = "U"; order.iOrgId = OrgId; order.iNoteId = 0; order.iNoteTypeId = (int)NoteTypes.TechnicianNote; order.iItemId = OrderId; order.daCreated = DateTime.Now; order.sNote = tbNotes.Text; order.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); order.NoteDetails(); tbNotes.Text = ""; order.iNoteTypeId = (int)NoteTypes.TechnicianNote; repTechNotes.DataSource = new DataView(order.GetNotesList()); repTechNotes.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 btnAddTimeLog_Click(object sender, System.EventArgs e) { try { double Hours = 0.0; DateTime daStartTime, daStopTime; TimeSpan tsDiff = new TimeSpan(0); daStopTime = rdiStopTime.SelectedDate; daStartTime = rdiStartTime.SelectedDate; if(tbHours.Text.Length > 0 || tbMinutes.Text.Length > 0) { if(tbHours.Text.Length > 0) Hours += Convert.ToDouble(tbHours.Text); if(tbMinutes.Text.Length > 0) Hours += Convert.ToDouble(tbMinutes.Text)/60; } else { // get hours from the difference betweent the Stop and Start time entries if(daStopTime <= daStartTime) { Header.ErrorMessage = _functions.ErrorMessage(204); return; } else { tsDiff = daStopTime - daStartTime; Hours = tsDiff.TotalHours; } } if(Hours >= 1000) { Header.ErrorMessage = _functions.ErrorMessage(203); return; } order = new clsWorkOrders(); order.cAction = "U"; order.iTimeLogId = 0; order.iOrgId = OrgId; order.iId = OrderId; order.iRepairId = Convert.ToInt32(ddlRepairs.SelectedValue); order.iTechId = Convert.ToInt32(ddlTechnicians.SelectedValue); if(tsDiff.Ticks != 0) { order.daStartTime = daStartTime; order.daStopTime = daStopTime; } else { order.daStartTime = SqlDateTime.Null; order.daStopTime = SqlDateTime.Null; } order.dmHours = Convert.ToDecimal(Hours); if(ViewState["HourlyRate"] == null) order.dmHourlyRate = Convert.ToDecimal(tbHourlyRate.Text); else order.dmHourlyRate = Convert.ToDecimal(ViewState["HourlyRate"]); order.sNote = tbNote.Text; order.TimeLogDetails(); //order.Dispose(); //order = new clsWorkOrders(); //order.iOrgId = OrgId; tbHourlyRate.Text = ""; tbHours.Text = ""; tbMinutes.Text = ""; tbNote.Text = ""; rdiStartTime.SelectedDate = dtNow; rdiStopTime.SelectedDate = dtNow; Response.Redirect("wo_updateTimeLog.aspx?id=" + OrderId.ToString() + "&repairid=" + RepairId.ToString(), false); } catch(FormatException fex) { Header.ErrorMessage = _functions.ErrorMessage(108); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_updateTimeLog.aspx?id=" + OrderId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(order != null) order.Dispose(); } }
/// <summary> /// the common procedure of saving for all associations in the Add mode in database /// </summary> private void SaveAssociations() { try { order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; order.sTypeService = sType; order.iItemId = ItemId; if (ServiceResult == "Repair") order.iServiceResultId = (int)ServiceResults._Repaired; else order.iServiceResultId = (int)ServiceResults._Replaced; foreach (RepeaterItem item in repRepairs.Items) { order.iRepairId = Convert.ToInt32(((LinkButton)item.FindControl("lbEditRepair")).CommandArgument); order.bChecked = ((CheckBox)item.FindControl("cbRepair")).Checked; order.SetAssociationsRepair(); } } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { if (order != null) order.Dispose(); } }
private void btNext_FormSubmit(object sender, EventArgs e) { DateTime daCurrentDate; try { UserId = Convert.ToInt32(ddlTech.SelectedValue); daCurrentDate = DateTime.Now; order = new clsWorkOrders(); order.iOrgId = OrgId; order.iEquipId = EquipId; order.daCurrentDate = daCurrentDate; order.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); order.iId = OrderId; order.iTechId = UserId; order.SetRoadsideWorkOrder(); OrderId = order.iId.Value; Response.Redirect("wo_selectSpareEquip.aspx?select=AddRoadside&id=" + OrderId.ToString() + "&equipid=" + EquipId.ToString(), false); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_selectOperator.aspx?equipid=" + EquipId.ToString() + "&orderid=" + OrderId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(order != null) order.Dispose(); } }
/// <summary> /// Procedure close the work order detail /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btSave_FormSubmit(object sender, EventArgs e) { DateTime daCurrentDate; try { daCurrentDate = DateTime.Now; order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; order.sInitials = Signature.sInitials; order.sPIN = Signature.sPIN; order.sReleasedTo = tbReleasedTo.Text; order.daCurrentDate = _functions.CorrectDate(adtCheckOut.Date); // signing the Check-Out of Equipment by Technician if(order.SigningEquipmentCheckOut() == -1) { Signature.sError = _functions.ErrorMessage(140); } else { equip = new clsEquipment(); equip.iOrgId = OrgId; equip.iUserId = order.iUserId; equip.iOrderId = OrderId; equip.iId = System.Data.SqlTypes.SqlInt32.Null; equip.sNote = ""; equip.EquipSpareTo(false); // redirect to the finish screen BackFinishScreen finish = new BackFinishScreen(); finish.sMainText = "The Equipment has been checked-out successfully!"; finish.bMainMenuVisible = true; finish.sMainMenuText = "[Return to Main Menu]"; finish.sMainMenuURL = "main.aspx"; finish.bContinueVisible = false; finish.bViewVisible = true; finish.sViewText = "[Return to Work Order Detail]"; finish.sViewURL = "wo_viewWorkOrder.aspx?id=" + OrderId.ToString(); finish.bAdditionalVisible = false; finish.bPrintVisible = false; Session["BackFinish"] = finish; Response.Redirect("wo_finish.aspx", false); } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_viewCheckOut.aspx?id=" + OrderId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(equip != null) equip.Dispose(); if(order != null) order.Dispose(); } }
private void btNext_FormSubmit(object sender, EventArgs e) { try { order = new clsWorkOrders(); if(ddlCategory.SelectedIndex != 0 && tbDesc.Text.Length != 0) { order.cAction = "U"; order.iOrgId = OrgId; order.iReportedIssueId = 0; order.iRepairCatId = Convert.ToInt32(ddlCategory.SelectedValue); order.sReportDesc = tbDesc.Text; order.iId = OrderId; order.iServiceResultId = SqlInt32.Null; order.iServiceCheckId = SqlInt32.Null; order.iRepairMultId = SqlInt32.Null; if(order.WorkOrderReportedIssuesDetail() == -1) { Session["lastpage"] = m_sBackUrl; Session["error"] = _functions.ErrorMessage(121); Response.Redirect("error.aspx", false); return; } } if(m_sBack == "open") Response.Redirect("wo_addPreventiveMaintenance.aspx?id=" + OrderId.ToString(), false); else { // redirect to finish screen order.iOrgId = OrgId; order.iId = OrderId; if(order.GetWorkOrderId() == -1) { Session["lastpage"] = m_sBackUrl; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } BackFinishScreen finish = new BackFinishScreen(); finish.sMainText = "The Work Order " + order.daCreated.Value.ToString("yyyy-MM-dd") + "-" + order.iWorkOrderNumber.Value.ToString() + " has been created successfully!"; finish.bMainMenuVisible = true; finish.sMainMenuText = "[Return to Main Menu]"; finish.sMainMenuURL = "main.aspx"; finish.bContinueVisible = true; finish.sContinueText = "[Continue to Check-In Equipment by Technician]"; finish.sContinueURL = "wo_viewCheckIn.aspx?id=" + OrderId.ToString(); finish.bViewVisible = true; finish.sViewText = "[View the Scheduled Work Order]"; finish.sViewURL = "wo_viewWorkOrder.aspx?id=" + OrderId.ToString(); finish.bAdditionalVisible = true; finish.sAdditionalText = "[Create a New Work Order]"; finish.sAdditionalURL = "wo_default.aspx"; finish.bPrintVisible = false; Session["BackFinish"] = finish; Response.Redirect("wo_finish.aspx", false); } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = m_sBackUrl; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(order != null) order.Dispose(); } }
private void btnYES_Click(object sender, System.EventArgs e) { try { order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; order.bStaying = true; if(order.UpdateStayingWorkOrder() == -1) { Session["lastpage"] = "ok_editStaying.aspx?orderid=" + OrderId.ToString() + "&equipid=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(120); Response.Redirect("error.aspx", false); } else Response.Redirect("ok_editNote.aspx?orderid=" + OrderId.ToString() + "&equipid=" + EquipId.ToString(), false); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "ok_editStaying.aspx?orderid=" + OrderId.ToString() + "&equipid=" + EquipId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(order != null) order.Dispose(); } }
/// <summary> /// Procedure is processing the inspections on screen, i.e. to add or delete /// if them check boxes was selected/unselected /// </summary> private void ProcessingItems() { try { order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; foreach(DataGridItem item in dgInspections.Items) { if(((CheckBox)item.FindControl("chAdd")).Enabled) { if(IsPast) order.daCurrentDate = ((DateTime)ViewState["WorkOrderCreatedDate"]); else order.daCurrentDate = DateTime.Now; order.iInspectSchedDetailId = Convert.ToInt32(item.Cells[0].Text); order.iWOInspectionId = Convert.ToInt32(item.Cells[1].Text); order.bChecked = ((CheckBox)item.FindControl("chAdd")).Checked; order.UpdateInspection(); } } } catch(Exception ex) { throw new Exception(ex.Message, ex); } finally { if(order != null) order.Dispose(); } }
/// <summary> /// Procedure is updating the work order info /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btSave_FormSubmit(object sender, EventArgs e) { string sDataGridName; DBFieldType FieldType; DateTime daCurrentDate, daScheduled; try { #region saving the static data daCurrentDate = DateTime.Now; status = (WorkOrderStatus)ViewState["StatusId"]; order = new clsWorkOrders(); order.cAction = "U"; order.bWizardUpdate = false; order.iOrgId = OrgId; order.iId = OrderId; order.iTypeId = Convert.ToInt32(rblWOTypes.SelectedValue); order.iTechId = Convert.ToInt32(ddlTech.SelectedValue); order.bStaying = Convert.ToBoolean(rblStaying.SelectedValue); order.sDropedOffBy = tbDroppedOffBy.Text; order.sReleasedTo = tbReleasedTo.Text; order.sCleanliness = tbCleanliness.Text; order.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); if(ViewState["ScheduledDate"] == null) { order.daScheduled = _functions.CorrectDate(adtScheduled.Date); } else order.daScheduled = (DateTime)ViewState["ScheduledDate"]; if(trCheckInDate.Visible) order.daArrival = _functions.CorrectDate(adtCheckIn.Date); if(trOpenedDate.Visible) order.daOpened = _functions.CorrectDate(adtOpened.Date); if(trClosedDate.Visible) order.daClosed = _functions.CorrectDate(adtClosed.Date); if(trCheckOutDate.Visible) order.daDeparture = _functions.CorrectDate(adtCheckOut.Date); order.daUpdated = daCurrentDate; if(order.WorkOrderDetails() == -1) { Session["lastpage"] = "wo_editWorkOrder.aspx?id=" + OrderId.ToString(); Session["error"] = _functions.ErrorMessage(120); Response.Redirect("error.aspx", false); return; } #endregion if(status == WorkOrderStatus.Open || status == WorkOrderStatus.ReOpened) { #region saving cutom fields if(ViewState["CustomFields"] != null) { order.iId = OrderId; dtCustomFields = (DataTable)ViewState["CustomFields"]; sDataGridName = repCustomFields.ClientID; // getting data from Form and changing the dtCustomFields datatable for(int i=0; i<dtCustomFields.Rows.Count; i++) { for(int j=0; j<Request.Form.Count; j++) { if((string)dtCustomFields.Rows[i]["TypeName"] == Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":inputTypeName"]) { FieldType = _functions.TypeNameParser((string)dtCustomFields.Rows[i]["TypeName"]); // nvarchar1...n, ... switch(FieldType) { case DBFieldType._nvarchar: dtCustomFields.Rows[i]["Value_String"] = Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":tbValue"]; break; case DBFieldType._int: dtCustomFields.Rows[i]["Value_String"] = Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":tbValue"]; break; case DBFieldType._float: dtCustomFields.Rows[i]["Value_String"] = Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":tbValue"]; break; case DBFieldType._datetime: dtCustomFields.Rows[i]["Value_String"] = new SqlDateTime(Convert.ToInt32(Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":adtValue_year"]), Convert.ToInt32(Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":adtValue_month"]), Convert.ToInt32(Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":adtValue_day"])); break; case DBFieldType._bit: if(Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":chValue"] != null) { dtCustomFields.Rows[i]["Value_String"] = "True"; } else { dtCustomFields.Rows[i]["Value_String"] = "False"; } break; case DBFieldType._ntext: dtCustomFields.Rows[i]["Value_String"] = Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":tbValue"]; break; case DBFieldType._sql_variant: dtCustomFields.Rows[i]["Value_String"] = Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":tbValue"]; break; case DBFieldType._lookup: dtCustomFields.Rows[i]["Value_String"] = Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":ddlValue"]; break; default: dtCustomFields.Rows[i]["Value_String"] = Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":tbValue"]; break; } } } } // saving data to database order.WorkOrderDetail_CustomFields(_functions.SetDataToParameters(dtCustomFields)); } #endregion } Response.Redirect("wo_viewWorkOrder.aspx?id=" + OrderId.ToString() + "&#Main", false); } catch(FormatException fex) { Session["lastpage"] = "wo_editWorkOrder.aspx?id=" + OrderId.ToString(); Session["error"] = _functions.ErrorMessage(108); Response.Redirect("error.aspx", false); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_editWorkOrder.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 btnAddPart_Click(object sender, System.EventArgs e) { try { OrderId = (int)ViewState["OrderId"]; RepairId = (int)ViewState["RepairId"]; InspectId = (int)ViewState["InspectId"]; order = new clsWorkOrders(); order.cAction = "U"; order.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); order.iPartUsedId = 0; order.iRepairId = RepairId; order.iPartUsedQty = Convert.ToInt32(tbQty.Text); order.sPartUsedStock = tbStock.Text; order.sPartUsedDesc = tbDesc.Text; if(tbCost.Text.Length > 0) order.dmPartUsedCost = Convert.ToDecimal(tbCost.Text); order.PartsUsedDetails(); tbQty.Text = ""; tbStock.Text = ""; tbDesc.Text = ""; tbCost.Text = ""; dgParts.DataSource = new DataView(order.GetPartsUsedList()); dgParts.DataBind(); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_editPartsUsed.aspx?id=" + OrderId.ToString() + "&repairid=" + RepairId.ToString() + "&inspectid=" + InspectId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(order != null) order.Dispose(); } }