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();
}
}
}