Exemplo n.º 1
0
        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();
            }
        }
Exemplo n.º 2
0
        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();
            }
        }
        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();
            }
        }
Exemplo n.º 4
0
        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();
            }
        }
Exemplo n.º 5
0
        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();
            }
        }
        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();
            }
        }
Exemplo n.º 7
0
        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();
            }
        }