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