private void btSave_FormSubmit(object sender, EventArgs e) { try { equip = new clsEquipment(); equip.cAction="U"; equip.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); equip.iId = 0; // adding a Equipment equip.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); equip.iTypeId = Convert.ToInt32(ddlTypes.SelectedValue); equip.iModelId = mmValue.ModelId; equip.iYear = Convert.ToInt32(tbYear.Text); equip.iDeptId = Convert.ToInt32(ddlDepts.SelectedValue); equip.iLocId = Convert.ToInt32(ddlLocs.SelectedValue); equip.bShare = chShare.Checked; equip.sFuelCode = tbFuelCode.Text; equip.sEquipId = tbEquipId.Text; equip.sVinSerial = tbVinSerial.Text; equip.sPlateNumber = tbPlateNumber.Text; // saving data to database EquipId = equip.EquipmentDetail(); if(EquipId > 0) { sURL_return = "reassign.aspx?id=" + EquipId.ToString(); } else { Session["lastpage"] = "addEquip.aspx"; Session["error"] = _functions.ErrorMessage(103); sURL_return = "error.aspx"; } } catch(FormatException fex) { Session["lastpage"] = "addEquip.aspx"; Session["error"] = _functions.ErrorMessage(108); sURL_return = "error.aspx"; } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "addEquip.aspx"; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); sURL_return = "error.aspx"; } finally { if(equip!=null) { equip.Dispose(); } Response.Redirect(sURL_return, true); } }
private void EquipmentDetails() { try { if(OrderId != 0) { order = new clsWorkOrders(); order.cAction = "S"; order.iOrgId = OrgId; order.iId = OrderId; if(order.WorkOrderDetails() == -1) { Session["lastpage"] = "wo_default.aspx?select=AddRoadside"; Session["error"] = _functions.ErrorMessage(120); Response.Redirect("error.aspx", false); return; } if(ddlTech.Items.FindByValue(order.iTechId.Value.ToString()) != null) ddlTech.SelectedValue = order.iTechId.Value.ToString(); EquipId = order.iEquipId.Value; } equip = new clsEquipment(); equip.iOrgId = OrgId; equip.iId = EquipId; equip.cAction = "S"; if(equip.EquipmentDetail() == -1) { Session["lastpage"] = "wo_default.aspx?select=AddRoadside"; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } lblOperator.Text = equip.sEquipOperator.Value; lblTempOperator.Text = equip.sTempOperator.Value; lblEquipId.Text = equip.sEquipId.Value; lblEquipType.Text = equip.sType.Value; lblMakeModel.Text = equip.sMakeModelName.Value; lblYear.Text = equip.iYear.Value.ToString(); lblSerial.Text = equip.sVinSerial.Value; lblEquipId2.Text = equip.sEquipId.Value; lblEquipType2.Text = equip.sType.Value; } catch(Exception ex) { throw new Exception(ex.Message, ex); } finally { if(order != null) order.Dispose(); if(equip != null) equip.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"] = "e_list.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { EquipId = Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = "e_list.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } Header.AddBreadCrumb("Home", "/main.aspx"); Header.AddBreadCrumb("Equipment List", "/e_list.aspx"); Header.AddBreadCrumb("Equipment Detail", "/e_view.aspx?id="+EquipId.ToString()); Header.LeftBarHtml = "Reassign Equipment Operator"; SaveCancelControl.ParentPageURL = this.ParentPageURL; if(!IsPostBack) { equip = new clsEquipment(); equip.iOrgId = OrgId; equip.iId = EquipId; equip.cAction = "S"; dtUsers = equip.GetEquipAssignTo(); if(dtUsers.Rows.Count < 1) { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(111); Response.Redirect("error.aspx", false); return; } ddAssignTo.DataTextField = "vchName"; ddAssignTo.DataValueField = "id"; ddAssignTo.DataSource = new DataView(dtUsers); ddAssignTo.DataBind(); ddAssignTo.Items.Insert(0, new ListItem("Nobody", "0")); // getting equipment's data if(equip.EquipmentDetail() != 0) { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } lblEquipment.Text = equip.sEquipId.Value; lblType.Text = equip.sType.Value; lblMakeModel.Text = equip.sMakeModelName.Value; lblYear.Text = equip.iYear.Value.ToString(); lblSerial.Text = equip.sVinSerial.Value; lblFuelCode.Text = equip.sFuelCode.Value; lblDepartment.Text = equip.sDeptName.Value; lblLocation.Text = equip.sLocName.Value; lblSpare.Text = equip.bSpare.Value?"Yes":"No"; lbAssignFrom.Text = equip.sEquipOperator.Value; } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = ParentPageURL; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(loc != null) { loc.Dispose(); } if(dep != null) { dep.Dispose(); } if(mm != null) { mm.Dispose(); } if(equip != null) { equip.Dispose(); } } }
private void btSave_FormSubmit(object sender, EventArgs e) { try { if(Request.QueryString["id"] == null) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { EquipId=Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } equip = new clsEquipment(); equip.cAction = "S"; equip.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); equip.iId = EquipId; if(equip.EquipmentDetail() != -1) { equip.cAction = "U"; equip.iStatusId = Convert.ToInt32(ddStatusId.SelectedValue); equip.iPMSched = Convert.ToInt32(ddPMScheduleId.SelectedValue) != 0 ? Convert.ToInt32(ddPMScheduleId.SelectedValue) : SqlInt32.Null; equip.iInspectId = Convert.ToInt32(ddInspectionId.SelectedValue) != 0 ? Convert.ToInt32(ddInspectionId.SelectedValue) : SqlInt32.Null; equip.iCurrentUnits = Convert.ToInt32(tbCurrentUnits.Text); switch(equip.EquipmentDetail()) { case -1: Session["lastpage"] = "edit2.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(107); Response.Redirect("error.aspx", false); return; case 1: Session["lastpage"] = "edit2.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(109); Response.Redirect("error.aspx", false); return; default: break; } } else { Session["lastpage"] = "edit2.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(107); Response.Redirect("error.aspx", false); return; } Response.Redirect("view.aspx?id="+EquipId+"", false); } catch(FormatException fex) { Session["lastpage"] = "edit2.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(108); Response.Redirect("error.aspx", false); } catch(Exception ex) { _functions.Log("Application error: \n" + ex.ToString()); Session["lastpage"] = "edit2.aspx?id=" + EquipId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(equip != null) { equip.Dispose(); } } }
private void Page_Load(object sender, System.EventArgs e) { try { if(Request.QueryString["id"] == null) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { EquipId=Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } string [,] arrBrdCrumbs = new string [3,2]; arrBrdCrumbs[0,0]="main.aspx"; arrBrdCrumbs[0,1]="Home"; arrBrdCrumbs[1,0]="list.aspx"; arrBrdCrumbs[1,1]="Equipment List"; arrBrdCrumbs[2,0]="view.aspx?id="+EquipId+""; arrBrdCrumbs[2,1]="Equipment Detail"; PageTitle = "Equipment-Edit Alt"; Header.BrdCrumbs=ParseBreadCrumbs(arrBrdCrumbs,PageTitle); Header.PageTitle=PageTitle; SaveCancelControl.ParentPageURL= ParentPageURL; if(!IsPostBack) { equip = new clsEquipment(); pm = new clsPMSchedService(); inspec = new clsInspections(); equip.cAction = "S"; equip.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); equip.iId = EquipId; pm.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); inspec.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); ddStatusId.DataTextField = "vchName"; ddStatusId.DataValueField = "Id"; ddStatusId.DataSource = new DataView(equip.GetEquipStatusList()); ddStatusId.DataBind(); ddPMScheduleId.DataTextField = "vchName"; ddPMScheduleId.DataValueField = "Id"; ddPMScheduleId.DataSource = new DataView(pm.GetPMSchedulesList()); ddPMScheduleId.DataBind(); ddPMScheduleId.Items.Insert(0, new ListItem("", "0")); ddInspectionId.DataTextField = "vchName"; ddInspectionId.DataValueField = "Id"; ddInspectionId.DataSource = new DataView(inspec.GetInspectionsList()); ddInspectionId.DataBind(); ddInspectionId.Items.Insert(0, new ListItem("", "0")); // getting equipment's data if(equip.EquipmentDetail() != -1) { ddStatusId.SelectedValue = Convert.ToString(equip.iStatusId); ddPMScheduleId.SelectedValue = Convert.ToString(equip.iPMSched); ddInspectionId.SelectedValue = Convert.ToString(equip.iInspectId); tbCurrentUnits.Text = Convert.ToString(equip.iCurrentUnits); } else { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); } } } catch(Exception ex) { _functions.Log("Application error: \n" + ex.ToString()); Session["lastpage"] = ParentPageURL; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(inspec != null) { inspec.Dispose(); } if(pm != null) { pm.Dispose(); } if(equip != null) { equip.Dispose(); } } }
private void Page_Load(object sender, System.EventArgs e) { int j; bool bVisibleLink; try { OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); if(Request.QueryString["id"] == null) { Session["lastpage"] = "e_list.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { EquipId = Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = "e_list.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } if(!IsPostBack) { hlEdit.NavigateUrl = "e_edit.aspx?id=" + EquipId.ToString(); hlEdit2.NavigateUrl = "e_edit2.aspx?id=" + EquipId.ToString(); hlEditCustom.NavigateUrl = "e_editCustom.aspx?id=" + EquipId.ToString(); hlEditAquis.NavigateUrl = "e_editAquis.aspx?id=" + EquipId.ToString(); hlEditDisp.NavigateUrl = "e_editDisp.aspx?id=" + EquipId.ToString(); hlReport.NavigateUrl = "e_viewEquipAssignmentReport.aspx?id=" + EquipId.ToString(); bVisibleLink = base.CheckPermission("e_editComponent.aspx"); trAddComponent.Visible = bVisibleLink; Session["EquipId"] = EquipId; equip = new clsEquipment(); comp = new clsComponents(); dtCustomFields = new DataTable(); dtCustomFields.Columns.Add("ValueName"); dtCustomFields.Columns.Add("Value"); equip.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); equip.iOrgId = OrgId; equip.iId = EquipId; equip.cAction = "S"; // showing a Equipment's main data from fixed fields if(equip.EquipmentDetail() == -1) { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } lblEquipment.Text = equip.sEquipId.Value; lblType.Text = equip.sType.Value; lblMakeModel.Text = equip.sMakeModelName.Value; lblYear.Text = equip.iYear.Value.ToString(); lblSerial.Text = equip.sVinSerial.Value; lblFuelCode.Text = equip.sFuelCode.Value; lblPlateNumber.Text = equip.sPlateNumber.Value; lblDepartment.Text = equip.sDeptName.Value; lblLocation.Text = equip.sLocName.Value; lblSpare.Text = equip.bSpare.Value?"Yes":"No"; lblAssignedTo.Text = equip.sEquipOperator.Value; lblAssignTempTo.Text = equip.sTempOperator.Value; // showing a Equipment's Alt data from fixed fields if(equip.EquipmentDetail_Alt() == -1) { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } lbPMSched.Text = equip.sPMSched.Value; lbInspection.Text = equip.sInspectSchedule.Value; if(!equip.dmCurrentUnits.IsNull) lbUnits.Text = Convert.ToDouble(equip.dmCurrentUnits.Value).ToString(); // showing an Aquisition information from fixed fields if(equip.EquipmentDetail_Aquis() == -1) { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } if(!equip.daInService.IsNull) lbDtInService.Text = equip.daInService.Value.ToShortDateString(); if(!equip.daAquired.IsNull) lbDtAquired.Text = equip.daAquired.Value.ToShortDateString(); lbVchPurOrgContact.Text = equip.sPurOrgContact.Value; if(!equip.curPurAmount.IsNull) lbSmPurAmount.Text = equip.curPurAmount.Value.ToString(); if(!equip.dmPurUnits.IsNull) lbIntPurUnits.Text = Convert.ToDouble(equip.dmPurUnits.Value).ToString(); lbVchPurNotes.Text = equip.sPurNotes.Value; // showing a Disposal info from fixed fields if(equip.EquipmentDetail_Disp() == -1) { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } if(!equip.daOutOfService.IsNull) lbDtOutOfService.Text = equip.daOutOfService.Value.ToShortDateString(); if(!equip.daDisposed.IsNull) lbDtDisposed.Text = equip.daDisposed.Value.ToShortDateString(); if(!equip.sDispMethod.IsNull) lbVchDispMethod.Text = equip.sDispMethod.Value; if(!equip.sDispOrgContact.IsNull) lbVchDispOrgContact.Text = equip.sDispOrgContact.Value; if(!equip.curDispAmount.IsNull) lbSmDispAmount.Text = equip.curDispAmount.Value.ToString(); if(!equip.dmDispUnits.IsNull) lbIntDispUnits.Text = Convert.ToDouble(equip.dmDispUnits.Value).ToString(); lbVchDispNotes.Text = equip.sDispNotes.Value; // getting all component's types to dropdownlist comp.iEquipId = EquipId; DataTable dtComponmentAdd = comp.GetComponentTypeList(); if(dtComponmentAdd.Rows.Count > 0) { ddlComponentTypes.DataTextField = "vchName"; ddlComponentTypes.DataValueField = "Id"; ddlComponentTypes.DataSource = new DataView(dtComponmentAdd); ddlComponentTypes.DataBind(); } else { ddlComponentTypes.Items.Add(new ListItem("<none>", "0")); lbAddComponent.Enabled = false; } #region Show Custom Fileds for current equipment // getting the custom fields in the DataList control equip.iId = EquipId; dtCustomFieldsFromDB = equip.EquipmentDetail_CustomFields(null); if(dtCustomFieldsFromDB.Rows.Count > 0) { arrCFD = _functions.GetCustomFields(CFDataType.Equipment, Convert.ToInt32(dtCustomFieldsFromDB.Rows[0]["TypeId"]), HttpContext.Current.User.Identity.Name); if(arrCFD.Count > 0) { // fill custom fields for(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}); } 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, ""}); } } 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, ""}); } } 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(); comp.iEquipId = EquipId; comp.iOrgId = OrgId; dtComponents = comp.GetComponentsList(); dtComponents.Columns.Add("VisibleLink"); foreach(DataRow _row in dtComponents.Rows) { if(bVisibleLink) { _row["VisibleLink"] = "True"; } else { _row["VisibleLink"] = "False"; } } ViewState["Components"] = dtComponents; repComponents.DataSource = new DataView(dtComponents); repComponents.DataBind(); } else { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); } } } #endregion } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = ParentPageURL; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(comp != null) { comp.Dispose(); } if(loc != null) { loc.Dispose(); } if(dep != null) { dep.Dispose(); } if(mm != null) { mm.Dispose(); } if(comp != null) { comp.Dispose(); } if(equip != null) { equip.Dispose(); } } }
private void Page_Load(object sender, System.EventArgs e) { try { if(Request.QueryString["id"] == null) { Session["lastpage"] = "e_list.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); EquipId = Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = "e_list.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } Header.AddBreadCrumb("Home", "/main.aspx"); Header.AddBreadCrumb("Equipment List", "/e_list.aspx"); Header.AddBreadCrumb("Equipment Detail", "/e_view.aspx?id="+EquipId.ToString()); Header.LeftBarHtml = "Edit Main Information of Equipment"; SaveCancelControl.ParentPageURL = this.ParentPageURL; if(!IsPostBack) { equip = new clsEquipment(); loc = new clsLocations(); dep = new clsDepartments(); equip.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); equip.iOrgId = OrgId; equip.iId = EquipId; equip.cAction = "S"; dep.iOrgId = OrgId; ddlDepts.DataValueField = "Id"; ddlDepts.DataTextField = "vchName"; ddlDepts.DataSource = new DataView(dep.GetDepartmentsList()); ddlDepts.DataBind(); loc.iOrgId = OrgId; ddlLocs.DataValueField = "Id"; ddlLocs.DataTextField = "vchName"; ddlLocs.DataSource = new DataView(loc.GetLocationsList()); ddlLocs.DataBind(); // showing a Equipment's main data from fixed fields if(equip.EquipmentDetail() == -1) { Session["lastpage"] = this.ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } ViewState["EquipType"] = equip.iTypeId.Value; lblEquipOperator.Text = equip.sEquipOperator.Value; lblTempOperator.Text = equip.sTempOperator.Value; if(equip.sEquipId.IsNull) tbEquipId.Text = ""; else tbEquipId.Text = equip.sEquipId.Value; if(equip.iYear.IsNull) tbYear.Text = ""; else tbYear.Text = equip.iYear.Value.ToString(); if(equip.sVinSerial.IsNull) tbVinSerial.Text = ""; else tbVinSerial.Text = equip.sVinSerial.Value; if(equip.sFuelCode.IsNull) tbFuelCode.Text = ""; else tbFuelCode.Text = equip.sFuelCode.Value; if(equip.sPlateNumber.IsNull) tbPlateNumber.Text = ""; else tbPlateNumber.Text = equip.sPlateNumber.Value; if(equip.bSpare.IsNull) chSpare.Checked = false; else chSpare.Checked = equip.bSpare.Value; if(equip.iModelId.IsNull) { mmValue.IsComponent = false; mmValue.TypeId = equip.iTypeId.Value; mmValue.DataBind(); } else { mmValue.IsComponent = false; mmValue.TypeId = equip.iTypeId.Value; mmValue.ModelId = equip.iModelId.Value; mmValue.DataBind(); } if(!equip.iDeptId.IsNull) ddlDepts.SelectedValue = equip.iDeptId.Value.ToString(); if(!equip.iLocId.IsNull) ddlLocs.SelectedValue = equip.iLocId.Value.ToString(); } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = this.ParentPageURL; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(loc != null) { loc.Dispose(); } if(dep != null) { dep.Dispose(); } if(equip != null) { equip.Dispose(); } } }
private void Page_Load(object sender, System.EventArgs e) { try { if(Request.QueryString["id"] == null) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { EquipId=Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } string [,] arrBrdCrumbs = new string [3,2]; arrBrdCrumbs[0,0]="main.aspx"; arrBrdCrumbs[0,1]="Home"; arrBrdCrumbs[1,0]="list.aspx"; arrBrdCrumbs[1,1]="Equipment List"; arrBrdCrumbs[2,0]="view.aspx?id="+EquipId+""; arrBrdCrumbs[2,1]="Equipment Detail"; PageTitle = "Equipment-Edit Aquisition Info"; Header.BrdCrumbs=ParseBreadCrumbs(arrBrdCrumbs,PageTitle); Header.PageTitle=PageTitle; SaveCancelControl.ParentPageURL=ParentPageURL; if(!IsPostBack) { equip = new clsEquipment(); equip.cAction = "S"; equip.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); equip.iId = EquipId; // getting equipment's data if(equip.EquipmentDetail() != -1) { if(equip.daInService.IsNull) adtInService.Date = new DateTime(adtInService.MinYear, 1, 1); else adtInService.Date=equip.daInService.Value; if(equip.daAquired.IsNull) adtAquired.Date = new DateTime(adtAquired.MinYear, 1, 1); else adtAquired.Date=equip.daAquired.Value; if(equip.curPurAmount.IsNull) tbAmount.Text= ""; else tbAmount.Text=String.Format("{0:0.00}", equip.curPurAmount.Value); if(equip.iPurUnits.IsNull) tbUnits.Text=""; else tbUnits.Text=equip.iPurUnits.Value.ToString(); if(equip.sPurOrgContact.IsNull) tbOrgContact.Text = ""; else tbOrgContact.Text = equip.sPurOrgContact.Value; if(equip.sPurNotes.IsNull) tbNotes.Text = ""; else tbNotes.Text = equip.sPurNotes.Value; } else { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); } } } catch(Exception ex) { _functions.Log("Application error: \n" + ex.ToString()); Session["lastpage"] = ParentPageURL; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(equip != null) { equip.Dispose(); } } }
private void btSave_FormSubmit(object sender, EventArgs e) { try { if(Request.QueryString["id"] == null) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { EquipId=Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } equip = new clsEquipment(); equip.cAction = "S"; equip.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); equip.iId = EquipId; if(equip.EquipmentDetail() != -1) { equip.cAction = "U"; equip.daInService = adtInService.Date; equip.daAquired = adtAquired.Date; equip.curPurAmount = Convert.ToDecimal(tbAmount.Text); equip.sPurOrgContact = tbOrgContact.Text; equip.sPurNotes = tbNotes.Text; equip.iPurUnits = Convert.ToInt32(tbUnits.Text); switch(equip.EquipmentDetail()) { case -1: Session["lastpage"] = "editAquis.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(107); Response.Redirect("error.aspx", false); return; case 1: Session["lastpage"] = "editAquis.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(109); Response.Redirect("error.aspx", false); return; default: Response.Redirect("view.aspx?id="+EquipId+"", false); return; } } else { Session["lastpage"] = "editAquis.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); } } catch(FormatException fex) { Session["lastpage"] = "editAquis.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(108); Response.Redirect("error.aspx", false); } catch(Exception ex) { _functions.Log("Application error: \n" + ex.ToString()); Session["lastpage"] = "editAquis.aspx?id=" + EquipId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(equip != null) { equip.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"] = "wo_default.aspx?select=ChangeTempOper"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { EquipId = Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = "wo_default.aspx?select=ChangeTempOper"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } SaveCancelControl.ParentPageURL = ParentPageURL; if(!IsPostBack) { pnlVerifyOperator.Visible = false; pnlSelectOperator.Visible = true; equip = new clsEquipment(); equip.iOrgId = OrgId; equip.iId = EquipId; equip.cAction = "S"; if(equip.EquipmentDetail() == -1) { Session["lastpage"] = "wo_default.aspx?select=ChangeTempOper"; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } lblOperator.Text = equip.sEquipOperator.Value.Length>0?equip.sEquipOperator.Value:"Nobody"; lblTempOperator.Text = equip.sTempOperator.Value.Length>0?equip.sTempOperator.Value:"Nobody"; lblEquipId.Text = equip.sEquipId.Value; lblEquipType.Text = equip.sType.Value; lblMakeModel.Text = equip.sMakeModelName.Value; lblYear.Text = equip.iYear.Value.ToString(); lblSerial.Text = equip.sVinSerial.Value; } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_default.aspx?select=ChangeTempOper"; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { } }
private void btSave_FormSubmit(object sender, EventArgs e) { try { if(Request.QueryString["id"] == null) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(104); sURL_return = "error.aspx"; return; } try { EquipId = Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(105); sURL_return = "error.aspx"; return; } equip = new clsEquipment(); equip.cAction = "U"; equip.iId = EquipId; equip.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); equip.iModelId = mmValue.ModelId; equip.iYear = Convert.ToInt32(tbYear.Text); equip.iDeptId = Convert.ToInt32(ddlDepts.SelectedValue); equip.iLocId = Convert.ToInt32(ddlLocs.SelectedValue); equip.bShare = chShare.Checked; equip.sFuelCode = tbFuelCode.Text; equip.sEquipId = tbEquipId.Text; equip.sVinSerial = tbVinSerial.Text; equip.sPlateNumber = tbPlateNumber.Text; equip.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); if(equip.EquipmentDetail() == -1) { Session["lastpage"] = "edit.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(107); sURL_return = "error.aspx"; } else { if(cbReassign.Checked) { sURL_return = "reassign.aspx?id=" + EquipId.ToString(); } else { sURL_return = "view.aspx?id=" + EquipId.ToString(); } } } catch(FormatException fex) { Session["lastpage"] = "edit2.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(108); sURL_return = "error.aspx"; } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "edit2.aspx?id=" + EquipId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); sURL_return = "error.aspx"; } finally { if(equip != null) { equip.Dispose(); } } Response.Redirect(sURL_return, true); }
private void Page_Load(object sender, System.EventArgs e) { try { if(Request.QueryString["id"] == null) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { EquipId=Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } string [,] arrBrdCrumbs = new string [3,2]; arrBrdCrumbs[0,0]="main.aspx"; arrBrdCrumbs[0,1]="Home"; arrBrdCrumbs[1,0]="list.aspx"; arrBrdCrumbs[1,1]="Equipment List"; arrBrdCrumbs[2,0]="view.aspx?id="+EquipId+""; arrBrdCrumbs[2,1]="Equipment Detail"; PageTitle = "Equipment-Edit Main"; Header.BrdCrumbs=ParseBreadCrumbs(arrBrdCrumbs,PageTitle); Header.PageTitle=PageTitle; SaveCancelControl.ParentPageURL= ParentPageURL; SourcePageName = "edit.aspx.cs"; if(!IsPostBack) { equip = new clsEquipment(); loc = new clsLocations(); dep = new clsDepartments(); equip.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); equip.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); equip.iId = EquipId; equip.cAction = "S"; dep.iOrgId = _functions.GetUserOrgId(Context.User.Identity.Name, false); ddlDepts.DataValueField = "Id"; ddlDepts.DataTextField = "vchName"; ddlDepts.DataSource = new DataView(dep.GetDepartmentsList()); ddlDepts.DataBind(); loc.iOrgId = _functions.GetUserOrgId(Context.User.Identity.Name, false); ddlLocs.DataValueField = "Id"; ddlLocs.DataTextField = "vchName"; ddlLocs.DataSource = new DataView(loc.GetLocationsList()); ddlLocs.DataBind(); // showing a Equipment's main data from fixed fields if(equip.EquipmentDetail() == -1) { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } ViewState["EquipType"] = equip.iTypeId.Value; if(equip.sAssignedTo.IsNull) lblAssignedTo.Text = ""; else lblAssignedTo.Text = equip.sAssignedTo.Value; if(equip.sEquipId.IsNull) tbEquipId.Text = ""; else tbEquipId.Text = equip.sEquipId.Value; if(equip.iYear.IsNull) tbYear.Text = ""; else tbYear.Text = equip.iYear.Value.ToString(); if(equip.sVinSerial.IsNull) tbVinSerial.Text = ""; else tbVinSerial.Text = equip.sVinSerial.Value; if(equip.sFuelCode.IsNull) tbFuelCode.Text = ""; else tbFuelCode.Text = equip.sFuelCode.Value; if(equip.sPlateNumber.IsNull) tbPlateNumber.Text = ""; else tbPlateNumber.Text = equip.sPlateNumber.Value; if(equip.bShare.IsNull) chShare.Checked = false; else chShare.Checked = equip.bShare.Value; if(equip.iModelId.IsNull) { mmValue.IsComponent = false; mmValue.TypeId = equip.iTypeId.Value; mmValue.DataBind(); } else { mmValue.IsComponent = false; mmValue.TypeId = equip.iTypeId.Value; mmValue.ModelId = equip.iModelId.Value; mmValue.DataBind(); } if(!equip.iDeptId.IsNull) ddlDepts.SelectedValue = equip.iDeptId.Value.ToString(); if(!equip.iLocId.IsNull) ddlLocs.SelectedValue = equip.iLocId.Value.ToString(); } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = ParentPageURL; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(loc != null) { loc.Dispose(); } if(dep != null) { dep.Dispose(); } if(equip != null) { equip.Dispose(); } } }
private void Page_Load(object sender, System.EventArgs e) { try { if(Request.QueryString["id"] == null) { Session["lastpage"] = "main.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); EquipId = Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = "main.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } sCurrentPage = "manageIssues.aspx?id=" + EquipId.ToString(); if(!IsPostBack) { order = new clsWorkOrders(); order.iOrgId = OrgId; ddlCategory.DataSource = new DataView(order.GetCategoryList()); ddlCategory.DataBind(); ddlCategory.Items.Insert(0, ""); equip = new clsEquipment(); equip.cAction = "S"; equip.iId = EquipId; equip.iOrgId = OrgId; if(equip.EquipmentDetail() == -1) { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } lblEquipId.Text = equip.sEquipId.Value; lblMakeModel.Text = equip.sMakeModelName.Value; lblOperator.Text = equip.sEquipOperator.Value; lblType.Text = equip.sType.Value; lblYear.Text = equip.iYear.Value.ToString(); if(!equip.dmCurrentUnits.IsNull) lblUnits.Text = Convert.ToDouble(equip.dmCurrentUnits.Value).ToString(); hlCreateOrder.NavigateUrl = "wo_existingWorkOrders.aspx?id=" + EquipId.ToString(); ShowIssues(); } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = ParentPageURL; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(order != null) order.Dispose(); if(equip != null) equip.Dispose(); } }
private void Page_Load(object sender, System.EventArgs e) { clsCustomFieldsDef cfd = null; int j; try { if(Request.QueryString["id"] == null) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { EquipId=Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = "list.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } PageTitle = "Equipment Detail"; string [,] arrBrdCrumbs = new string [2,2]; arrBrdCrumbs[0,0]="main.aspx"; arrBrdCrumbs[0,1]="Home"; arrBrdCrumbs[1,0]="list.aspx"; arrBrdCrumbs[1,1]="Equipment List"; PageTitle = "Equipment Detail"; Header.BrdCrumbs=ParseBreadCrumbs(arrBrdCrumbs,PageTitle); Header.PageTitle=PageTitle; if(!IsPostBack) { Session["EquipId"] = EquipId; equip = new clsEquipment(); comp = new clsComponents(); dtCustomFields = new DataTable(); dtCustomFields.Columns.Add("ValueName"); dtCustomFields.Columns.Add("Value"); equip.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); equip.iId = EquipId; equip.cAction = "S"; // getting a fixed fields in the label controls if(equip.EquipmentDetail() == -1) { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); } // showing a Equipment's data from fixed fields lbStatus.Text = equip.sStatus.Value; lbPMSched.Text = equip.sPMSched.Value; lbInspection.Text = equip.sInspect.Value; if(!equip.iCurrentUnits.IsNull) lbUnits.Text = equip.iCurrentUnits.Value.ToString(); if(!equip.daInService.IsNull) lbDtInService.Text = equip.daInService.Value.ToShortDateString(); if(!equip.daAquired.IsNull) lbDtAquired.Text = equip.daAquired.Value.ToShortDateString(); lbVchPurOrgContact.Text = equip.sPurOrgContact.Value; if(!equip.curPurAmount.IsNull) lbSmPurAmount.Text = equip.curPurAmount.Value.ToString(); if(!equip.iPurUnits.IsNull) lbIntPurUnits.Text = equip.iPurUnits.Value.ToString(); lbVchPurNotes.Text = equip.sPurNotes.Value; if(!equip.daOutOfService.IsNull) lbDtOutOfService.Text = equip.daOutOfService.Value.ToShortDateString(); if(!equip.daDisposed.IsNull) lbDtDisposed.Text = equip.daDisposed.Value.ToShortDateString(); if(!equip.sDispMethod.IsNull) lbVchDispMethod.Text = equip.sDispMethod.Value; if(!equip.sDispOrgContact.IsNull) lbVchDispOrgContact.Text = equip.sDispOrgContact.Value; if(!equip.curDispAmount.IsNull) lbSmDispAmount.Text = equip.curDispAmount.Value.ToString(); if(!equip.iDispUnits.IsNull) lbIntDispUnits.Text = equip.iDispUnits.Value.ToString(); lbVchDispNotes.Text = equip.sDispNotes.Value; // getting all component's types to dropdownlist comp.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); ddlComponentTypes.DataTextField = "vchName"; ddlComponentTypes.DataValueField = "Id"; ddlComponentTypes.DataSource = new DataView(comp.GetComponentTypeList()); ddlComponentTypes.DataBind(); // getting the fixed fields in the DataList control dtCustomFieldsFromDB = equip.EquipmentDetail_CustomFields(null); dtCustomFields.Rows.Add(new object []{"Type", dtCustomFieldsFromDB.Rows[0]["TypeName"]}); // getting the custom fields in the DataList control //arrCFD = _functions.CustomFieldsParse(dtCustomFieldsFromDB, Convert.ToInt32(Session["EquipTypeId"])); arrCFD = _functions.GetCustomFields(false, Convert.ToInt32(Session["EquipTypeId"]), HttpContext.Current.User.Identity.Name); if(arrCFD.Count > 0) { // fill custom fields for(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": 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}); break; case "Departments": 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}); } break; case "Locations": 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}); } break; default: break; } break; case DBFieldType._datetime: dtCustomFields.Rows.Add(new object []{cfd.NameText, ((DateTime)dtCustomFieldsFromDB.Rows[0][sTypeName]).ToShortDateString()}); break; case DBFieldType._bit: 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: 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(); comp.iEquipId = EquipId; comp.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); dtComponents = comp.GetComponentsList(); ViewState["Components"] = dtComponents; repComponents.DataSource = new DataView(dtComponents); repComponents.DataBind(); } else { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); } } } catch(Exception ex) { _functions.Log("Application error: \n" + ex.ToString()); Session["lastpage"] = ParentPageURL; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(comp != null) { comp.Dispose(); } if(loc != null) { loc.Dispose(); } if(dep != null) { dep.Dispose(); } if(mm != null) { mm.Dispose(); } if(comp != null) { comp.Dispose(); } if(equip != null) { equip.Dispose(); } } }