/// <summary> /// Adding the user to groups /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddUser_Click(object sender, System.EventArgs e) { try { user = new clsUsers(); user.cAction = "I"; user.iId = Convert.ToInt32(ddlUsers.SelectedValue); user.iOrgId = OrgId; user.iGroupId = GroupId; if(user.UsersGroupsDetail() == -1) { Session["lastpage"] = "admin_groups_users.aspx?id=" + GroupId.ToString(); Session["error"] = _functions.ErrorMessage(117); Response.Redirect("error.aspx", false); return; } else Response.Redirect("admin_groups_users.aspx?id=" + GroupId.ToString(), false); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "admin_groups_users.aspx?id=" + GroupId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(user != null) user.Dispose(); } }
private void btnAddGroup_Click(object sender, System.EventArgs e) { try { user2 = new clsUsers(); user2.cAction = "U"; user2.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); user2.iGroupId = 0; user2.sGroupName = tbGroupName.Text; tbGroupName.Text = ""; if(user2.GroupDetails() == -1) { Session["lastpage"] = "admin_groups.aspx"; Session["error"] = _functions.ErrorMessage(117); Response.Redirect("error.aspx", false); return; } ShowGroups(); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "admin_groups.aspx"; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(user2 != null) user2.Dispose(); } }
private void btnSendReport_Click(object sender, System.EventArgs e) { string sText, sEmail, sSubj; clsUsers user = null; try { user = new clsUsers(); user.cAction = "S"; user.iId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); user.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); user.UserDetails(); sText = "The Error Report from " + user.sFirstName.Value + " " + user.sLastName.Value + " [" + user.sEmail.Value + "] at " + DateTime.Now.ToUniversalTime() + " GMT <br>"; sText += "Error Description:<br>"; sText += "-------------------------------------------------------------<br>"; sText += ViewState["error_report"].ToString(); sSubj = "The Error Report from FleetPro Application"; sEmail = _functions.GetValueFromConfig("Report.DevEmail"); _functions.SendEmail(sEmail, sSubj, sText); Response.Redirect(btnSendReport.CommandArgument, false); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, "error.aspx.cs"); } finally { if(user != null) { user.Dispose(); } } }
private void btNext_FormSubmit(object sender, EventArgs e) { try { user = new clsUsers(); user.iOrgId = OrgId; user.sLastName = tbLastName.Text; user.sPIN = tbPIN.Text; if(user.AuthOperator() != 0) { if(!user.bActiveStatus.Value) { lblError.Text = "<ul><li>" + _functions.ErrorMessage(202) + "</li></ul>"; } else { Response.Cookies["bfp_operator"].Value = (new OperatorInfo(user.iId.Value, user.sFirstName.Value)).ToString(); Response.Cookies["bfp_operator"].Path = "/"; Response.Cookies["bfp_operator"].Expires = DateTime.Now.AddYears(1); Response.Redirect("ok_mainDetails.aspx?id=" + OrderId.ToString() + "&back=authcredentials", false); } // switch(m_sOperation) // { // case "CheckIn": // Response.Redirect("ok_selectEquipment.aspx?orderid=" + OrderId.ToString(), false); // break; // case "CheckOut": // Response.Redirect("ok_selectWorkOrder.aspx?id=" + OrderId.ToString(), false); // break; // case "CheckOutSpare": // Response.Redirect("ok_selectSpareEquip.aspx?op=CheckOutSpare&orderid=" + OrderId.ToString() + "&equipid=" + EquipId.ToString(), false); // break; // case "AddIssue": // Response.Redirect("ok_addIssues.aspx?op=AddIssue&orderid=" + OrderId.ToString() + "&equipid=" + EquipId.ToString(), false); // break; // default: // Response.Redirect("ok_selectEquipment.aspx?orderid=" + OrderId.ToString(), false); // break; // } } else { lblError.Text = "<ul><li>The PIN code is incorrect</li></ul>"; } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "ok_authCredentials.aspx?orderid=" + OrderId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(user != null) user.Dispose(); } }
protected int OrgId; //Read from authentication ticket. #endregion Fields #region Methods /// <summary> /// Function is returning an access for input page. /// </summary> /// <param name="pageName">Input page</param> /// <returns>The access for input page, false - not permission, true - yes</returns> public bool CheckPermission(string pageName) { bool bResult = false; DataView dvPages = null; clsUsers user = null; try { if((pageName.ToLower() != "default.aspx") && (pageName.ToLower() != "error.aspx") && (pageName.ToLower() != "accessdenied.aspx")) { dvPages = (DataView)Context.Cache["userPages"]; if(dvPages == null) { user = new clsUsers(); user.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); dvPages = new DataView(user.GetPagesList()); Context.Cache.Insert("userPages", dvPages, null, DateTime.Now.AddHours(12), TimeSpan.Zero); } dvPages.RowFilter = "vchPageName = '" + pageName + "'"; if(dvPages.Count > 0) { foreach(string role in dvPages[0]["vchGroupList"].ToString().Split(new char[] {';'})) { if(Context.User.IsInRole(role)) { bResult = true; } } } else if(Context.User.IsInRole("Administrators")) bResult = true; } else { bResult = true; } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, "BFPPage.cs"); } finally { if(user != null) { user.Dispose(); } } return bResult; }
/// <summary> /// Showing found users /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnFilter_Click(object sender, System.EventArgs e) { try { user = new clsUsers(); user.iOrgId = OrgId; user.sFirstName = tbFirstName.Text; user.sLastName = tbLastName.Text; user.sEmail = tbEmail.Text; user.iTypeId = Convert.ToInt32(ddlUserTypes.SelectedValue); user.iActiveStatus = Convert.ToInt32(ddlActiveStatus.SelectedValue); user.iGroupId = Convert.ToInt32(ddlGroups.SelectedValue); uFilter = new UserFilter(); uFilter.sFirstName = user.sFirstName.Value; uFilter.sLastName = user.sLastName.Value; uFilter.sEmail = user.sEmail.Value; uFilter.iTypeId = user.iTypeId.Value; uFilter.iActiveStatus = user.iActiveStatus.Value; uFilter.iGroupId = user.iGroupId.Value; Session["UserFilter"] = uFilter; dgUserList.DataSource = new DataView(user.GetUserList_Filter()); dgUserList.DataBind(); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "admin_users.aspx"; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(user!=null) user.Dispose(); } }
/// <summary> /// The common procedure what will save filled Repair // and his used parts both Add mode and Edit mode. /// </summary> private void UpdateRepair(bool newRepair) { double Hours = 0.0; try { // if(tbNotes.Text.Length > 0) // { if (tbMinutes.Text.Length > 0 && Convert.ToDouble(tbMinutes.Text) >= 60) { Header.ErrorMessage = _functions.ErrorMessage(206); return; } if (tbHours.Text.Length > 0 || tbMinutes.Text.Length > 0) { if (tbHours.Text.Length > 0) Hours += Convert.ToDouble(tbHours.Text); if (tbMinutes.Text.Length > 0) Hours += Convert.ToDouble(tbMinutes.Text) / 60; } if (Hours >= 1000) { Header.ErrorMessage = _functions.ErrorMessage(203); return; } order = new clsWorkOrders(); order.iOrgId = OrgId; order.iId = OrderId; order.sTypeService = sType; order.iItemId = ItemId; if (ServiceResult == "Repair") order.iServiceResultId = (int)ServiceResults._Repaired; else order.iServiceResultId = (int)ServiceResults._Replaced; if (Mode) // Add mode { order.iRepairId = 0; } else // Edit mode order.iRepairId = RepairId; if (RepairId == 0 && newRepair) { order.iRepairId = preRepairId; order.iInsert = true; } order.sRepairDesc = tbNotes.Text; order.iRepairItemId = Convert.ToInt32(ddlRepairItems.SelectedValue); order.iRepairCatId = Convert.ToInt32(ddlRepairCats.SelectedValue); if (order.UpdateRepair() == -1) { Session["lastpage"] = sCurrentPage; Session["error"] = _functions.ErrorMessage(128); Response.Redirect("error.aspx", false); return; } RepairId = order.iRepairId.Value; // saving the parts for entered repair dtParts = (DataTable)ViewState["PartsUsed"]; foreach (DataRow item in dtParts.Rows) { if ((int)item["IsNew"] == 1) { order.cAction = "U"; order.iPartUsedId = 0; order.iPartUsedQty = (int)item["Qty"]; order.sPartUsedStock = (string)item["Stock"]; order.sPartUsedDesc = (string)item["Desc"]; order.dmPartUsedCost = (decimal)item["Cost"]; order.PartsUsedDetails(); } if ((int)item["IsDeleted"] == 1) { order.cAction = "D"; order.iPartUsedId = (int)item["Id"]; if (order.PartsUsedDetails() == -1) { Session["lastpage"] = sCurrentPage; Session["error"] = _functions.ErrorMessage(125); Response.Redirect("error.aspx", false); return; } } } if (Mode && html_chNewRepair.Checked && sType == "II") { order.iInspectItemId = ItemId; foreach (RepeaterItem item in repReportedIssues.Items) { CheckBox cbTmp = (CheckBox)item.FindControl("cbIssue"); if (cbTmp.Checked && cbTmp.Enabled) { order.iReportedIssueId = Convert.ToInt32(cbTmp.Attributes["CommandArgument"]); order.SetAssociationsIssue(); } } } if (Hours > 0.0) { user = new clsUsers(); user.iOrgId = OrgId; user.iOrderId = OrderId; if (user.GetTechnicianInfo() != -1) { order.cAction = "U"; order.iTimeLogId = 0; order.iTechId = user.iId; order.daStartTime = SqlDateTime.Null; order.daStopTime = SqlDateTime.Null; order.dmHours = Convert.ToDecimal(Hours); order.dmHourlyRate = user.dmHourlyRate; order.sNote = tbNotes.Text; order.TimeLogDetails(); } } // } // else // lblRequestor.Visible = true; } catch (FormatException fex) { Header.ErrorMessage = _functions.ErrorMessage(205); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { if (user != null) user.Dispose(); if (order != null) order.Dispose(); } }
private void Page_Load(object sender, System.EventArgs e) { try { OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); if (Request.QueryString["repairid"] != null && !string.IsNullOrEmpty(Request.QueryString["repairid"])) RepairId = Convert.ToInt32(Request.QueryString["repairid"]); if (Request.QueryString["mode"] == null || Request.QueryString["id"] == null || Request.QueryString["repairid"] == null) { Session["lastpage"] = "main.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { if (Request.QueryString["mode"] == "Add") Mode = true; else Mode = false; OrderId = Convert.ToInt32(Request.QueryString["id"]); if (Request.QueryString["inspectid"] != null) InspectId = Convert.ToInt32(Request.QueryString["inspectid"]); else InspectId = 0; if (Request.QueryString["itemid"] != null) ItemId = Convert.ToInt32(Request.QueryString["itemid"]); else ItemId = 0; if (Request.QueryString["type"] != null) sType = Request.QueryString["type"]; //RI, PMI, II, FREE else sType = ""; if (Request.QueryString["op"] != null) ServiceResult = Request.QueryString["op"]; //Repair, Replace else ServiceResult = ""; sCurrentPage = "wo_updateRepair.aspx?mode=" + (Mode ? "Add" : "Edit") + "&id=" + OrderId.ToString() + "&repairid=" + RepairId.ToString() + "&inspectid=" + InspectId.ToString() + "&itemid=" + ItemId.ToString() + "&type=" + sType + "&op=" + ServiceResult; } 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() + "&#Repairs"); if (sType == "II") // if came from Inspetion screen { Header.AddBreadCrumb("Inspection Detail", "/wo_viewCompleteInspection.aspx?id=" + OrderId.ToString() + "&inspectid=" + InspectId.ToString()); sLastPage = "wo_viewCompleteInspection.aspx?id=" + OrderId.ToString() + "&inspectid=" + InspectId.ToString(); } else sLastPage = "wo_viewWorkOrder.aspx?id=" + OrderId.ToString() + "&#Repairs"; if (Mode) this.PageTitle = "Update Repair"; else if (sType == "FREE") this.PageTitle = "Add Repair"; else this.PageTitle = "Edit Repair"; Header.AddJavaScriptFile("/wo_updateRepair.js"); Header.BodyOnloadScript = "javascript:CheckEditMode();"; SaveCancelControl.CausesValidation = false; SaveCancelControl.ButtonText = " Save & Back "; SaveCancelControl.IsCancel = false; ddlRepairCats.Attributes.Add("onchange", "javascript:ValidRepairItems();"); ddlRepairItems.Attributes.Add("onchange", "javascript:ValidRepairItems();"); clsWorkOrders orders = new clsWorkOrders(); string key = orders.GetIntegrationKey(this.OrgId); clsUsers user = new clsUsers(); user.cAction = "S"; user.iOrgId = OrgId; user.iId = _functions.GetUserOrgId(Context.User.Identity.Name, true); user.UserDetails(); if (RepairId == 0) { preRepairId = orders.GetRepairPreId(); preRepairId++; } if (string.IsNullOrEmpty(key)) WarehousePanel.Visible = false; else { string url = String.Format(_functions.GetValueFromConfig("WarehouseListnerPage") + "?action=create&key={0}&app=fleet&roid={1}&riid={2}&rufn={3}&ruln={4}&rue={5}&ron={6}&rofn={7}&shipto={8}&shiploc={9}", key, RepairId > 0 ? RepairId.ToString() : preRepairId.ToString(), string.Empty, user.sFirstName.Value, user.sLastName.Value, user.sEmail.Value, "Work Order", OrderId.ToString(), user.sFirstName.Value + " " + user.sLastName.Value, string.Empty); string windowOpenScript = "function openWindow() { window.open('" + url + "','Warehouse','height=600,width=900,toolbar=0,status=1,location=0,menubar=0,scrollbars=1,resizable=1'); }"; if (!Page.ClientScript.IsClientScriptBlockRegistered("openWindow")) Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "openWindow", windowOpenScript, true); } if (!IsPostBack) { order = new clsWorkOrders(); order.cAction = "S"; order.iOrgId = OrgId; order.iId = OrderId; order.iRepairId = RepairId; dsRepairItemsCats = order.GetRepairItemsAndCats(); dsRepairItemsCats.Relations.Add(new DataRelation("Cats_Items", dsRepairItemsCats.Tables["Table"].Columns["Id"], dsRepairItemsCats.Tables["Table1"].Columns["CatId"])); ddlRepairCats.DataSource = dsRepairItemsCats; ddlRepairCats.DataBind(); ddlRepairItems.DataSource = dsRepairItemsCats; ddlRepairItems.DataBind(); ListLink.DataBind(); if (Mode) // Add Mode { order.sTypeService = sType; order.iItemId = ItemId; if (sType == "II") { lblTableTitle.Text = "Please check the following to update any reported issues associated with this Inspection item"; DataTable dtReportedIssues = order.GetReportedIssuesListUpdate(); if (dtReportedIssues.Rows.Count > 0) { repReportedIssues.DataSource = new DataView(dtReportedIssues); repReportedIssues.DataBind(); } else { lblTableTitle.Text = "Serviced Repairs"; repReportedIssues.Visible = false; } } else { lblTableTitle.Text = "Serviced Repairs"; repReportedIssues.Visible = false; } // showing all repaires with associations repRepairs.DataSource = new DataView(order.GetRepairsListUpdate()); repRepairs.DataBind(); order.GetIssueInfo(); lblSourceType.Text = order.sTypeService.Value; lblRepairCategory.Text = order.sRepairCatName.Value; lblIssue.Text = order.sServiceName.Value; } else // Edit Mode { // hidding the controls for Edit mode tblSource.Visible = false; lblTableTitle.Text = "Repair"; repRepairs.Visible = false; html_chNewRepair.Visible = false; lblTableFooter.Visible = false; RepairLogsLinksPanel.Visible = false; // getting repair's info order.RepairCommonDetails(); ddlRepairCats.SelectedValue = order.iRepairCatId.Value.ToString(); ddlRepairItems.SelectedValue = order.iRepairItemId.Value.ToString(); tbNotes.Text = order.sRepairDesc.Value; } dtParts = order.GetPartsUsedList(); ViewState["PartsUsed"] = dtParts; dwParts = new DataView(dtParts); dwParts.RowFilter = "IsDeleted=0"; repParts.DataSource = dwParts; repParts.DataBind(); } } catch (Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = sLastPage; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if (order != null) order.Dispose(); } }
private void Page_Load(object sender, System.EventArgs e) { try { OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); if(Request.QueryString["select"] == null) sSelect = "AddOrder"; else sSelect = Convert.ToString(Request.QueryString["select"]); dgMainList.Controls.Clear(); if(!IsPostBack) { equip = new clsEquipment(); loc = new clsLocations(); dep = new clsDepartments(); user = new clsUsers(); equip.cAction = "S"; 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) { // if(ddlDrivers.Items.FindByValue(_functions.GetUserOrgId(Context.User.Identity.Name, true).ToString()) != null) // ddlDrivers.SelectedValue = _functions.GetUserOrgId(Context.User.Identity.Name, true).ToString(); equip.iTypeId = Convert.ToInt32(ddlEquipTypes.SelectedValue); equip.iDeptId = Convert.ToInt32(ddlDepartments.SelectedValue); equip.iLocId = Convert.ToInt32(ddlLocations.SelectedValue); equip.iIsSpare = Convert.ToInt32(ddlSpare.SelectedValue); equip.iUserId = Convert.ToInt32(ddlDrivers.SelectedValue); equip.sEquipId_Filter = _functions.ConvertToSQLFilter(tbEquipId.Text); eFilter = new EquipFilter(); eFilter.iTypeId = equip.iTypeId.Value; eFilter.iIsSpare = equip.iIsSpare.Value; eFilter.iDeptId = equip.iDeptId.Value; eFilter.iLocId = equip.iLocId.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; } switch(sSelect) { case "AddOrder": m_bShowUnassigned = false; equip.sLink = "wo_existingWorkOrders.aspx"; break; case "AddPastOrder": m_bShowUnassigned = false; equip.sLink = "wo_editAddInfo.aspx"; break; case "AddIssue": m_bShowUnassigned = false; equip.sLink = "manageIssues.aspx"; break; case "AddRoadside": m_bShowUnassigned = false; equip.sLink = "wo_selectOperator.aspx"; break; case "ChangeTempOper": m_bShowUnassigned = true; equip.sLink = "e_selectTempOperator.aspx"; break; default: m_bShowUnassigned = false; equip.sLink = "wo_existingWorkOrders.aspx"; break; } //dtEquipments = equip.GetEquipList_Filter(m_bShowUnassigned); dtEquipments = equip.GetEquipList_Filter(true); dgMainList.DataSource = new DataView(dtEquipments); dgMainList.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(equip != null) equip.Dispose(); if(loc != null) loc.Dispose(); if(dep != null) dep.Dispose(); if(user != null) user.Dispose(); } }
private void ShowGroups() { try { user = new clsUsers(); user.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); dtGroups = user.GetGroupsList(); dgGroups.DataSource = new DataView(dtGroups); dgGroups.DataBind(); } catch(Exception ex) { throw new Exception(ex.Message, ex); } finally { if(user != null) user.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(); } }
protected void CheckLinks(System.Web.UI.Page _page) { System.Web.UI.WebControls.HyperLink hlItem; string pageName; DataView dvPages = null; clsUsers user = null; try { foreach(System.Web.UI.Control _MainControl in _page.Controls) { if(_MainControl.GetType().FullName == "System.Web.UI.HtmlControls.HtmlForm") { foreach(System.Web.UI.Control _control in _MainControl.Controls) { if(_control.GetType().FullName == "System.Web.UI.WebControls.HyperLink") { hlItem = (System.Web.UI.WebControls.HyperLink)_control; hlItem.Visible = false; pageName = _functions.GetFileNameFromURL(hlItem.NavigateUrl); if((pageName.ToLower() != "default.aspx") && (pageName.ToLower() != "error.aspx") && (pageName.ToLower() != "accessdenied.aspx")) { dvPages = (DataView)Context.Cache["userPages"]; if(dvPages == null) { user = new clsUsers(); user.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); dvPages = new DataView(user.GetPagesList()); Context.Cache.Insert("userPages", dvPages, null, DateTime.Now.AddHours(12), TimeSpan.Zero); } dvPages.RowFilter = "vchPageName = '" + pageName + "'"; if(dvPages.Count > 0) { foreach(string role in dvPages[0]["vchGroupList"].ToString().Split(new char[] {';'})) { if(Context.User.IsInRole(role)) { hlItem.Visible = true; } } } else if(Context.User.IsInRole("Administrators")) hlItem.Visible = true; } else { hlItem.Visible = true; } } } return; } } } catch(Exception ex) { _functions.Log("Application error: \n" + ex.ToString()); } finally { if(user != null) { user.Dispose(); } } }
private void Page_Load(object sender, System.EventArgs e) { try { OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); Session["PathToViewOrder"] = "EquipWOReport"; if(!IsPostBack) { dtCurrentDate = DateTime.Now; adtEndDate.Date = dtCurrentDate; adtStartDate.Date = dtCurrentDate.AddDays(-365); order = new clsWorkOrders(); order.iOrgId = OrgId; dsRepairItemsCats = order.GetRepairItemsAndCats(); ddlRepairCats.DataSource = dsRepairItemsCats; ddlRepairCats.DataBind(); ddlRepairCats.Items[0].Text = "All"; ddlWOTypes.DataSource = order.GetTypesList(); ddlWOTypes.DataBind(); ddlWOTypes.Items.Insert(0, new ListItem("All","0")); user = new clsUsers(); user.iOrgId = OrgId; user.iTypeId = (int)UserTypes.Technician; ddlTech.DataSource = new DataView(user.GetUserListByType()); ddlTech.DataBind(); ddlTech.Items[0].Text = "All"; user.iTypeId = (int)UserTypes.Operator; ddlOperators.DataSource = new DataView(user.GetUserListByType()); ddlOperators.DataBind(); ddlOperators.Items[0].Text = "All"; } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "main.aspx"; 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(); } }
private void btLogin_Click(object sender, System.EventArgs e) { string sUserData; string[] roles; string roleStr = ""; DataTable dtGroups = null; int iReturn; try { user = new clsUsers(); user.sEmail = tbEmail.Text; user.sPass = tbPassword.Text; iReturn = user.Authenticate(); switch(iReturn) { case 0: lbErr.Visible = false; sUserData = user.iId.Value.ToString() + ":" + user.iOrgId.Value.ToString(); dtGroups = user.GetUserGroupsList(); foreach (DataRow dr in dtGroups.Rows) { roleStr += String.Format("{0};", dr["vchDesc"]); } roleStr = roleStr.Remove(roleStr.Length - 1, 1); FormsAuthenticationTicket ticket = new FormsAuthenticationTicket( 1, sUserData, DateTime.Now, DateTime.Now.AddHours(1), false, roleStr ); roles = roleStr.Split(new char[] {';'}); string cookieStr = FormsAuthentication.Encrypt(ticket); Response.Cookies["bfp_roles"].Value = cookieStr; Response.Cookies["bfp_roles"].Path = "/"; Response.Cookies["bfp_roles"].Expires = DateTime.Now.AddHours(1); FormsAuthentication.SetAuthCookie(sUserData, true); Response.Redirect("main.aspx", false); break; case 1: tblLogin.Rows[0].Visible = true; tblLogin.Rows[1].Visible = true; tblLogin.Rows[2].Visible = false; tblLogin.Rows[3].Visible = false; tblLogin.Rows[4].Visible = false; ViewState["UserId"] = user.iId.Value; dgOrgs.DataSource = new DataView(user.GetOrgListFromUser()); dgOrgs.DataBind(); lbErr.Visible = false; break; case -1: lbErr.Visible = true; break; default: lbErr.Visible = true; break; } } catch(Exception ex) { _functions.Log(ex, "", "default.aspx.cs"); lbErr.Visible = true; lbErr.Text = ex.Message; } finally { if(user != null) { user.Dispose(); } } }
private void dgOrgs_SelectedIndexChanged(object sender, System.EventArgs e) { string sUserData; string[] roles; string roleStr = ""; DataTable dtGroups = null; string sOrg; try { lbErr.Visible = false; sOrg = ((LinkButton)dgOrgs.SelectedItem.FindControl("lbSelect")).CommandArgument; sUserData = ((int)ViewState["UserId"]).ToString() + ":" + sOrg; user = new clsUsers(); user.iOrgId = Convert.ToInt32(sOrg); user.iId = (int)ViewState["UserId"]; dtGroups = user.GetUserGroupsList(); foreach (DataRow dr in dtGroups.Rows) { roleStr += String.Format("{0};", dr["vchDesc"]); } roleStr = roleStr.Remove(roleStr.Length - 1, 1); FormsAuthenticationTicket ticket = new FormsAuthenticationTicket( 1, sUserData, DateTime.Now, DateTime.Now.AddHours(1), false, roleStr ); roles = roleStr.Split(new char[] {';'}); string cookieStr = FormsAuthentication.Encrypt(ticket); Response.Cookies["bfp_roles"].Value = cookieStr; Response.Cookies["bfp_roles"].Path = "/"; Response.Cookies["bfp_roles"].Expires = DateTime.Now.AddHours(1); FormsAuthentication.SetAuthCookie(sUserData, true); Response.Redirect("main.aspx", false); } catch(Exception ex) { lbErr.Visible = true; _functions.Log(ex, "", "default.aspx.cs"); lbErr.Text = ex.Message; } finally { if(user != null) { user.Dispose(); } } }
private void Page_Load(object sender, System.EventArgs e) { try { OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); if(!IsPostBack) { user = new clsUsers(); user.iOrgId = OrgId; DataTable dtGroups = user.GetGroupsList(); DataRow _row = dtGroups.NewRow(); _row["Id"] = 0; _row["vchDesc"] = "All"; _row["CanDelete"] = false; dtGroups.Rows.Add(_row); DataView dwGroups = new DataView(dtGroups); dwGroups.Sort = "Id asc"; ddlGroups.DataSource = dwGroups; ddlGroups.DataBind(); if(Session["UserFilter"] != null) { uFilter = (UserFilter)Session["UserFilter"]; user.sFirstName = uFilter.sFirstName; user.sLastName = uFilter.sLastName; user.sEmail = uFilter.sEmail; user.iTypeId = uFilter.iTypeId; user.iActiveStatus = uFilter.iActiveStatus; user.iGroupId = uFilter.iGroupId; dgUserList.DataSource = new DataView(user.GetUserList_Filter()); dgUserList.DataBind(); tbFirstName.Text = uFilter.sFirstName; tbLastName.Text = uFilter.sLastName; tbEmail.Text = uFilter.sEmail; ddlUserTypes.SelectedValue = uFilter.iTypeId.ToString(); ddlActiveStatus.SelectedValue = uFilter.iActiveStatus.ToString(); ddlGroups.SelectedValue = uFilter.iGroupId.ToString(); } } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "admin.aspx"; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(user!=null) user.Dispose(); } }
private void ddlTechnicians_SelectedIndexChanged(object sender, System.EventArgs e) { try { user = new clsUsers(); user.iOrgId = OrgId; user.iOrderId = OrderId; user.iId = Convert.ToInt32(ddlTechnicians.SelectedValue); if(user.GetTechnicianInfo() != -1) { tbHourlyRate.Text = user.dmHourlyRate.Value.ToString("F"); if(!user.bTechCanViewHourlyRate.Value) { ViewState["HourlyRate"] = user.dmHourlyRate.Value; html_tblMain.Rows[12].Visible = false; html_trTotalCosts.Visible = false; } else { ViewState["HourlyRate"] = null; html_tblMain.Rows[12].Visible = true; html_trTotalCosts.Visible = true; } } else { html_tblMain.Rows[12].Visible = true; html_trTotalCosts.Visible = true; tbHourlyRate.Text = "0.0"; ViewState["HourlyRate"] = null; } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_updateTimeLog.aspx?id=" + OrderId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(user != null) user.Dispose(); } }
private void Page_Load(object sender, System.EventArgs e) { string sBackPage; 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; } lblBack.Text = "<input type=button value=\" Back \" onclick=\"document.location='admin_users.aspx'\">"; if(!IsPostBack) { hlUserEdit.NavigateUrl = "admin_user_detail_edit.aspx?id=" + UserId.ToString(); 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; lblType.Text = user.sTypeName.Value; lblEmail.Text = user.sEmail.Value; lblHourlyRate.Text = user.dmHourlyRate.Value.ToString("C"); lblCreatedDate.Text = user.daCreated.Value.ToLongDateString() + " " + user.daCreated.Value.ToLongTimeString(); if(user.bActiveStatus.Value) { lblUserActivateStatus.Text = "Activated"; } else { lblUserActivateStatus.Text = "Deactivated"; } dgGroups.DataSource = new DataView(user.GetUserGroupsList()); dgGroups.DataBind(); equip = new clsEquipment(); equip.iOrgId = OrgId; equip.iUserId = UserId; dgEquipments.DataSource = new DataView(equip.GetEquipListByUser()); dgEquipments.DataBind(); } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "admin_users.aspx"; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(equip != null) equip.Dispose(); if(user != null) user.Dispose(); } }
private void Page_Load(object sender, System.EventArgs e) { try { if(Request.QueryString["id"] == null) { Session["lastpage"] = "wo_default.aspx"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { OrderId = Convert.ToInt32(Request.QueryString["id"]); OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); } catch(FormatException fex) { Session["lastpage"] = "wo_default.aspx"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } if(Request.QueryString["repairid"] != null) RepairId = Convert.ToInt32(Request.QueryString["repairid"]); else RepairId = 0; html_btnBack.Attributes.Add("onclick", "document.location='wo_viewWorkOrder.aspx?id=" + OrderId.ToString() + "&#TimeLog';"); 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()); dtNow = DateTime.Now; if(!IsPostBack) { rdiStartTime.SelectedDate = dtNow; rdiStopTime.SelectedDate = dtNow; order = new clsWorkOrders(); user = new clsUsers(); order.cAction = "S"; order.iOrgId = OrgId; order.iId = OrderId; user.iOrgId = OrgId; user.iOrderId = OrderId; user.iTypeId = (int)UserTypes.Technician; DataTable dtTechList = user.GetUserListByType(); dtTechList.Rows[0].Delete(); ddlTechnicians.DataSource = new DataView(dtTechList); ddlTechnicians.DataBind(); DataTable dtRepairList = order.GetRepairsShortList(); dtRepairList.Rows[0].Delete(); ddlRepairs.DataSource = new DataView(dtRepairList); ddlRepairs.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(); lblEquipId.Text = order.sEquipId.Value; lblOperator.Text = order.sOperatorName.Value; lblTech.Text = order.sTechName.Value; if(user.GetTechnicianInfo() != -1) { tbHourlyRate.Text = user.dmHourlyRate.Value.ToString("F"); if(!user.bTechCanViewHourlyRate.Value) { ViewState["HourlyRate"] = user.dmHourlyRate.Value; html_tblMain.Rows[12].Visible = false; html_trTotalCosts.Visible = false; } else { ViewState["HourlyRate"] = null; html_tblMain.Rows[12].Visible = true; html_trTotalCosts.Visible = true; } } else { html_trTotalCosts.Visible = true; html_tblMain.Rows[12].Visible = true; tbHourlyRate.Text = "0.0"; ViewState["HourlyRate"] = null; } if(ddlTechnicians.Items.FindByValue(order.iTechId.Value.ToString()) != null) { ddlTechnicians.SelectedValue = order.iTechId.Value.ToString(); } else { ddlTechnicians.SelectedIndex = 0; } if(ddlRepairs.Items.FindByValue(RepairId.ToString()) != null) { ddlRepairs.SelectedValue = RepairId.ToString(); } else { ddlRepairs.SelectedIndex = 0; } order.iTechId = 0; dtTimeLog = order.GetTimeLogList(); if(dtTimeLog.Rows.Count > 0) { repTimeLog.DataSource = new DataView(dtTimeLog); repTimeLog.DataBind(); html_tblNoneTimeLog.Visible = false; lblTotalHours.Text = order.sReportDesc.Value; lblTotalCosts.Text = order.sDecs.Value; } else { html_tblNoneTimeLog.Visible = true; repTimeLog.Visible = false; html_trTotalHours.Visible = false; html_trTotalCosts.Visible = 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(user != null) user.Dispose(); if(order != null) order.Dispose(); } }
/// <summary> /// DataBinding te RepairList and PartsList /// </summary> private void ShowRepairList() { try { order.iOrgId = OrgId; order.iId = OrderId; order.iTechId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); dtRepairs = order.GetRepairsList(); if(dtRepairs.Rows.Count > 0) html_tblNoneRepairs.Visible = false; else html_tblNoneRepairs.Visible = true; repRepairs.DataSource = new DataView(dtRepairs); repRepairs.DataBind(); dtPartsUsed = order.GetPartsUsedListForOrder(); if(dtPartsUsed.Rows.Count > 0) html_tblNoneParts.Visible = false; else html_tblNoneParts.Visible = true; repPartsUsed.DataSource = new DataView(dtPartsUsed); repPartsUsed.DataBind(); if(order.GetCompleteAbleOrder() == 1) hlCloseOrder.Enabled = true; else hlCloseOrder.Enabled = false; if(order.GetDeleteAbleOrder() == 1) hlDeleteOrder.Enabled = true; else hlDeleteOrder.Enabled = false; order.iId = OrderId; order.iTechId = 0; DataTable dtTimeLog = order.GetTimeLogList(); if(dtTimeLog.Rows.Count > 0) { repTimeLog.DataSource = new DataView(dtTimeLog); repTimeLog.DataBind(); html_tblNoneTimeLog.Visible = false; lblTotalHours.Text = order.sReportDesc.Value; lblTotalCosts.Text = order.sDecs.Value; user = new clsUsers(); user.iOrgId = OrgId; user.iOrderId = OrderId; if(user.GetTechnicianInfo() != -1) if(!user.bTechCanViewHourlyRate.Value) html_trTotalCosts.Visible = false; else html_trTotalCosts.Visible = true; } else { repTimeLog.Visible = false; html_tblNoneTimeLog.Visible = true; html_trTotalHours.Visible = false; html_trTotalCosts.Visible = false; } } catch(Exception ex) { throw new Exception(ex.Message, ex); } }
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 dgGroups_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { try { switch(e.CommandName) { case "Delete": user2 = new clsUsers(); user2.cAction = "D"; user2.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); user2.iGroupId = Convert.ToInt32(e.Item.Cells[0].Text); switch(user2.GroupDetails()) { case -1: Session["lastpage"] = "admin_groups.aspx"; Session["error"] = _functions.ErrorMessage(117); Response.Redirect("error.aspx", false); return; case 1: Session["lastpage"] = "admin_groups.aspx"; Session["error"] = _functions.ErrorMessage(118); Response.Redirect("error.aspx", false); return; case 0: dgGroups.EditItemIndex = -1; ShowGroups(); break; default: break; } break; case "Cancel": dgGroups.EditItemIndex = -1; ShowGroups(); break; case "Edit": dgGroups.EditItemIndex = e.Item.ItemIndex; ShowGroups(); break; case "Update": user2 = new clsUsers(); user2.cAction = "U"; user2.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); user2.iGroupId = Convert.ToInt32(((Label)e.Item.FindControl("lblEditId")).Text); user2.sGroupName = ((TextBox)e.Item.FindControl("tbNameEdit")).Text; if(user2.GroupDetails() == -1) { Session["lastpage"] = "admin_groups.aspx"; Session["error"] = _functions.ErrorMessage(117); Response.Redirect("error.aspx", false); return; } dgGroups.EditItemIndex = -1; ShowGroups(); break; default: break; } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "admin_groups.aspx"; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(user2 != null) user2.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 Page_Load(object sender, System.EventArgs e) { try { OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); if((Request.QueryString["equipid"] == null) || (Request.QueryString["orderid"] == null)) { Session["lastpage"] = "wo_default.aspx?select=AddRoadside"; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { EquipId = Convert.ToInt32(Request.QueryString["equipid"]); OrderId = Convert.ToInt32(Request.QueryString["orderid"]); } catch(FormatException fex) { Session["lastpage"] = "wo_default.aspx?select=AddRoadside"; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } NextBackControl.BackPage = this.ParentPageURL; NextBackControl.BackVisible = true; NextBackControl.CausesValidation = true; if(!IsPostBack) { pnlVerifyOperator.Visible = true; user = new clsUsers(); user.iOrgId = OrgId; user.iTypeId = (int)UserTypes.Technician; ddlTech.DataSource = new DataView(user.GetUserListByType()); ddlTech.DataBind(); EquipmentDetails(); } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_default.aspx?select=AddRoadside"; Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(user != null) user.Dispose(); } }
private void Page_Load(object sender, System.EventArgs e) { string sTypeName; string sDomenName; string sReportPath; try{ int l_iCount; #region Header Section 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; } if((string)Session["PathToViewOrder"] != "Monthly-Daily") l_iCount = 2; else l_iCount = 3; Header.AddJavaScriptFile("/OpenWindows.js"); Header.AddBreadCrumb("Home", "/main.aspx"); switch((string)Session["PathToViewOrder"]) { case "Monthly-Daily": Header.AddBreadCrumb("Monthly Work Orders View", "/wo_showOrdersForMonthly.aspx"); Header.AddBreadCrumb("Daily Work Orders View", "/wo_showOrdersForDaily.aspx"); m_sLastPage = "wo_showOrdersForDaily.aspx"; break; case "Monthly": Header.AddBreadCrumb("Monthly Work Orders View", "/wo_showOrdersForMonthly.aspx"); m_sLastPage = "wo_showOrdersForMonthly.aspx"; break; case "Daily": Header.AddBreadCrumb("Daily Work Orders View", "/wo_showOrdersForDaily.aspx"); m_sLastPage = "wo_showOrdersForDaily.aspx"; break; case "Today": Header.AddBreadCrumb("Work Orders Overview", "/wo_showOrdersForToday.aspx"); m_sLastPage = "wo_showOrdersForToday.aspx"; break; case "Weekly": Header.AddBreadCrumb("Weekly Work Orders View", "/wo_showOrdersForWeekly.aspx"); m_sLastPage = "wo_showOrdersForWeekly.aspx"; break; case "Scheduled": Header.AddBreadCrumb("The Scheduled Orders", "/wo_showUnassignedOrders.aspx"); m_sLastPage = "wo_showUnassignedOrders.aspx"; break; case "Completed": Header.AddBreadCrumb("Completed Work Orders", "/wo_showCompletedOrders.aspx"); m_sLastPage = "wo_showCompletedOrders.aspx"; break; case "EquipWOReport": Header.AddBreadCrumb("Equipment Work Order Report", "/wo_viewEquipWorkOrderReport.aspx"); m_sLastPage = "wo_viewEquipWorkOrderReport.aspx"; break; default: Header.AddBreadCrumb("Work Orders Overview", "/wo_showOrdersForToday.aspx"); m_sLastPage = "wo_showOrdersForToday.aspx"; break; } Response.Cookies["bfp_navigate"].Value = Header.BrdCrumbsSerialization; Response.Cookies["bfp_navigate"].Path = "/"; Response.Cookies["bfp_navigate"].Expires = DateTime.Now.AddYears(1); //Session["BrdCrumbs"] = arrBrdCrumbs; #endregion if(!IsPostBack) { dtCustomFields = new DataTable(); dtCustomFields.Columns.Add("ValueName"); dtCustomFields.Columns.Add("Value"); order = new clsWorkOrders(); user = new clsUsers(); order.cAction = "S"; order.iOrgId = OrgId; order.iId = OrderId; if(order.WorkOrderDetails() == -1) { Session["lastpage"] = m_sLastPage; Session["error"] = _functions.ErrorMessage(120); Response.Redirect("error.aspx", false); return; } #region Processing of the Operation Area hlMainEdit.NavigateUrl = "wo_editWorkOrder.aspx?id=" + OrderId.ToString(); hlCloseOrder.NavigateUrl = "wo_closeWorkOrder.aspx?id=" + OrderId.ToString(); hlOpenOrder.NavigateUrl = "wo_openWorkOrder.aspx?id=" + OrderId.ToString(); hlDeleteOrder.NavigateUrl = "wo_deleteWorkOrder.aspx?id=" + OrderId.ToString(); hlCheckIn.NavigateUrl = "wo_viewCheckIn.aspx?id=" + OrderId.ToString(); hlCheckOut.NavigateUrl = "wo_viewCheckOut.aspx?id=" + OrderId.ToString(); hlTimeLog.NavigateUrl = "wo_updateTimeLog.aspx?id=" + OrderId.ToString(); hlReportedIssues.NavigateUrl = "wo_addRepairs.aspx?id=" + OrderId.ToString() + "&back=view"; hlPMItems.NavigateUrl = "wo_addPreventiveMaintenance.aspx?id=" + OrderId.ToString() + "&back=view"; hlInspections.NavigateUrl = "wo_addInspections.aspx?id=" + OrderId.ToString() + "&back=view"; sReportPath = _functions.GetValueFromConfig("SQLRS.Folder"); hlPrintPartUsed.NavigateUrl = "ReportViewer.aspx?Report=" + sReportPath + "%2fPartsList&OrderId=" + OrderId.ToString() + "&OrgId=" + OrgId.ToString(); hlPrintOrderRequest.NavigateUrl = "ReportViewer.aspx?Report=" + sReportPath + "%2fWorkOrderRequest&OrderId=" + OrderId.ToString() + "&OrgId=" + OrgId.ToString(); hlPrintCompletedOrder.NavigateUrl = "ReportViewer.aspx?Report=" + sReportPath + "%2fCompletedOrder&OrderId=" + OrderId.ToString()+ "&OrgId=" + OrgId.ToString(); hlAddRepair.NavigateUrl = "wo_updateRepair.aspx?mode=Edit&repairid=0&inspectid=0&type=FREE&op=Repair&id=" + OrderId.ToString() + "&itemid=0"; status = (WorkOrderStatus)order.iStatusId.Value; opstatus = order.iOperatorStatusId.IsNull?WorkOrderOperatorStatus.Null:(WorkOrderOperatorStatus)order.iOperatorStatusId.Value; ViewState["status"] = status; ViewState["opstatus"] = opstatus; switch(status) { case WorkOrderStatus.Scheduled: // Scheduled status hlMainEdit.Enabled = true; hlMainEdit.Text = "[Change the Scheduled Date]"; hlReportedIssues.Enabled = true; hlPMItems.Enabled = true; hlInspections.Enabled = true; hlCloseOrder.Enabled = false; hlDeleteOrder.Enabled = true; hlTimeLog.Enabled = false; if(opstatus == WorkOrderOperatorStatus.Checked_In) { // check-in status hlOpenOrder.Enabled = true; } else { // not check-in status hlCheckIn.Enabled = true; } break; case WorkOrderStatus.Open: // Opened status hlMainEdit.Enabled = true; hlReportedIssues.Enabled = true; hlPMItems.Enabled = true; hlInspections.Enabled = true; hlPrintOrderRequest.Enabled = true; hlPrintPartUsed.Enabled = true; hlAddRepair.Enabled = true; lbSaveNotes.Enabled = true; hlTimeLog.Enabled = true; break; case WorkOrderStatus.ReOpened: // ReOpened status hlMainEdit.Enabled = true; hlReportedIssues.Enabled = true; hlPMItems.Enabled = true; hlInspections.Enabled = true; hlPrintOrderRequest.Enabled = true; hlPrintPartUsed.Enabled = true; hlAddRepair.Enabled = true; lbSaveNotes.Enabled = true; hlTimeLog.Enabled = true; break; case WorkOrderStatus.Closed: // Closed Status hlMainEdit.Enabled = true; hlMainEdit.Text = "[Change the Order Dates]"; hlPrintCompletedOrder.Enabled = true; hlPrintPartUsed.Enabled = true; hlTimeLog.Enabled = true; if(opstatus == WorkOrderOperatorStatus.Checked_In) { // check-in status hlCheckOut.Enabled = true; } break; } #endregion #region Processing of the Information Area if(status == WorkOrderStatus.Closed) Session["CurrentDay"] = order.daClosed.Value; else Session["CurrentDay"] = order.daScheduled.Value; lblWorkOrderN.Text = order.daCreated.Value.ToString("yyyy-MM-dd") + "-" + order.iWorkOrderNumber.Value.ToString(); lblWOType.Text = order.sType.Value; lblStatus.Text = order.sStatusId.Value; lblOperatorStatus.Text = order.sOperatorStatus.Value; lblStaying.Text = order.bStaying.IsNull?"not defined":(order.bStaying.Value?"Yes":"No"); lblSpare.Text = order.sSpareEquipId.Value; lblTech.Text = order.sTechName.Value; lblOperator.Text = order.sOperatorName.Value; lblDroppedOffBy.Text = order.sDropedOffBy.Value; lblReleasedTo.Text = order.sReleasedTo.Value; lblCleanliness.Text = order.sCleanliness.Value; hlServiceDates.Attributes.Add("onclick", "window.open('wo_viewDates.aspx?id=" + OrderId.ToString() + "', 'popupcal', 'width=350,height=200,left=' + event.screenX + ',top=' + event.screenY + ',scrollbars=no');"); // showing equipment info hlEquipId.Text = order.sEquipId.Value; hlEquipId.NavigateUrl = "e_view.aspx?id=" + order.iEquipId.Value.ToString(); lblType.Text = order.sEquipTypeName.Value; lblMakeModel.Text = order.sEquipMakeModel.Value; lblYear.Text = (order.sEquipYear.Value == "0")?"unknown":order.sEquipYear.Value; lblSerial.Text = order.sEquipVinSerial.Value; lblUnits.Text = Convert.ToDouble(order.dmMileage.Value).ToString(); #endregion #region Processing of the Issues Area order.iTechId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); dtPMItems = order.GetWorkOrderPMItems(); if(dtPMItems.Rows.Count > 0) html_tblNonePMItems.Visible = false; else html_tblNonePMItems.Visible = true; repPMItems.DataSource = new DataView(dtPMItems); repPMItems.DataBind(); dtIssues = order.GetWorkOrderReportedIssues(); if(dtIssues.Rows.Count > 0) html_tblNoneIssues.Visible = false; else html_tblNoneIssues.Visible = true; repIssues.DataSource = new DataView(dtIssues); repIssues.DataBind(); dtInspections = order.GetWorkOrderInspections(); if(dtInspections.Rows.Count > 0) html_tblNoneInspections.Visible = false; else html_tblNoneInspections.Visible = true; repInspections.DataSource = new DataView(dtInspections); repInspections.DataBind(); #endregion #region Processing of the Serviced Repairs Area and the Time Log Area ShowRepairList(); #endregion #region Processing of the Notes Area order.iItemId = OrderId; order.iNoteTypeId = (int)NoteTypes.CreationNote; repCreationNotes.DataSource = new DataView(order.GetNotesList()); repCreationNotes.DataBind(); order.iNoteTypeId = (int)NoteTypes.OperatorNote; repOperatorNotes.DataSource = new DataView(order.GetNotesList()); repOperatorNotes.DataBind(); order.iNoteTypeId = (int)NoteTypes.TechnicianNote; repTechNotes.DataSource = new DataView(order.GetNotesList()); repTechNotes.DataBind(); #endregion #region Processing of the Signatures Area order.iDocumentId = OrderId; order.iDocumentTypeId = (int)DocumentTypes.WorkOrderCheckedIn; if(order.GetSignedDocument() != -1) { lblSignCheckInBy.Text = order.sUserName.Value; lblSignCheckInByUnder.Text = order.sUserName.Value; lblSignDateCheckInBy.Text = order.daReportDate.Value.ToShortDateString() + " " + order.daReportDate.Value.ToShortTimeString(); } else { lblSignCheckInBy.Text = " "; } order.iDocumentTypeId = (int)DocumentTypes.WorkOrderReOpened; if(order.GetSignedDocument() != -1) { lblSignOpenedBy.Text = order.sUserName.Value; lblSignOpenedByUnder.Text = order.sUserName.Value; lblSignDateOpenedBy.Text = order.daReportDate.Value.ToShortDateString() + " " + order.daReportDate.Value.ToShortTimeString(); } else { order.iDocumentTypeId = (int)DocumentTypes.WorkOrderOpen; if(order.GetSignedDocument() != -1) { lblSignOpenedBy.Text = order.sUserName.Value; lblSignOpenedByUnder.Text = order.sUserName.Value; lblSignDateOpenedBy.Text = order.daReportDate.Value.ToShortDateString() + " " + order.daReportDate.Value.ToShortTimeString(); } else { lblSignOpenedBy.Text = " "; } } if(status == WorkOrderStatus.Closed) { order.iDocumentTypeId = (int)DocumentTypes.WorkOrderClosed; if(order.GetSignedDocument() != -1) { lblSignClosedBy.Text = order.sUserName.Value; lblSignClosedByUnder.Text = order.sUserName.Value; lblSignDateClosedBy.Text = order.daReportDate.Value.ToShortDateString() + " " + order.daReportDate.Value.ToShortTimeString(); } } if(opstatus == WorkOrderOperatorStatus.Checked_Out) { order.iDocumentTypeId = (int)DocumentTypes.WorkOrderCheckedOut; if(order.GetSignedDocument() != -1) { lblSignCheckOutBy.Text = order.sUserName.Value; lblSignCheckOutByUnder.Text = order.sUserName.Value; lblSignDateCheckOutBy.Text = order.daReportDate.Value.ToShortDateString() + " " + order.daReportDate.Value.ToShortTimeString(); } } #endregion #region Processing of the Custom Fields dtCustomFieldsFromDB = order.WorkOrderDetail_CustomFields(null); if(dtCustomFieldsFromDB.Rows.Count > 0) { arrCFD = _functions.GetCustomFields(CFDataType.WorkOrder, 0, HttpContext.Current.User.Identity.Name); if(arrCFD.Count > 0) { // fill custom fields for(int 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 = OrgId; mm.iModelId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]); mm.GetModelMakes(); dtCustomFields.Rows.Add(new object []{"Make/Model", mm.sMakeName + "/" + mm.sModelName}); if(mm != null) mm.Dispose(); } 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 = OrgId; 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, ""}); } if(dep != null) dep.Dispose(); } 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 = OrgId; 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, ""}); } if(loc != null) loc.Dispose(); } 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(); } } #endregion } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = m_sLastPage; 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(); } }
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"] = this.ParentPageURL; Session["error"] = _functions.ErrorMessage(104); Response.Redirect("error.aspx", false); return; } try { GroupId = Convert.ToInt32(Request.QueryString["id"]); } catch(FormatException fex) { Session["lastpage"] = this.ParentPageURL; Session["error"] = _functions.ErrorMessage(105); Response.Redirect("error.aspx", false); return; } lblBack.Text = "<input type=button value=\" Back \" onclick=\"document.location='admin_groups.aspx'\">"; if(!IsPostBack) { ViewState["GroupId"] = GroupId; perm = new clsPermissions(); user = new clsUsers(); perm.iGroupId = GroupId; perm.iOrgId = OrgId; user.cAction = "S"; user.iGroupId = GroupId; user.iOrgId = OrgId; if(user.GroupDetails() == -1) { Session["lastpage"] = ParentPageURL; Session["error"] = _functions.ErrorMessage(117); Response.Redirect("error.aspx", false); return; } lblGroupName.Text = user.sGroupName.Value; dsPerm = perm.GetPermissionListFromGroup(); dgPermissions.DataSource = new DataView(dsPerm.Tables["Table"]); dgPermissions.DataBind(); if(dsPerm.Tables["Table1"].Rows.Count > 0) { ddlNewPerm.DataTextField = "vchName"; ddlNewPerm.DataValueField = "Id"; ddlNewPerm.DataSource = new DataView(dsPerm.Tables["Table1"]); ddlNewPerm.DataBind(); } else { ddlNewPerm.Items.Add( new ListItem("<none>", "0")); btnAddPerm.Enabled = 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(user != null) user.Dispose(); if(perm != null) perm.Dispose(); } }
private void btnSearch_Click(object sender, System.EventArgs e) { try { pnlVerifyOperator.Visible = false; pnlSelectOperator.Visible = true; user = new clsUsers(); user.iOrgId = OrgId; user.sFirstName = tbFirstName.Text; user.sLastName = tbLastName.Text; user.sEmail = ""; user.iGroupId = 0; user.iActiveStatus = 0; user.iTypeId = (int)UserTypes.All; repOperators.DataSource = new DataView(user.GetUserList_Filter()); repOperators.DataBind(); } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName); Session["lastpage"] = "wo_selectOperator.aspx?equipid=" + EquipId.ToString() + "&orderid=" + OrderId.ToString(); Session["error"] = ex.Message; Session["error_report"] = ex.ToString(); Response.Redirect("error.aspx", false); } finally { if(user != null) user.Dispose(); } }
private void Global_AuthorizeRequest(object sender, System.EventArgs e) { string sMode; try { // Is user authenticated? if(Request.IsAuthenticated) { // getting the current page from the Request Object string pageName = Request.FilePath.Remove(0, Request.FilePath.LastIndexOf("/") + 1); // if page is avaible then skip it if((pageName.ToLower() == "default.aspx") || (pageName == "error.aspx") || (pageName.ToLower() == "accessdenied.aspx")) return; if (!pageName.Contains(".aspx")) return; // getting a mode from cookies if(Request.Cookies["bfp_mode"] == null) sMode = ""; else sMode = Request.Cookies["bfp_mode"].Value; switch(sMode) { case "OperatorKiosk": if(pageName.Substring(0, 3) == "ok_" || pageName == "ReportViewer.aspx" || pageName == "selectMode.aspx") break; else { Context.RewritePath("accessdenied.aspx"); return; } case "TechnicianMode": if(pageName.Substring(0, 5) == "admin_" || pageName.Substring(0, 6) == "error_") { Context.RewritePath("accessdenied.aspx"); return; } break; default: if(pageName == "ok_mainMenu.aspx") break; else if(pageName.Substring(0, 3) != "ok_") break; else { Context.RewritePath("accessdenied.aspx"); return; } } if(Request.Cookies["bfp_operator"] == null) { if(pageName.Substring(0, 3) == "ok_" && pageName != "ok_mainMenu.aspx" && pageName != "ok_authCredentials.aspx") { Context.RewritePath("accessdenied.aspx"); return; } } // getting the pages and groups for them from cache DataView dvPages = (DataView)Context.Cache["userPages"]; // if pages isn't existing then we create a new if(dvPages == null) { // getting the pages from database user = new clsUsers(); user.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); dvPages = new DataView(user.GetPagesList()); // insert pages to cache Context.Cache.Insert("userPages", dvPages, null, DateTime.Now.AddHours(12), TimeSpan.Zero); } // filter pages for current page dvPages.RowFilter = "vchPageName = '" + pageName + "'"; // if the page is there in pages list if(dvPages.Count > 0) { // to see roles for current groups of this page foreach(string role in dvPages[0]["vchGroupList"].ToString().Split(new char[] {';'})) { // if the current user have current role then we give an access for current page if(Context.User.IsInRole(role)) { return; } } } else // if current user is administrator then we give all access for every page if(Context.User.IsInRole("Administrators")) return; // if we come here then current user hasn't access to current page Context.RewritePath("accessdenied.aspx"); } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, "Global.asax.cs"); } finally { if(user != null) { user.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() + "&#Main"); SaveCancelControl.ParentPageURL = this.ParentPageURL; 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; rblWOTypes.DataSource = order.GetTypesList(); rblWOTypes.DataBind(); ddlTech.DataSource = new DataView(user.GetUserListByType()); ddlTech.DataBind(); if(order.WorkOrderDetails() == -1) { Session["lastpage"] = "wo_viewWorkOrder.aspx?id=" + OrderId.ToString(); Session["error"] = _functions.ErrorMessage(120); Response.Redirect("error.aspx", false); return; } status = (WorkOrderStatus)order.iStatusId.Value; opstatus = order.iOperatorStatusId.IsNull?WorkOrderOperatorStatus.Null:(WorkOrderOperatorStatus)order.iOperatorStatusId.Value; ViewState["StatusId"] = status; lblWorkOrderId.Text = order.daCreated.Value.ToString("yyyy-MM-dd") + "-" + order.iWorkOrderNumber.Value.ToString(); rblWOTypes.SelectedValue = order.iTypeId.Value.ToString(); hlEquipId.Text = order.sEquipId.Value; hlEquipId.NavigateUrl = "e_view.aspx?id=" + order.iEquipId.Value.ToString(); hlSpareEquipId.Text = order.sSpareEquipId.Value; hlChangeSpare.NavigateUrl = "wo_selectSpareEquip.aspx?id=" + OrderId.ToString() + "&back=edit"; if(order.iSpareEquipId.Value > 0) hlSpareEquipId.NavigateUrl = "e_view.aspx?id=" + order.iSpareEquipId.Value.ToString(); if(order.iTechId.Value != 0) { ddlTech.Items.Remove(ddlTech.Items[0]); if(ddlTech.Items.FindByValue(order.iTechId.Value.ToString()) != null) ddlTech.SelectedValue = order.iTechId.Value.ToString(); else Header.ErrorMessage = "Cannot find the assigned technician in the technician list"; } lblOperator.Text = order.sOperatorName.Value; if(order.bStaying.Value) rblStaying.SelectedValue = "True"; else rblStaying.SelectedValue = "False"; tbDroppedOffBy.Text = order.sDropedOffBy.Value; tbReleasedTo.Text = order.sReleasedTo.Value; tbCleanliness.Text = order.sCleanliness.Value; adtScheduled.Date = order.daScheduled.Value; lblCreatedDate.Text = order.daCreated.Value.ToLongDateString(); switch(status) { case WorkOrderStatus.Scheduled: // Scheduled status hlChangeSpare.Enabled = false; ddlTech.Enabled = false; rblStaying.Enabled = false; tbDroppedOffBy.Enabled = false; tbCleanliness.Enabled = false; tbReleasedTo.Enabled = false; adtScheduled.Enabled = true; html_ScheduledDate.Visible = true; SaveCancelControl.EnableSave = true; if(opstatus == WorkOrderOperatorStatus.Checked_In) { hlChangeSpare.Enabled = true; trCheckInDate.Visible = true; adtCheckIn.Date = order.daArrival.Value; } else trCheckInDate.Visible = false; trCheckOutDate.Visible = false; trClosedDate.Visible = false; trOpenedDate.Visible = false; break; case WorkOrderStatus.Open: // Opened status ViewState["ScheduledDate"] = order.daScheduled.Value; adtScheduled.Enabled = false; html_ScheduledDate.Visible = false; SaveCancelControl.EnableSave = true; trCheckInDate.Visible = true; adtCheckIn.Date = order.daArrival.Value; trOpenedDate.Visible = true; adtOpened.Date = order.daOpened.Value; trCheckOutDate.Visible = false; trClosedDate.Visible = false; break; case WorkOrderStatus.ReOpened: // Opened status ViewState["ScheduledDate"] = order.daScheduled.Value; adtScheduled.Enabled = false; html_ScheduledDate.Visible = false; SaveCancelControl.EnableSave = true; trCheckInDate.Visible = true; adtCheckIn.Date = order.daArrival.Value; trOpenedDate.Visible = true; adtOpened.Date = order.daOpened.Value; trCheckOutDate.Visible = false; trClosedDate.Visible = false; break; case WorkOrderStatus.Closed: // Closed Status ViewState["ScheduledDate"] = order.daScheduled.Value; hlChangeSpare.Enabled = false; ddlTech.Enabled = false; rblStaying.Enabled = false; tbDroppedOffBy.Enabled = true; adtScheduled.Enabled = false; html_ScheduledDate.Visible = false; tbCleanliness.Enabled = true; tbReleasedTo.Enabled = true; SaveCancelControl.EnableSave = true; trCheckInDate.Visible = true; adtCheckIn.Date = order.daArrival.Value; trOpenedDate.Visible = true; adtOpened.Date = order.daOpened.Value; trClosedDate.Visible = true; adtClosed.Date = order.daClosed.Value; if(opstatus == WorkOrderOperatorStatus.Checked_Out) { trCheckOutDate.Visible = true; adtCheckOut.Date = order.daDeparture.Value; } else trCheckOutDate.Visible = false; break; } if(order.iOperatorId.Value == 6) hlChangeSpare.Enabled = false; 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(); } }
protected void Application_AuthenticateRequest(Object sender, EventArgs e) { try { // Is user authenticated? if(Request.IsAuthenticated) { string[] roles; // `if roles in cookies isn't existing then to create a new else getting roles from cookies if ((Request.Cookies["bfp_roles"] == null) || (Request.Cookies["bfp_roles"].Value == "")) { // geting the user's groups for current user from database user = new clsUsers(); user.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false); user.iId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true); DataTable dtGroups = user.GetUserGroupsList(); // creating the roles's string for user from groups list string roleStr = ""; foreach (DataRow dr in dtGroups.Rows) { roleStr += String.Format("{0};", dr["vchDesc"]); } roleStr = roleStr.Remove(roleStr.Length - 1, 1); // creating a ticket for user with his roles FormsAuthenticationTicket ticket = new FormsAuthenticationTicket( 1, HttpContext.Current.User.Identity.Name, DateTime.Now, DateTime.Now.AddYears(1), false, roleStr ); // convert roles to string array roles = roleStr.Split(new Char[] {';'}); // encrypting ticket for setting to cookie String cookieStr = FormsAuthentication.Encrypt(ticket); Response.Cookies["bfp_roles"].Value = cookieStr; Response.Cookies["bfp_roles"].Path = "/"; Response.Cookies["bfp_roles"].Expires = DateTime.Now.AddYears(1); } else { // getting and decrypt the ticket from cookies FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(Context.Request.Cookies["bfp_roles"].Value); // getting and convert roles to string array ArrayList userRoles = new ArrayList(); foreach (String role in ticket.UserData.Split( new char[] {';'} )) { userRoles.Add(role); } roles = (String[]) userRoles.ToArray(typeof(String)); } // set the roles to current user HttpContext.Current.User = new GenericPrincipal(Context.User.Identity, roles); } } catch(Exception ex) { _functions.Log(ex, HttpContext.Current.User.Identity.Name, "Global.asax.cs"); } finally { if(user != null) { user.Dispose(); } } }