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) { 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"] = "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(); } } }