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(); } } }
/// <summary> /// Activating/Inactivating the user account /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btSave_FormSubmit(object sender, EventArgs e) { try { equip = new clsEquipment(); equip.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); foreach (RepeaterItem _item in repOperatorEquipments.Items) { DropDownList ddlOperators = (DropDownList)_item.FindControl("ddlOperators"); bool IsNobody = Convert.ToBoolean(ddlOperators.Attributes["IsNobody"]); if (!IsNobody && ddlOperators.SelectedValue == "0") { Header.ErrorMessage = "Operator is required"; return; } equip.iOrgId = OrgId; equip.iId = Convert.ToInt32(ddlOperators.Attributes["EquipId"]); equip.iEquipOperatorId = Convert.ToInt32(ddlOperators.SelectedValue); equip.sNote = "Deactivated Operator - Reassigned New Operator"; equip.EquipAssignedTo(); } user = new clsUsers(); user.iOrgId = OrgId; user.daCreated = DateTime.Now; user.iLoginId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); foreach (RepeaterItem _item in repWorkOrders.Items) { DropDownList ddlTechs = (DropDownList)_item.FindControl("ddlTechs"); bool IsNobody = Convert.ToBoolean(ddlTechs.Attributes["IsNobody"]); if (!IsNobody && ddlTechs.SelectedValue == "0") { Header.ErrorMessage = "Technician is required"; return; } user.iOrderId = Convert.ToInt32(ddlTechs.Attributes["OrderId"]); user.iId = Convert.ToInt32(ddlTechs.SelectedValue); user.SetNewTechToWorkOrder(); } user = new clsUsers(); user.iOrgId = OrgId; user.iId = UserId; user.bActiveStatus = (bool)ViewState["Active"]; if (user.UserActive() == -1) { Session["lastpage"] = "admin_user_detail_active.aspx?id=" + UserId.ToString(); Session["error"] = _functions.ErrorMessage(134); Response.Redirect("error.aspx", false); return; } if (UserId == _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true)) { Response.Redirect("default.aspx", false); } else { // redirect to the finish screen BackFinishScreen finish = new BackFinishScreen(); if (((bool)ViewState["Active"])) { finish.sMainText = "The user has been activated successfully"; } else { finish.sMainText = "The user has been deactivated successfully"; } finish.bMainMenuVisible = true; finish.sMainMenuText = "[Return to Main Menu]"; finish.sMainMenuURL = "selectMode.aspx"; finish.bContinueVisible = false; finish.bViewVisible = true; finish.sViewText = "[View the User Detail]"; finish.sViewURL = "admin_user_detail.aspx?id=" + UserId.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"] = "admin_user_detail_active.aspx?id=" + UserId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if (user != null) { user.Dispose(); } if (equip != null) { equip.Dispose(); } } }
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 { 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; SourcePageName = "edit2.aspx.cs"; 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); ddPMScheduleId.DataTextField = "vchName"; ddPMScheduleId.DataValueField = "Id"; ddPMScheduleId.DataSource = new DataView(pm.GetPMSchedulesList()); ddPMScheduleId.DataBind(); ddPMScheduleId.Items.Insert(0, new ListItem("", "")); ddInspectionId.DataTextField = "vchName"; ddInspectionId.DataValueField = "Id"; ddInspectionId.DataSource = new DataView(inspec.GetInspectionsList()); ddInspectionId.DataBind(); ddInspectionId.Items.Insert(0, new ListItem("", "")); // getting equipment's data if (equip.EquipmentDetail_Alt() != -1) { if (equip.iPMSched.IsNull) { ddPMScheduleId.SelectedValue = ""; } else { ddPMScheduleId.SelectedValue = Convert.ToString(equip.iPMSched); } if (equip.iInspectId.IsNull) { ddInspectionId.SelectedValue = ""; } else { ddInspectionId.SelectedValue = Convert.ToString(equip.iInspectId); } if (equip.iCurrentUnits.IsNull) { tbCurrentUnits.Text = ""; } else { 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(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 (inspec != null) { inspec.Dispose(); } if (pm != null) { pm.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(); } } }
private void Page_Load(object sender, System.EventArgs e) { try { 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 = "Add Equipment"; 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); dtEquipTypes = equip.GetEquipTypesList(); if (dtEquipTypes.Rows.Count > 0) { ddlEquipType.DataSource = new DataView(dtEquipTypes); ddlEquipType.DataBind(); if (Session["EquipTypeId"] != null) { ddlEquipType.SelectedValue = Convert.ToString(Session["EquipTypeId"]); } else { ddlEquipType.SelectedIndex = 0; Session["EquipTypeId"] = ddlEquipType.SelectedValue; } equip.iTypeId = Convert.ToInt32(ddlEquipType.SelectedValue); GenerateCustomFields(); } else { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(101); 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 (loc != null) { loc.Dispose(); } if (dep != null) { dep.Dispose(); } if (mm != null) { mm.Dispose(); } if (equip != null) { equip.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_viewIssues.aspx?id=" + OrderId.ToString(); } NextBackControl.BackText = "<< Back"; NextBackControl.BackPage = m_sBack; NextBackControl.NextText = " Yes "; NextBackControl.sCSSClass = "ok_input_button"; op = new OperatorInfo(Request.Cookies["bfp_operator"].Value); if (!IsPostBack) { lblFirstName1.Text = op.FirstName; equip = new clsEquipment(); equip.iOrgId = OrgId; equip.iOrderId = OrderId; if (equip.GetSpareEquip() == 0) { lblEquipId.Text = equip.sEquipId.Value; lblEquipType.Text = equip.sType.Value; } else { Response.Redirect("ok_viewNotes.aspx?id=" + OrderId.ToString(), false); } } } 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 (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"] = "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()); NextBackControl.BackPage = ParentPageURL; NextBackControl.BackVisible = true; NextBackControl.CausesValidation = true; if (!IsPostBack) { order = new clsWorkOrders(); user = new clsUsers(); order.cAction = "S"; order.iOrgId = OrgId; order.iId = OrderId; user.iOrgId = OrgId; user.iTypeId = (int)UserTypes.Technician; ddlTech.DataSource = new DataView(user.GetUserListByType()); ddlTech.DataBind(); if (order.WorkOrderDetails() == -1) { Session["lastpage"] = this.ParentPageURL; Session["error"] = _functions.ErrorMessage(120); Response.Redirect("error.aspx", false); return; } if (!user.IsTechnician(_functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true))) { Session["lastpage"] = this.ParentPageURL; Session["error"] = _functions.ErrorMessage(131); Response.Redirect("error.aspx", false); return; } lblWorkOrderId.Text = order.daCreated.Value.ToString("yyyy-MM-dd") + "-" + order.iWorkOrderNumber.Value.ToString(); hlEquipId.Text = order.sEquipId.Value; hlEquipId.NavigateUrl = "e_view.aspx?id=" + order.iEquipId.Value.ToString(); hlSpareEquipId.Text = order.sSpareEquipId.Value; if (order.iSpareEquipId.Value > 0) { hlSpareEquipId.NavigateUrl = "e_view.aspx?id=" + order.iSpareEquipId.Value.ToString(); } lblOperator.Text = order.sOperatorName.Value; lblScheduledDate.Text = order.daScheduled.Value.ToLongDateString() + " " + order.daScheduled.Value.ToLongTimeString(); if (order.bStaying.Value) { lblStaying.Text = "Yes"; } else { lblStaying.Text = "No"; } if (ddlTech.Items.FindByValue(order.iTechId.Value.ToString()) != null) { ddlTech.SelectedValue = order.iTechId.Value.ToString(); } else { ddlTech.SelectedIndex = 0; } tbDroppedOffBy.Text = order.sDropedOffBy.Value; if (order.iStatusId.Value == (int)WorkOrderStatus.Scheduled && order.iOperatorStatusId.Value == (int)WorkOrderOperatorStatus.Checked_In) { lblArrivalDate.Text = order.daArrival.IsNull?"":order.daArrival.Value.ToLongDateString(); } else { NextBackControl.NextEnabled = false; tbMileage.Enabled = false; ddlTech.Enabled = false; tbDroppedOffBy.Enabled = false; tbNotes.Enabled = false; Header.ErrorMessage = _functions.ErrorMessage(137); } if (order.daOpened.IsNull) { adtOpened.Date = DateTime.Now; } else { adtOpened.Date = order.daOpened.Value; } equip = new clsEquipment(); equip.iOrgId = OrgId; equip.iId = order.iEquipId; if (equip.GetEquipInfo() == -1) { Session["lastpage"] = this.ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } tbMileage.Text = equip.dmCurrentUnits.Value.ToString("F"); valRangeUnits.MinimumValue = equip.dmCurrentUnits.Value.ToString(); valRangeUnits.ErrorMessage = "Value must be greater than was " + equip.dmCurrentUnits.Value.ToString("F") + "<br>"; lblMeasure.Text = equip.sMeasure.Value; order.iNoteId = 0; order.iNoteTypeId = (int)NoteTypes.CreationNote; order.iItemId = OrderId; if (order.NoteDetails() != -1) { lblClerkNote.Text = order.sNote.Value; } ShowCustomFields(); } } 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 (user != null) { user.Dispose(); } if (order != null) { order.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); 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) { int j; string sTypeName; 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 = "Edit Custom Information of Equipment"; this.PageTitle = "Edit Custom Fields"; SaveCancelControl.ParentPageURL = this.ParentPageURL; if (!IsPostBack) { equip = new clsEquipment(); dtCustomFields = new DataTable(); #region Creating Column dtCustomFields.Columns.Add("TypeName"); dtCustomFields.Columns.Add("ValueName"); dtCustomFields.Columns.Add("Value_String"); dtCustomFields.Columns.Add("Value_Boolean"); dtCustomFields.Columns.Add("Value_Int"); dtCustomFields.Columns.Add("Value_DateTime"); dtCustomFields.Columns.Add("TB_Visible"); dtCustomFields.Columns.Add("DDL_Visible"); dtCustomFields.Columns.Add("CB_Visible"); dtCustomFields.Columns.Add("MM_Visible"); dtCustomFields.Columns.Add("DT_Visible"); dtCustomFields.Columns.Add("Help"); dtCustomFields.Columns.Add("RFV_Visible"); dtCustomFields.Columns.Add("Val_Visible"); dtCustomFields.Columns.Add("ErrorMessage"); dtCustomFields.Columns.Add("Exp"); #endregion equip.iOrgId = OrgId; equip.iId = EquipId; equip.cAction = "S"; dtCustomFieldsFromDB = equip.EquipmentDetail_CustomFields(null); if (equip.iId == -1) { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } #region Show Custom Fields if (dtCustomFieldsFromDB.Rows.Count > 0) { // adding data into DropDownList controls // parsing the custom fields in the dtCustomFieldsFromDB table arrCFD = _functions.GetCustomFields(CFDataType.Equipment, Convert.ToInt32(dtCustomFieldsFromDB.Rows[0]["TypeId"]), HttpContext.Current.User.Identity.Name); ViewState["EquipTypeId"] = dtCustomFieldsFromDB.Rows[0]["TypeId"]; if (arrCFD == null) { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(114); Response.Redirect("error.aspx", false); return; } // filling custom fields in the dtCustomFields table for (j = 0; j < arrCFD.Count; j++) { cfd = (clsCustomFieldsDef)arrCFD[j]; sTypeName = _functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString(); switch (cfd.FieldTypeId) { case DBFieldType._nvarchar: if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value) { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, "", "False", 0, "2000-01-01", "True", "False", "False", "False", "False", cfd.Help, cfd.Required.ToString(), "False", "", "" }); } else { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, dtCustomFieldsFromDB.Rows[0][sTypeName], "False", 0, "2000-01-01", "True", "False", "False", "False", "False", cfd.Help, cfd.Required.ToString(), "False", "", "" }); } break; case DBFieldType._int: if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value) { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, "", "False", 0, "2000-01-01", "True", "False", "False", "False", "False", cfd.Help, cfd.Required.ToString(), "True", cfd.NameText + " must be numeric", "^\\d{0,10}?$" }); } else { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, dtCustomFieldsFromDB.Rows[0][sTypeName], "False", 0, "2000-01-01", "True", "False", "False", "False", "False", cfd.Help, cfd.Required.ToString(), "True", cfd.NameText + " must be numeric", "^\\d{0,10}?$" }); } break; case DBFieldType._float: if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value) { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, "", "False", 0, "2000-01-01", "True", "False", "False", "False", "False", cfd.Help, cfd.Required.ToString(), "True", cfd.NameText + " must be decimal numeric", "^\\d{0,8}(?:\\.\\d{0,8})?$" }); } else { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, dtCustomFieldsFromDB.Rows[0][sTypeName], "False", 0, "2000-01-01", "True", "False", "False", "False", "False", cfd.Help, cfd.Required.ToString(), "True", cfd.NameText + " must be decimal numeric", "^\\d{0,8}(?:\\.\\d{0,8})?$" }); } break; case DBFieldType._datetime: if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value) { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, "", "False", 0, "1970-01-01", "False", "False", "False", "False", "True", cfd.Help, "False", "False", "", "" }); } else { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, "", "False", 0, dtCustomFieldsFromDB.Rows[0][sTypeName], "False", "False", "False", "False", "True", cfd.Help, "False", "False", "", "" }); } break; case DBFieldType._bit: if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value) { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, "", "False", 0, "2000-01-01", "False", "False", "True", "False", "False", cfd.Help, "False", "False", "", "" }); } else { if (((bool)dtCustomFieldsFromDB.Rows[0][sTypeName]) == true) { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, "", "True", 0, "2000-01-01", "False", "False", "True", "False", "False", cfd.Help, "False", "False", "", "" }); } else { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, "", "False", 0, "2000-01-01", "False", "False", "True", "False", "False", cfd.Help, "False", "False", "", "" }); } } break; case DBFieldType._ntext: if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value) { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, "", "2000-01-01", 0, "2000-01-01", "True", "False", "False", "False", "False", cfd.Help, cfd.Required.ToString(), "False", "", "" }); } else { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, (string)dtCustomFieldsFromDB.Rows[0][sTypeName], "2000-01-01", 0, "2000-01-01", "True", "False", "False", "False", "False", cfd.Help, cfd.Required.ToString(), "False", "", "" }); } break; case DBFieldType._sql_variant: if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value) { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, "", "2000-01-01", 0, "2000-01-01", "True", "False", "False", "False", "False", cfd.Help, cfd.Required.ToString(), "False", "", "" }); } else { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, (string)dtCustomFieldsFromDB.Rows[0][sTypeName], "2000-01-01", 0, "2000-01-01", "True", "False", "False", "False", "False", cfd.Help, cfd.Required.ToString(), "False", "", "" }); } break; case DBFieldType._lookup: if (cfd.NameLookupTable == "EquipModels") { // adding data into DropDownList controls both Make and Model if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value) { dtCustomFields.Rows.Add(new object [] { sTypeName, "Make/Model", "", "False", 0, "2000-01-01", "False", "False", "False", "True", "False", cfd.Help, "False", "False", "", "" }); } else { dtCustomFields.Rows.Add(new object [] { sTypeName, "Make/Model", "", "False", Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]), "2000-01-01", "False", "False", "False", "True", "False", cfd.Help, "False", "False", "", "" }); } } else { if (dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value) { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, 0, "False", 0, "2000-01-01", "False", "True", "False", "False", "False", cfd.Help, "False", "False", "", "" }); } else { dtCustomFields.Rows.Add(new object [] { sTypeName, cfd.NameText, dtCustomFieldsFromDB.Rows[0][sTypeName], "False", 0, "2000-01-01", "False", "True", "False", "False", "False", cfd.Help, "False", "False", "", "" }); } } break; default: break; } cfd = null; } // binding main datalist ViewState["CustomFields"] = dtCustomFields; repCustomFields.DataSource = new DataView(dtCustomFields); repCustomFields.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"] = 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 (mm != null) { mm.Dispose(); } if (equip != null) { equip.Dispose(); } } }
private void Page_Load(object sender, System.EventArgs e) { int UserId; try { OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); if (!IsPostBack) { equip = new clsEquipment(); loc = new clsLocations(); dep = new clsDepartments(); user = new clsUsers(); equip.iOrgId = OrgId; ddlEquipTypes.DataSource = new DataView(equip.GetEquipTypesList()); ddlEquipTypes.DataBind(); ddlEquipTypes.Items.Insert(0, new ListItem("All", "0")); dep.iOrgId = OrgId; ddlDepartments.DataSource = new DataView(dep.GetDepartmentsList()); ddlDepartments.DataBind(); ddlDepartments.Items.Insert(0, new ListItem("All", "0")); loc.iOrgId = OrgId; ddlLocations.DataSource = new DataView(loc.GetLocationsList()); ddlLocations.DataBind(); ddlLocations.Items.Insert(0, new ListItem("All", "0")); user.iOrgId = OrgId; user.iTypeId = (int)UserTypes.Operator; ddlDrivers.DataSource = new DataView(user.GetUserListByType()); ddlDrivers.DataBind(); ddlDrivers.Items[0].Text = "All"; if (Session["EquipFilter"] == null) { UserId = _functions.GetUserOrgId(Context.User.Identity.Name, true); // if(ddlDrivers.Items.FindByValue(UserId.ToString()) != null) // ddlDrivers.SelectedValue = UserId.ToString(); equip.iTypeId = Convert.ToInt32(ddlEquipTypes.SelectedValue); equip.iDeptId = Convert.ToInt32(ddlDepartments.SelectedValue); equip.iLocId = Convert.ToInt32(ddlLocations.SelectedValue); equip.iUserId = Convert.ToInt32(ddlDrivers.SelectedValue); equip.iIsSpare = Convert.ToInt32(ddlSpare.SelectedValue); equip.sEquipId_Filter = _functions.ConvertToSQLFilter(tbEquipId.Text); eFilter = new EquipFilter(); eFilter.iTypeId = equip.iTypeId.Value; eFilter.iDeptId = equip.iDeptId.Value; eFilter.iLocId = equip.iLocId.Value; eFilter.iIsSpare = equip.iIsSpare.Value; eFilter.iOperatorId = equip.iUserId.Value; eFilter.sEquipId = equip.sEquipId_Filter.Value; Session["EquipFilter"] = eFilter; } else { eFilter = (EquipFilter)Session["EquipFilter"]; ddlEquipTypes.Items.FindByValue(eFilter.iTypeId.ToString()).Selected = true; ddlSpare.Items.FindByValue(eFilter.iIsSpare.ToString()).Selected = true; ddlDepartments.Items.FindByValue(eFilter.iDeptId.ToString()).Selected = true; ddlLocations.Items.FindByValue(eFilter.iLocId.ToString()).Selected = true; ddlDrivers.Items.FindByValue(eFilter.iOperatorId.ToString()).Selected = true; tbEquipId.Text = _functions.ConvertFromSQLFilter(eFilter.sEquipId); equip.iTypeId = eFilter.iTypeId; equip.iDeptId = eFilter.iDeptId; equip.iLocId = eFilter.iLocId; equip.iIsSpare = eFilter.iIsSpare; equip.iUserId = eFilter.iOperatorId; equip.sEquipId_Filter = eFilter.sEquipId; } ShowList(); } } 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 (equip != null) { equip.Dispose(); } if (loc != null) { loc.Dispose(); } if (dep != null) { dep.Dispose(); } if (user != null) { user.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; } PageTitle = "Reassign Equipment"; 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"; Header.BrdCrumbs = ParseBreadCrumbs(arrBrdCrumbs, PageTitle); Header.PageTitle = "Reassign Equipment"; SaveCancelControl.ParentPageURL = ParentPageURL; if (!IsPostBack) { ViewState["EquipId"] = EquipId; equip = new clsEquipment(); 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"; 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, ""); // getting equipment's data dtCustomFieldsFromDB = equip.EquipmentDetail_CustomFields(null); if (dtCustomFieldsFromDB.Rows.Count > 0) { if (dtCustomFieldsFromDB.Rows[0]["UserName"] == DBNull.Value) { lbAssignFrom.Text = ""; } else { lbAssignFrom.Text = dtCustomFieldsFromDB.Rows[0]["UserName"].ToString(); } dtCustomFields.Rows.Add(new object [] { "Type", dtCustomFieldsFromDB.Rows[0]["TypeName"] }); // getting the custom fields in the DataList control arrCFD = _functions.GetCustomFields(false, Convert.ToInt32(Session["EquipTypeId"]), HttpContext.Current.User.Identity.Name); if (arrCFD.Count > 0) { // fill custom fields for (int j = 0; j < arrCFD.Count; j++) { cfd = (clsCustomFieldsDef)arrCFD[j]; if (cfd.FieldTypeId == DBFieldType._lookup) { switch (cfd.NameLookupTable) { case "EquipModels": mm = new clsMakesModels(); mm.iOrgId = 1; // later change mm.iModelId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][_functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString()]); mm.GetModelMakes(); dtCustomFields.Rows.Add(new object [] { "Make/Model", mm.sMakeName + "/" + mm.sModelName }); break; case "Departments": dep = new clsDepartments(); dep.cAction = "S"; dep.iOrgId = 1; dep.iId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][_functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString()]); 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 = 1; loc.iId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][_functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString()]); if (loc.LocationDetail() == 0) { dtCustomFields.Rows.Add(new object [] { cfd.NameText, loc.sName.Value }); } break; default: break; } } else { dtCustomFields.Rows.Add(new object [] { cfd.NameText, dtCustomFieldsFromDB.Rows[0][_functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString()] }); } cfd = null; } repCustomFields.DataSource = new DataView(dtCustomFields); repCustomFields.DataBind(); } else { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); } } 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 (loc != null) { loc.Dispose(); } if (dep != null) { dep.Dispose(); } if (mm != null) { mm.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"] = "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 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) { try { if ((Request.QueryString["equipid"] == null) && (Request.QueryString["orderid"] == null)) { Session["lastpage"] = "ok_mainMenu.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { OrderId = Convert.ToInt32(Request.QueryString["orderid"]); EquipId = Convert.ToInt32(Request.QueryString["equipid"]); } catch (FormatException fex) { Session["lastpage"] = "ok_mainMenu.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); NextBackControl.BackText = "<< Back"; NextBackControl.BackPage = "ok_editNote.aspx?orderid=" + OrderId.ToString() + "&equipid=" + EquipId.ToString(); NextBackControl.NextText = " Finish "; NextBackControl.sCSSClass = "ok_input_button"; op = new OperatorInfo(Request.Cookies["bfp_operator"].Value); if (!IsPostBack) { lblFirstName.Text = op.FirstName; equip = new clsEquipment(); equip.iOrgId = OrgId; equip.iId = EquipId; if (equip.GetEquipInfo() != -1) { lblEquipId.Text = equip.sEquipId.Value; lblEquipType.Text = equip.sType.Value; } else { Session["lastpage"] = "ok_editNote.aspx?orderid=" + OrderId.ToString() + "&equipid=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); return; } order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; repInstructions.DataSource = new DataView(order.GetInstructionByCheckIn()); repInstructions.DataBind(); if (order.bPrint.Value) { hlPrint.Visible = true; string Url = Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.LastIndexOf("/")).Replace("/", "%2f"); Url = Url.Replace(":", "%3a"); hlPrint.Attributes.Add("onclick", "javascript:window.open('ReportViewer.aspx?Report=" + _functions.GetValueFromConfig("SQLRS.Folder") + "%2fCheckInReceipt&OrderId=" + OrderId.ToString() + "&OrgId=" + OrgId.ToString() + "&URL=" + Url + "', 'popupcal', 'toolbars=0');"); } else { hlPrint.Visible = false; } } } catch (Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "ok_editNote.aspx?orderid=" + OrderId.ToString() + "&equipid=" + EquipId.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 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 btSave_FormSubmit(object sender, EventArgs e) { DBFieldType FieldType; string sDataGridName; try { equip = new clsEquipment(); dtCustomFields = (DataTable)Session["CustomFields"]; 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(ddlEquipType.SelectedValue); equip.iStatusId = 1; sDataGridName = "repCustomFields"; // 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: if ((string)dtCustomFields.Rows[i]["ValueName"] != "Make/Model") { dtCustomFields.Rows[i]["Value_String"] = Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":ddlValue"]; } else { dtCustomFields.Rows[i]["Value_String"] = Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":mmValue:ddlModels"]; } break; default: dtCustomFields.Rows[i]["Value_String"] = Request.Form[sDataGridName + ":_ctl" + j.ToString() + ":tbValue"]; break; } } } } // saving data to database equip.EquipmentDetail_CustomFields(_functions.SetDataToParameters(dtCustomFields)); if (equip.iId > 0) { Response.Redirect("reassign.aspx?id=" + equip.iId.Value.ToString() + "", false); } else { Session["lastpage"] = "addEquip.aspx"; Session["error"] = _functions.ErrorMessage(103); Response.Redirect("error.aspx", false); } } catch (FormatException fex) { Session["lastpage"] = "addEquip.aspx"; Session["error"] = _functions.ErrorMessage(108); Response.Redirect("error.aspx", false); } catch (Exception ex) { _functions.Log("Application error: \n" + ex.ToString()); Session["lastpage"] = "addEquip.aspx"; 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; equip.cAction = "U"; equip.daDisposed = adtDisposed.Date; equip.daOutOfService = adtOutOfService.Date; equip.sDispOrgContact = tbOrgContact.Text; equip.curDispAmount = Convert.ToDecimal(tbAmount.Text); equip.iDispUnits = Convert.ToInt32(tbUnits.Text); equip.sDispNotes = tbNotes.Text; equip.iDispMethod = Convert.ToInt32(ddMethod.SelectedValue); if (equip.EquipmentDetail_Disp() != -1) { Response.Redirect("view.aspx?id=" + EquipId.ToString(), false); } else { Session["lastpage"] = "editDisp.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(107); Response.Redirect("error.aspx", false); } } catch (FormatException fex) { Session["lastpage"] = "editDisp.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(108); Response.Redirect("error.aspx", false); } catch (Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, "editDisp.aspx.cs"); Session["lastpage"] = "editDisp.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"] = "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 = "Edit Aquisition Information of Equipment"; SaveCancelControl.ParentPageURL = this.ParentPageURL; if (!IsPostBack) { equip = new clsEquipment(); equip.cAction = "S"; equip.iOrgId = OrgId; equip.iId = EquipId; // getting equipment's data if (equip.EquipmentDetail_Aquis() != -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.dmPurUnits.IsNull) { tbUnits.Text = ""; } else { tbUnits.Text = Convert.ToDouble(equip.dmPurUnits.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(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 (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 Disposal 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; ddMethod.DataTextField = "vchName"; ddMethod.DataValueField = "Id"; ddMethod.DataSource = new DataView(equip.GetEquipDispMethodsList()); ddMethod.DataBind(); // getting equipment's data if (equip.EquipmentDetail_Disp() != -1) { if (equip.daDisposed.IsNull) { adtDisposed.Date = new DateTime(adtDisposed.MinYear, 1, 1); } else { adtDisposed.Date = equip.daDisposed.Value; } if (equip.daOutOfService.IsNull) { adtOutOfService.Date = new DateTime(adtOutOfService.MinYear, 1, 1); } else { adtOutOfService.Date = equip.daOutOfService.Value; } if (equip.sDispOrgContact.IsNull) { tbOrgContact.Text = ""; } else { tbOrgContact.Text = equip.sDispOrgContact.Value; } if (equip.curDispAmount.IsNull) { tbAmount.Text = ""; } else { tbAmount.Text = equip.curDispAmount.Value.ToString("0.00"); } if (equip.iDispUnits.IsNull) { tbUnits.Text = ""; } else { tbUnits.Text = equip.iDispUnits.Value.ToString(); } if (equip.sDispNotes.IsNull) { tbNotes.Text = ""; } else { tbNotes.Text = equip.sDispNotes.Value; } if (equip.iDispMethod.IsNull) { ddMethod.SelectedIndex = 0; } else { ddMethod.SelectedValue = equip.iDispMethod.Value.ToString(); } } else { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(102); Response.Redirect("error.aspx", false); } } } catch (Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, "editDisp.aspx.cs"); 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 = "U"; equip.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); equip.iId = EquipId; equip.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); equip.iPMSched = Convert.ToInt32(ddPMScheduleId.SelectedValue); equip.iInspectId = Convert.ToInt32(ddInspectionId.SelectedValue); equip.iCurrentUnits = Convert.ToInt32(tbCurrentUnits.Text); if (equip.EquipmentDetail_Alt() == -1) { Session["lastpage"] = "edit2.aspx?id=" + EquipId.ToString(); Session["error"] = _functions.ErrorMessage(107); Response.Redirect("error.aspx", false); return; } else { Response.Redirect("view.aspx?id=" + EquipId.ToString(), 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(ex, HttpContext.Current.User.Identity.Name, SourcePageName); 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(); } } }
/// <summary> /// Adding a new equipment to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btSave_FormSubmit(object sender, EventArgs e) { try { equip = new clsEquipment(); equip.cAction = "U"; equip.iOrgId = OrgId; 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.bSpare = chSpare.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 = "e_reassign.aspx?id=" + EquipId.ToString(); } else { Session["lastpage"] = "e_addEquip.aspx"; Session["error"] = _functions.ErrorMessage(103); sURL_return = "error.aspx"; } equip.iId = EquipId; equip.iPMSched = Convert.ToInt32(ddPMScheduleId.SelectedValue); equip.iInspectScheduleId = Convert.ToInt32(ddInspectionId.SelectedValue); equip.dmCurrentUnits = Convert.ToDecimal(tbCurrentUnits.Text); if (equip.EquipmentDetail_Alt() == -1) { Session["lastpage"] = "e_addEquip.aspx"; Session["error"] = _functions.ErrorMessage(107); sURL_return = "error.aspx"; } } catch (FormatException fex) { Session["lastpage"] = "e_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"] = "e_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 Page_Load(object sender, System.EventArgs e) { try { if (Request.QueryString["id"] == null) { Session["lastpage"] = "ok_mainMenu.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); OrderId = Convert.ToInt32(Request.QueryString["id"]); } catch (FormatException fex) { Session["lastpage"] = "ok_mainMenu.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } op = new OperatorInfo(Request.Cookies["bfp_operator"].Value); if (!IsPostBack) { lblFirstName1.Text = lblFirstName2.Text = lblFirstName3.Text = op.FirstName; equip = new clsEquipment(); equip.iOrgId = OrgId; equip.iUserId = op.Id; dtEquipments = equip.GetEquipListForCheckOut(); if (dtEquipments.Rows.Count < 1) { // none equipments mode pnlNoneEquipment.Visible = true; } else if (dtEquipments.Rows.Count == 1) { // one equipment mode pnlOneEquipment.Visible = true; lblEquipId.Text = dtEquipments.Rows[0]["EquipId"].ToString(); lblEquipType.Text = dtEquipments.Rows[0]["TypeName"].ToString(); ViewState["SelectedWorkOrderId"] = dtEquipments.Rows[0]["Id"].ToString(); } else if (dtEquipments.Rows.Count > 1) { // manu equipments mode pnlManyEquipment.Visible = true; repEquipments.DataSource = new DataView(dtEquipments); repEquipments.DataBind(); } if (OrderId != 0) { pnlNoneEquipment.Visible = false; pnlManyEquipment.Visible = false; pnlOneEquipment.Visible = true; order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; if (order.GetEquipInfo() == -1) { Session["lastpage"] = "ok_authCredentials.aspx?op=CheckOut&orderid=" + OrderId.ToString(); Session["error"] = _functions.ErrorMessage(120); Response.Redirect("error.aspx", false); } else { lblEquipId.Text = order.sEquipId.Value; lblEquipType.Text = order.sEquipTypeName.Value; ViewState["SelectedWorkOrderId"] = OrderId.ToString(); } } } } catch (Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "ok_authCredentials.aspx?op=CheckOut&orderid=" + OrderId.ToString(); 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) { try { OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); SaveCancelControl.ParentPageURL = this.ParentPageURL; if (!IsPostBack) { loc = new clsLocations(); dep = new clsDepartments(); equip = new clsEquipment(); pm = new clsPMSchedService(); inspec = new clsInspections(); equip.iOrgId = OrgId; ddlTypes.DataValueField = "Id"; ddlTypes.DataTextField = "vchName"; ddlTypes.DataSource = new DataView(equip.GetEquipTypesList()); ddlTypes.DataBind(); 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(); mmValue.IsComponent = false; mmValue.TypeId = Convert.ToInt32(ddlTypes.SelectedValue); mmValue.DataBind(); pm.iOrgId = OrgId; inspec.iOrgId = OrgId; ddPMScheduleId.DataTextField = "vchName"; ddPMScheduleId.DataValueField = "Id"; ddPMScheduleId.DataSource = new DataView(pm.GetPMSchedulesList()); ddPMScheduleId.DataBind(); ddPMScheduleId.Items.Insert(0, new ListItem("", "")); ddInspectionId.DataTextField = "vchName"; ddInspectionId.DataValueField = "Id"; ddInspectionId.DataSource = new DataView(inspec.GetInspectSchedulesList()); ddInspectionId.DataBind(); ddInspectionId.Items.Insert(0, new ListItem("", "")); } } 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 (pm != null) { pm.Dispose(); } if (inspec != null) { inspec.Dispose(); } 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; } PageTitle = "Reassign Equipment"; 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"; Header.BrdCrumbs = ParseBreadCrumbs(arrBrdCrumbs, PageTitle); Header.PageTitle = "Reassign Equipment"; SaveCancelControl.ParentPageURL = ParentPageURL; SourcePageName = "reassign.aspx.cs"; if (!IsPostBack) { equip = new clsEquipment(); equip.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); 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, ""); // 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; lblShare.Text = equip.bShare.Value?"Yes":"No"; lbAssignFrom.Text = equip.sAssignedTo.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 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 { OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); if (Request.QueryString["id"] == null) { Session["lastpage"] = "admin_users.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { UserId = Convert.ToInt32(Request.QueryString["id"]); } catch (FormatException fex) { Session["lastpage"] = "admin_users.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } Header.AddBreadCrumb("Home", "/selectMode.aspx"); Header.AddBreadCrumb("Administration", "/admin.aspx"); Header.AddBreadCrumb("User Search", "/admin_users.aspx"); Header.AddBreadCrumb("User Detail", "/admin_user_detail.aspx?id=" + UserId.ToString()); Header.AddBreadCrumb("User Detail Edit", "/admin_user_detail_edit.aspx?id=" + UserId.ToString()); this.PageTitle = "User Detail Activate"; Header.LeftBarHtml = "User Activating/Deactivating"; SaveCancelControl.ParentPageURL = this.ParentPageURL; if (!IsPostBack) { user = new clsUsers(); user.cAction = "S"; user.iOrgId = OrgId; user.iId = UserId; if (user.UserDetails() == -1) { Session["lastpage"] = "admin_user_detail.aspx?id=" + UserId.ToString(); Session["error"] = _functions.ErrorMessage(134); Response.Redirect("error.aspx", false); return; } lblFirstName.Text = user.sFirstName.Value; lblLastName.Text = user.sLastName.Value; lblEmail.Text = user.sEmail.Value; lblType.Text = user.sTypeName.Value; lblCreatedDate.Text = user.daCreated.Value.ToLongDateString() + " " + user.daCreated.Value.ToLongTimeString(); if (user.bActiveStatus.Value) { ViewState["Active"] = false; lblUserActivateStatus.Text = "Activated"; SaveCancelControl.ButtonText = "Deactivate"; user.iTypeId = (int)UserTypes.Operator; dtOperators = user.GetUserListByType(); ViewState["Operators"] = dtOperators; user.iTypeId = (int)UserTypes.Technician; dtTechnicians = user.GetUserListByType(); ViewState["Technicians"] = dtTechnicians; equip = new clsEquipment(); equip.iOrgId = OrgId; equip.iUserId = UserId; DataTable dtEquipOrders = equip.GetEquipListByOperatorActivate(); if (dtEquipOrders.Rows.Count > 0) { repOperatorEquipments.DataSource = new DataView(dtEquipOrders); repOperatorEquipments.DataBind(); } else { tblMain.Rows[8].Visible = false; tblMain.Rows[9].Visible = false; tblMain.Rows[10].Visible = false; } DataTable dtTechOrders = equip.GetOrderListByTechnicianActivate(); if (dtTechOrders.Rows.Count > 0) { repWorkOrders.DataSource = new DataView(dtTechOrders); repWorkOrders.DataBind(); } else { tblMain.Rows[11].Visible = false; tblMain.Rows[12].Visible = false; tblMain.Rows[13].Visible = false; } } else { ViewState["Active"] = true; lblUserActivateStatus.Text = "Deactivated"; SaveCancelControl.ButtonText = "Activate"; tblMain.Rows[8].Visible = false; tblMain.Rows[9].Visible = false; tblMain.Rows[10].Visible = false; tblMain.Rows[11].Visible = false; tblMain.Rows[12].Visible = false; tblMain.Rows[13].Visible = false; } } } catch (Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "admin_user_detail_edit.aspx?id=" + UserId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if (user != null) { user.Dispose(); } if (equip != null) { equip.Dispose(); } } }
private void Page_Load(object sender, System.EventArgs e) { try { 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 = "Add Equipment"; Header.BrdCrumbs = ParseBreadCrumbs(arrBrdCrumbs, PageTitle); Header.PageTitle = PageTitle; SaveCancelControl.ParentPageURL = ParentPageURL; SourcePageName = "addEquip.aspx.cs"; if (!IsPostBack) { loc = new clsLocations(); dep = new clsDepartments(); equip = new clsEquipment(); equip.iOrgId = _functions.GetUserOrgId(Context.User.Identity.Name, false); ddlTypes.DataValueField = "Id"; ddlTypes.DataTextField = "vchName"; ddlTypes.DataSource = new DataView(equip.GetEquipTypesList()); ddlTypes.DataBind(); 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(); mmValue.IsComponent = false; mmValue.TypeId = Convert.ToInt32(ddlTypes.SelectedValue); mmValue.DataBind(); } } 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 dgMainList_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { try { if (e.CommandName == "Select") { SpareId = Convert.ToInt32(e.CommandArgument); equip = new clsEquipment(); equip.iOrgId = OrgId; equip.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); equip.iId = SpareId; equip.iOrderId = OrderId; equip.sNote = "checking out the spare equipment"; if (equip.EquipSpareTo(false) == -1) { Session["lastpage"] = m_sLastPage; Session["error"] = _functions.ErrorMessage(120); Response.Redirect("error.aspx", false); } else { if (ViewState["Operation"] == null) { switch (sBack) { case "open": Response.Redirect("wo_openWorkOrder.aspx?id=" + OrderId.ToString(), false); break; case "edit": Response.Redirect("wo_editWorkOrder.aspx?id=" + OrderId.ToString(), false); break; case "checkin": Response.Redirect("wo_viewCheckIn.aspx?id=" + OrderId.ToString(), false); break; default: Response.Redirect("wo_addRepairs.aspx?id=" + OrderId.ToString(), false); break; } } else { BackFinishScreen finish = new BackFinishScreen(); finish.sMainText = "The Roadside Repair Work Order 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?select=AddRoadside"; 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_selectSpareEquip.aspx?id=" + OrderId.ToString() + "&equipid=" + 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 Aquisition Info"; Header.BrdCrumbs = ParseBreadCrumbs(arrBrdCrumbs, PageTitle); Header.PageTitle = PageTitle; SaveCancelControl.ParentPageURL = ParentPageURL; SourcePageName = "editAquis.aspx.cs"; 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_Aquis() != -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(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 (equip != null) { equip.Dispose(); } } }