예제 #1
0
        /// <summary>
        /// If the custom fields contain the lookup data then we will show its
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void repComponents_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)
        {
            System.Data.DataRowView drItem = null;
            object oItem;
            try
            {
                if(e.Item.ItemType == ListItemType.Item ||
                    e.Item.ItemType == ListItemType.AlternatingItem ||
                    e.Item.ItemType == ListItemType.SelectedItem)
                {
                    dtCustomFields = new DataTable();
                    dtCustomFields.Columns.Add("ValueName_Comp");
                    dtCustomFields.Columns.Add("Value_Comp");

                    dtComponents = (DataTable)ViewState["Components"];
                    for(int i=0; i< dtComponents.Rows.Count; i++)
                    {
                        drItem = (System.Data.DataRowView)e.Item.DataItem;
                        if(drItem.Row.ItemArray[0].ToString() == dtComponents.Rows[i]["ComponentId"].ToString())
                        {
                            // getting the custoom fields info for a Component
                            arrCFD = _functions.GetCustomFields(CFDataType.Component, Convert.ToInt32(dtComponents.Rows[i]["TypeId"]), HttpContext.Current.User.Identity.Name);
                            for(int j = 0; j < arrCFD.Count; j++)
                            {
                                cfd = (clsCustomFieldsDef)arrCFD[j];
                                sTypeName = _functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString();
                                oItem = dtComponents.Rows[i][sTypeName];
                                switch(cfd.FieldTypeId)
                                {
                                    case DBFieldType._lookup:
                                        switch(cfd.NameLookupTable)
                                        {
                                            case "EquipModels":
                                                if(oItem != DBNull.Value)
                                                {
                                                    mm = new clsMakesModels();
                                                    mm.iOrgId = OrgId;
                                                    mm.iModelId = Convert.ToInt32(oItem);
                                                    mm.GetModelMakes();
                                                    dtCustomFields.Rows.Add(new object []{"Make/Model", mm.sMakeName + "/" + mm.sModelName});
                                                }
                                                else
                                                    dtCustomFields.Rows.Add(new object []{"Make/Model", ""});
                                                break;
                                            case "Departments":
                                                if(oItem != DBNull.Value)
                                                {
                                                    dep =  new clsDepartments();
                                                    dep.cAction = "S";
                                                    dep.iOrgId = OrgId;
                                                    dep.iId = Convert.ToInt32(oItem);
                                                    if(dep.DepartmentDetail() == 0)
                                                    {
                                                        dtCustomFields.Rows.Add(new object []{cfd.NameText, dep.sName.Value});
                                                    }
                                                }
                                                else
                                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                                break;
                                            case "Locations":
                                                if(oItem != DBNull.Value)
                                                {
                                                    loc = new clsLocations();
                                                    loc.cAction = "S";
                                                    loc.iOrgId = OrgId;
                                                    loc.iId = Convert.ToInt32(oItem);
                                                    if(loc.LocationDetail() == 0)
                                                    {
                                                        dtCustomFields.Rows.Add(new object []{cfd.NameText, loc.sName.Value});
                                                    }
                                                }
                                                else
                                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                                break;
                                            default:
                                                break;
                                        }
                                        break;
                                    case DBFieldType._datetime:
                                        if(oItem != DBNull.Value)
                                            dtCustomFields.Rows.Add(new object []{cfd.NameText, Convert.ToDateTime(oItem).ToShortDateString()});
                                        else
                                            dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                        break;
                                    case DBFieldType._bit:
                                        if(oItem != DBNull.Value)
                                            if(((SqlBoolean)oItem) == SqlBoolean.True)
                                                dtCustomFields.Rows.Add(new object []{cfd.NameText, "Yes"});
                                            else
                                                dtCustomFields.Rows.Add(new object []{cfd.NameText, "No"});
                                        else
                                            dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                        break;
                                    default:
                                        if(oItem != DBNull.Value)
                                            dtCustomFields.Rows.Add(new object []{cfd.NameText, oItem});
                                        else
                                            dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                        break;
                                }
                                cfd = null;
                            }
                            ((Repeater)e.Item.FindControl("repComponentItem")).DataSource = new DataView(dtCustomFields);
                            ((Repeater)e.Item.FindControl("repComponentItem")).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
            {

            }
        }
예제 #2
0
        public override void DataBind()
        {
            try
            {
                    if(!m_bitIsComponent.IsNull)
                    {
                        mm = new clsMakesModels();
                        mm.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                        mm.bitIsComponent = m_bitIsComponent;
                        mm.iTypeId = m_iTypeId;
                        dsMMList = mm.GetModelMakesList();

                        dsMMList.Relations.Add( new DataRelation( "Makes_Models", dsMMList.Tables["Table"].Columns["Id"], dsMMList.Tables["Table1"].Columns["MakeId"] ) );

                        ddlMakes.DataSource = dsMMList;
                        ddlMakes.DataMember = "Table";
                        ddlMakes.DataValueField = "Id";
                        ddlMakes.DataTextField = "vchMakeName";
                        ddlMakes.DataBind();
                        ddlMakes.Items.Insert(0, "");
                        //ddlMakes.AutoPostBack = true;

                        ddlModels.DataSource = dsMMList;
                        ddlModels.DataMember = "Table1";
                        ddlModels.DataValueField = "Id";
                        ddlModels.DataTextField = "vchModelName";
                        ddlModels.DataBind();
                        ddlModels.Items.Insert(0, "");
                        //ddlModels.AutoPostBack = true;

                        ListLink.ParentList="ddlMakes";
                        ListLink.ChildList="ddlModels";
                        ListLink.DataRelation = "Makes_Models";
                        ListLink.EnableViewState=true;
                        ListLink.LockFirstItem=true;

                        if(!m_iModelId.IsNull)
                        {
                            mm.iModelId = m_iModelId;
                            // getting MakeId
                            mm.GetModelMakes();
                            ddlMakes.SelectedValue = mm.iMakeId.Value.ToString();
                            ddlModels.SelectedValue = m_iModelId.Value.ToString();
                        }
                        Literal.Text = "/";

                        rfvMakes.ErrorMessage = "Makes is required";
                        rfvMakes.ControlToValidate = "ddlMakes";
                        rfvMakes.Display = ValidatorDisplay.Dynamic;

                        rfvModels.ErrorMessage = "Models is required";
                        rfvModels.ControlToValidate = "ddlModels";
                        rfvModels.Display = ValidatorDisplay.Dynamic;

                        Controls.Add(ddlMakes);
                        Controls.Add(Literal);
                        Controls.Add(ddlModels);
                        Controls.Add(ListLink);

                        Literal.Text = "&nbsp;";

                        Controls.Add(Literal);
                        Controls.Add(rfvMakes);
                        Controls.Add(Literal);
                        Controls.Add(rfvModels);

                        ListLink.DataBind();

                    }
                    else
                    {
                        Controls.Clear();
                    }
            }
            catch(Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                if(mm != null)
                {
                    mm.Dispose();
                }
            }
        }
예제 #3
0
        private void Page_Load(object sender, System.EventArgs e)
        {
            int j;
            bool bVisibleLink;
            try
            {
                OrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);

                if(Request.QueryString["id"] == null)
                {
                    Session["lastpage"] = "e_list.aspx";
                    Session["error"] = _functions.ErrorMessage(104);
                    Response.Redirect("error.aspx", false);
                    return;
                }
                try
                {
                    EquipId = Convert.ToInt32(Request.QueryString["id"]);
                }
                catch(FormatException fex)
                {
                    Session["lastpage"] = "e_list.aspx";
                    Session["error"] = _functions.ErrorMessage(105);
                    Response.Redirect("error.aspx", false);
                    return;
                }

                if(!IsPostBack)
                {
                    hlEdit.NavigateUrl = "e_edit.aspx?id=" + EquipId.ToString();
                    hlEdit2.NavigateUrl = "e_edit2.aspx?id=" + EquipId.ToString();
                    hlEditCustom.NavigateUrl = "e_editCustom.aspx?id=" + EquipId.ToString();
                    hlEditAquis.NavigateUrl = "e_editAquis.aspx?id=" + EquipId.ToString();
                    hlEditDisp.NavigateUrl = "e_editDisp.aspx?id=" + EquipId.ToString();
                    hlReport.NavigateUrl = "e_viewEquipAssignmentReport.aspx?id=" + EquipId.ToString();

                    bVisibleLink = base.CheckPermission("e_editComponent.aspx");
                    trAddComponent.Visible  = bVisibleLink;

                    Session["EquipId"] = EquipId;

                    equip = new clsEquipment();
                    comp = new clsComponents();

                    dtCustomFields = new DataTable();
                    dtCustomFields.Columns.Add("ValueName");
                    dtCustomFields.Columns.Add("Value");

                    equip.iUserId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, true);
                    equip.iOrgId = OrgId;
                    equip.iId = EquipId;
                    equip.cAction = "S";

                    // showing a Equipment's main data from fixed fields
                    if(equip.EquipmentDetail() == -1)
                    {
                        Session["lastpage"] = ParentPageURL;
                        Session["error"] = _functions.ErrorMessage(102);
                        Response.Redirect("error.aspx", false);
                        return;
                    }
                    lblEquipment.Text = equip.sEquipId.Value;
                    lblType.Text = equip.sType.Value;
                    lblMakeModel.Text = equip.sMakeModelName.Value;
                    lblYear.Text = equip.iYear.Value.ToString();
                    lblSerial.Text = equip.sVinSerial.Value;
                    lblFuelCode.Text = equip.sFuelCode.Value;
                    lblPlateNumber.Text = equip.sPlateNumber.Value;
                    lblDepartment.Text = equip.sDeptName.Value;
                    lblLocation.Text = equip.sLocName.Value;
                    lblSpare.Text = equip.bSpare.Value?"Yes":"No";
                    lblAssignedTo.Text = equip.sEquipOperator.Value;
                    lblAssignTempTo.Text = equip.sTempOperator.Value;

                    // showing a Equipment's Alt data from fixed fields
                    if(equip.EquipmentDetail_Alt() == -1)
                    {
                        Session["lastpage"] = ParentPageURL;
                        Session["error"] = _functions.ErrorMessage(102);
                        Response.Redirect("error.aspx", false);
                        return;
                    }
                    lbPMSched.Text = equip.sPMSched.Value;
                    lbInspection.Text = equip.sInspectSchedule.Value;
                    if(!equip.dmCurrentUnits.IsNull)
                        lbUnits.Text = Convert.ToDouble(equip.dmCurrentUnits.Value).ToString();

                    // showing an Aquisition information from fixed fields
                    if(equip.EquipmentDetail_Aquis() == -1)
                    {
                        Session["lastpage"] = ParentPageURL;
                        Session["error"] = _functions.ErrorMessage(102);
                        Response.Redirect("error.aspx", false);
                        return;
                    }
                    if(!equip.daInService.IsNull)
                        lbDtInService.Text = equip.daInService.Value.ToShortDateString();
                    if(!equip.daAquired.IsNull)
                        lbDtAquired.Text = equip.daAquired.Value.ToShortDateString();
                    lbVchPurOrgContact.Text = equip.sPurOrgContact.Value;
                    if(!equip.curPurAmount.IsNull)
                        lbSmPurAmount.Text = equip.curPurAmount.Value.ToString();
                    if(!equip.dmPurUnits.IsNull)
                        lbIntPurUnits.Text = Convert.ToDouble(equip.dmPurUnits.Value).ToString();
                    lbVchPurNotes.Text = equip.sPurNotes.Value;

                    // showing a Disposal info from fixed fields
                    if(equip.EquipmentDetail_Disp() == -1)
                    {
                        Session["lastpage"] = ParentPageURL;
                        Session["error"] = _functions.ErrorMessage(102);
                        Response.Redirect("error.aspx", false);
                        return;
                    }
                    if(!equip.daOutOfService.IsNull)
                        lbDtOutOfService.Text = equip.daOutOfService.Value.ToShortDateString();
                    if(!equip.daDisposed.IsNull)
                        lbDtDisposed.Text = equip.daDisposed.Value.ToShortDateString();
                    if(!equip.sDispMethod.IsNull)
                        lbVchDispMethod.Text = equip.sDispMethod.Value;
                    if(!equip.sDispOrgContact.IsNull)
                        lbVchDispOrgContact.Text = equip.sDispOrgContact.Value;
                    if(!equip.curDispAmount.IsNull)
                        lbSmDispAmount.Text = equip.curDispAmount.Value.ToString();
                    if(!equip.dmDispUnits.IsNull)
                        lbIntDispUnits.Text = Convert.ToDouble(equip.dmDispUnits.Value).ToString();
                    lbVchDispNotes.Text = equip.sDispNotes.Value;

                    // getting all component's types to dropdownlist
                    comp.iEquipId  = EquipId;
                    DataTable dtComponmentAdd = comp.GetComponentTypeList();
                    if(dtComponmentAdd.Rows.Count > 0)
                    {
                        ddlComponentTypes.DataTextField = "vchName";
                        ddlComponentTypes.DataValueField = "Id";
                        ddlComponentTypes.DataSource = new DataView(dtComponmentAdd);
                        ddlComponentTypes.DataBind();
                    }
                    else
                    {
                        ddlComponentTypes.Items.Add(new ListItem("<none>", "0"));
                        lbAddComponent.Enabled = false;
                    }

                    #region Show Custom Fileds for current equipment
                    // getting the custom fields in the DataList control
                    equip.iId = EquipId;
                    dtCustomFieldsFromDB = equip.EquipmentDetail_CustomFields(null);

                    if(dtCustomFieldsFromDB.Rows.Count > 0)
                    {
                        arrCFD = _functions.GetCustomFields(CFDataType.Equipment, Convert.ToInt32(dtCustomFieldsFromDB.Rows[0]["TypeId"]), HttpContext.Current.User.Identity.Name);
                        if(arrCFD.Count > 0)
                        {
                            // fill custom fields
                            for(j = 0; j < arrCFD.Count; j++)
                            {
                                cfd = (clsCustomFieldsDef)arrCFD[j];
                                sTypeName = _functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString();

                                switch(cfd.FieldTypeId)
                                {
                                    case DBFieldType._lookup:
                                    switch(cfd.NameLookupTable)
                                    {
                                        case "EquipModels":
                                            if(dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value)
                                            {
                                                dtCustomFields.Rows.Add(new object []{"Make/Model", ""});
                                            }
                                            else
                                            {
                                                mm = new clsMakesModels();
                                                mm.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                                                mm.iModelId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]);
                                                mm.GetModelMakes();
                                                dtCustomFields.Rows.Add(new object []{"Make/Model", mm.sMakeName + "/" + mm.sModelName});
                                            }
                                            break;
                                        case "Departments":
                                            if(dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value)
                                            {
                                                dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                            }
                                            else
                                            {
                                                dep =  new clsDepartments();
                                                dep.cAction = "S";
                                                dep.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                                                dep.iId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]);
                                                if(dep.DepartmentDetail() == 0)
                                                {
                                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, dep.sName.Value});
                                                }
                                                else
                                                {
                                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                                }
                                            }
                                            break;
                                        case "Locations":
                                            if(dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value)
                                            {
                                                dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                            }
                                            else
                                            {
                                                loc = new clsLocations();
                                                loc.cAction = "S";
                                                loc.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                                                loc.iId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]);
                                                if(loc.LocationDetail() == 0)
                                                {
                                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, loc.sName.Value});
                                                }
                                                else
                                                {
                                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                                }
                                            }
                                            break;
                                        default:
                                            break;
                                    }
                                        break;
                                    case DBFieldType._datetime:
                                        if(dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value)
                                        {
                                            dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                        }
                                        else
                                        {
                                            dtCustomFields.Rows.Add(new object []{cfd.NameText, ((DateTime)dtCustomFieldsFromDB.Rows[0][sTypeName]).ToShortDateString()});
                                        }
                                        break;
                                    case DBFieldType._bit:
                                        if(dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value)
                                        {
                                            dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                        }
                                        else
                                        {
                                            if(((bool)dtCustomFieldsFromDB.Rows[0][sTypeName]) == true)
                                                dtCustomFields.Rows.Add(new object []{cfd.NameText, "Yes"});
                                            else
                                                dtCustomFields.Rows.Add(new object []{cfd.NameText, "No"});
                                        }
                                        break;
                                    default:
                                        if(dtCustomFieldsFromDB.Rows[0][sTypeName] == DBNull.Value)
                                        {
                                            dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                        }
                                        else
                                        {
                                            dtCustomFields.Rows.Add(new object []{cfd.NameText, dtCustomFieldsFromDB.Rows[0][sTypeName]});
                                        }
                                        break;
                                }
                                cfd = null;
                            }

                            // showing a Equipment's data from custom fields
                            repCustomFields.DataSource = new DataView(dtCustomFields);
                            repCustomFields.DataBind();

                            comp.iEquipId = EquipId;
                            comp.iOrgId = OrgId;
                            dtComponents = comp.GetComponentsList();
                            dtComponents.Columns.Add("VisibleLink");
                            foreach(DataRow _row in dtComponents.Rows)
                            {
                                if(bVisibleLink)
                                {
                                    _row["VisibleLink"] = "True";
                                }
                                else
                                {
                                    _row["VisibleLink"] = "False";
                                }
                            }
                            ViewState["Components"] = dtComponents;
                            repComponents.DataSource = new DataView(dtComponents);
                            repComponents.DataBind();
                        }
                        else
                        {
                            Session["lastpage"] = ParentPageURL;
                            Session["error"] = _functions.ErrorMessage(102);
                            Response.Redirect("error.aspx", false);
                        }
                    }
                }
                #endregion
            }
            catch(Exception ex)
            {
                _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
                Session["lastpage"] = ParentPageURL;
                Session["error"] = ex.Message;
                Session["error_report"] = ex.ToString();
                Response.Redirect("error.aspx", false);
            }
            finally
            {
                if(comp != null)
                {
                    comp.Dispose();
                }
                if(loc != null)
                {
                    loc.Dispose();
                }
                if(dep != null)
                {
                    dep.Dispose();
                }
                if(mm != null)
                {
                    mm.Dispose();
                }
                if(comp != null)
                {
                    comp.Dispose();
                }
                if(equip != null)
                {
                    equip.Dispose();
                }
            }
        }
예제 #4
0
        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 = "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
                    }
                    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 = "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
                        }
                    }
                    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();
            }
        }
예제 #5
0
        private void Page_Load(object sender, System.EventArgs e)
        {
            string sTypeName;
            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;
                }
                NextBackControl.BackPage = "wo_addInspections.aspx?id=" + OrderId.ToString();
                NextBackControl.BackVisible = true;
                NextBackControl.NextText = "Open/Finish";

                if(!IsPostBack)
                {
                    hlStart.NavigateUrl = "wo_openWorkOrder.aspx?id=" + OrderId.ToString();
                    hlInspections.NavigateUrl = "wo_addInspections.aspx?id=" + OrderId.ToString();
                    hlIssues.NavigateUrl = "wo_addRepairs.aspx?id=" + OrderId.ToString() + "&back=open";
                    hlPMItems.NavigateUrl = "wo_addPreventiveMaintenance.aspx?id=" + OrderId.ToString() + "&back=preview";

                    dtCustomFields = new DataTable();
                    dtCustomFields.Columns.Add("ValueName");
                    dtCustomFields.Columns.Add("Value");

                    order = new clsWorkOrders();
                    order.cAction = "S";
                    order.iOrgId = OrgId;
                    order.iId = OrderId;
                    if(order.WorkOrderDetails() == -1)
                    {
                        Session["lastpage"] = "wo_addInspections.aspx?id=" + OrderId.ToString();
                        Session["error"] = _functions.ErrorMessage(120);
                        Response.Redirect("error.aspx", false);
                        return;
                    }
                    if(order.iStatusId.Value != (int)WorkOrderStatus.Scheduled ||
                        order.iOperatorStatusId.Value !=(int)WorkOrderOperatorStatus.Checked_In)
                    {
                        Signature.sError = _functions.ErrorMessage(144);
                        NextBackControl.NextEnabled = false;
                    }

                    // showing main info
                    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;
                    lblOperator.Text = order.sOperatorName.Value;
                    lblStaying.Text = order.bStaying.IsNull?"not defined":(order.bStaying.Value?"Yes":"No");
                    lblSpare.Text = order.sSpareEquipId.Value;
                    lblTech.Text = order.sTechName.Value;
                    lblDroppedOffBy.Text = order.sDropedOffBy.Value;
                    lblArrivalDate.Text = order.daArrival.IsNull?"":order.daArrival.Value.ToLongDateString();
                    lblScheduledDate.Text = order.daScheduled.Value.ToLongDateString();

                    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;
                    lblUnits.Text = Convert.ToDouble(order.dmMileage.Value).ToString();

                    // showing issues
                    dsRepairs = order.GetReportedIssueLists();
                    if(dsRepairs.Tables[0].Rows.Count > 0)
                    {
                        html_tblNoneIssues.Visible = false;
                    }
                    else
                    {
                        html_tblNoneIssues.Visible = true;
                    }
                    repIssues.DataSource = new DataView(dsRepairs.Tables[0]);
                    repIssues.DataBind();

                    // showing the pm items
                    dwPMItems = new DataView(order.GetPMServicesListForWorkOrder());
                    dwPMItems.RowFilter = "IsChecked='True'";
                    if(dwPMItems.Count > 0)
                    {
                        html_tblNonePMItems.Visible = false;
                    }
                    else
                    {
                        html_tblNonePMItems.Visible = true;
                    }
                    repPMItems.DataSource = dwPMItems;
                    repPMItems.DataBind();

                    // showing the inspections
                    dwInspections = new DataView(order.GetInspectionsListForWorkOrder());
                    dwInspections.RowFilter = "IsChecked='True'";
                    if(dwInspections.Count > 0)
                    {
                        html_tblNoneInspections.Visible = false;
                    }
                    else
                    {
                        html_tblNoneInspections.Visible = true;
                    }
                    repInspections.DataSource = dwInspections;
                    repInspections.DataBind();

                    // showing notes

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

                    #region Showing custom fields of order on screen
                    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 = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                                                mm.iModelId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]);
                                                mm.GetModelMakes();
                                                dtCustomFields.Rows.Add(new object []{"Make/Model", mm.sMakeName + "/" + mm.sModelName});
                                                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 = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                                                dep.iId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]);
                                                if(dep.DepartmentDetail() == 0)
                                                {
                                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, dep.sName.Value});
                                                }
                                                else
                                                {
                                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                                }
                                                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 = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                                                loc.iId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]);
                                                if(loc.LocationDetail() == 0)
                                                {
                                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, loc.sName.Value});
                                                }
                                                else
                                                {
                                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, ""});
                                                }
                                                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"] = "wo_addInspections.aspx?id=" + OrderId.ToString();
                Session["error"] = ex.Message;
                Session["error_report"] = ex.ToString();
                Response.Redirect("error.aspx", false);
            }
            finally
            {
                if(order != null)
                    order.Dispose();
            }
        }
예제 #6
0
        private void Page_Load(object sender, System.EventArgs e)
        {
            clsCustomFieldsDef cfd = null;
            int j;
            try
            {
                if(Request.QueryString["id"] == null)
                {
                    Session["lastpage"] = "list.aspx";
                    Session["error"] = _functions.ErrorMessage(104);
                    Response.Redirect("error.aspx", false);
                    return;
                }
                try
                {
                    EquipId=Convert.ToInt32(Request.QueryString["id"]);
                }
                catch(FormatException fex)
                {
                    Session["lastpage"] = "list.aspx";
                    Session["error"] = _functions.ErrorMessage(105);
                    Response.Redirect("error.aspx", false);
                    return;
                }

                PageTitle = "Equipment Detail";
                string [,] arrBrdCrumbs = new string [2,2];
                arrBrdCrumbs[0,0]="main.aspx";
                arrBrdCrumbs[0,1]="Home";
                arrBrdCrumbs[1,0]="list.aspx";
                arrBrdCrumbs[1,1]="Equipment List";
                PageTitle = "Equipment Detail";
                Header.BrdCrumbs=ParseBreadCrumbs(arrBrdCrumbs,PageTitle);
                Header.PageTitle=PageTitle;

                if(!IsPostBack)
                {
                    Session["EquipId"] = EquipId;
                    equip = new clsEquipment();
                    comp = new clsComponents();
                    dtCustomFields = new DataTable();
                    dtCustomFields.Columns.Add("ValueName");
                    dtCustomFields.Columns.Add("Value");
                    equip.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                    equip.iId = EquipId;
                    equip.cAction = "S";
                    // getting a fixed fields in the label controls
                    if(equip.EquipmentDetail() == -1)
                    {
                        Session["lastpage"] = ParentPageURL;
                        Session["error"] = _functions.ErrorMessage(102);
                        Response.Redirect("error.aspx", false);
                    }
                    // showing a Equipment's data from fixed fields
                    lbStatus.Text = equip.sStatus.Value;
                    lbPMSched.Text = equip.sPMSched.Value;
                    lbInspection.Text = equip.sInspect.Value;
                    if(!equip.iCurrentUnits.IsNull)
                        lbUnits.Text = equip.iCurrentUnits.Value.ToString();
                    if(!equip.daInService.IsNull)
                        lbDtInService.Text = equip.daInService.Value.ToShortDateString();
                    if(!equip.daAquired.IsNull)
                        lbDtAquired.Text = equip.daAquired.Value.ToShortDateString();
                    lbVchPurOrgContact.Text = equip.sPurOrgContact.Value;
                    if(!equip.curPurAmount.IsNull)
                        lbSmPurAmount.Text = equip.curPurAmount.Value.ToString();
                    if(!equip.iPurUnits.IsNull)
                        lbIntPurUnits.Text = equip.iPurUnits.Value.ToString();
                    lbVchPurNotes.Text = equip.sPurNotes.Value;
                    if(!equip.daOutOfService.IsNull)
                        lbDtOutOfService.Text = equip.daOutOfService.Value.ToShortDateString();
                    if(!equip.daDisposed.IsNull)
                        lbDtDisposed.Text = equip.daDisposed.Value.ToShortDateString();
                    if(!equip.sDispMethod.IsNull)
                        lbVchDispMethod.Text = equip.sDispMethod.Value;
                    if(!equip.sDispOrgContact.IsNull)
                        lbVchDispOrgContact.Text = equip.sDispOrgContact.Value;
                    if(!equip.curDispAmount.IsNull)
                        lbSmDispAmount.Text = equip.curDispAmount.Value.ToString();
                    if(!equip.iDispUnits.IsNull)
                        lbIntDispUnits.Text = equip.iDispUnits.Value.ToString();
                    lbVchDispNotes.Text = equip.sDispNotes.Value;

                    // getting all component's types to dropdownlist
                    comp.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                    ddlComponentTypes.DataTextField = "vchName";
                    ddlComponentTypes.DataValueField = "Id";
                    ddlComponentTypes.DataSource = new DataView(comp.GetComponentTypeList());
                    ddlComponentTypes.DataBind();

                    // getting the fixed fields in the DataList control
                    dtCustomFieldsFromDB = equip.EquipmentDetail_CustomFields(null);
                    dtCustomFields.Rows.Add(new object []{"Type", dtCustomFieldsFromDB.Rows[0]["TypeName"]});

                    // getting the custom fields in the DataList control

                    //arrCFD = _functions.CustomFieldsParse(dtCustomFieldsFromDB, Convert.ToInt32(Session["EquipTypeId"]));
                    arrCFD = _functions.GetCustomFields(false, Convert.ToInt32(Session["EquipTypeId"]), HttpContext.Current.User.Identity.Name);
                    if(arrCFD.Count > 0)
                    {
                        // fill custom fields
                        for(j = 0; j < arrCFD.Count; j++)
                        {
                            cfd = (clsCustomFieldsDef)arrCFD[j];
                            sTypeName = _functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString();

                            switch(cfd.FieldTypeId)
                            {
                                case DBFieldType._lookup:
                                switch(cfd.NameLookupTable)
                                {
                                    case "EquipModels":
                                        mm = new clsMakesModels();
                                        mm.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                                        mm.iModelId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]);
                                        mm.GetModelMakes();
                                        dtCustomFields.Rows.Add(new object []{"Make/Model", mm.sMakeName + "/" + mm.sModelName});
                                        break;
                                    case "Departments":
                                        dep =  new clsDepartments();
                                        dep.cAction = "S";
                                        dep.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                                        dep.iId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]);
                                        if(dep.DepartmentDetail() == 0)
                                        {
                                            dtCustomFields.Rows.Add(new object []{cfd.NameText, dep.sName.Value});
                                        }
                                        break;
                                    case "Locations":
                                        loc = new clsLocations();
                                        loc.cAction = "S";
                                        loc.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                                        loc.iId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][sTypeName]);
                                        if(loc.LocationDetail() == 0)
                                        {
                                            dtCustomFields.Rows.Add(new object []{cfd.NameText, loc.sName.Value});
                                        }
                                        break;
                                    default:
                                        break;
                                }
                                    break;
                                case DBFieldType._datetime:
                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, ((DateTime)dtCustomFieldsFromDB.Rows[0][sTypeName]).ToShortDateString()});
                                    break;
                                case DBFieldType._bit:
                                    if(((bool)dtCustomFieldsFromDB.Rows[0][sTypeName]) == true)
                                        dtCustomFields.Rows.Add(new object []{cfd.NameText, "Yes"});
                                    else
                                        dtCustomFields.Rows.Add(new object []{cfd.NameText, "No"});
                                    break;
                                default:
                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, dtCustomFieldsFromDB.Rows[0][sTypeName]});
                                    break;
                            }

                            cfd = null;
                        }

                        // showing a Equipment's data from custom fields
                        repCustomFields.DataSource = new DataView(dtCustomFields);
                        repCustomFields.DataBind();

                        comp.iEquipId = EquipId;
                        comp.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                        dtComponents = comp.GetComponentsList();
                        ViewState["Components"] = dtComponents;
                        repComponents.DataSource = new DataView(dtComponents);
                        repComponents.DataBind();
                    }
                    else
                    {
                        Session["lastpage"] = ParentPageURL;
                        Session["error"] = _functions.ErrorMessage(102);
                        Response.Redirect("error.aspx", false);
                    }
                }
            }
            catch(Exception ex)
            {
                _functions.Log("Application error: \n" + ex.ToString());
                Session["lastpage"] = ParentPageURL;
                Session["error"] = ex.Message;
                Session["error_report"] = ex.ToString();
                Response.Redirect("error.aspx", false);
            }
            finally
            {
                if(comp != null)
                {
                    comp.Dispose();
                }
                if(loc != null)
                {
                    loc.Dispose();
                }
                if(dep != null)
                {
                    dep.Dispose();
                }
                if(mm != null)
                {
                    mm.Dispose();
                }
                if(comp != null)
                {
                    comp.Dispose();
                }
                if(equip != null)
                {
                    equip.Dispose();
                }
            }
        }
예제 #7
0
        private void Page_Load(object sender, System.EventArgs e)
        {
            try
            {
                if(Request.QueryString["id"] == null)
                {
                    Session["lastpage"] = "list.aspx";
                    Session["error"] = _functions.ErrorMessage(104);
                    Response.Redirect("error.aspx", false);
                    return;
                }
                try
                {
                    EquipId=Convert.ToInt32(Request.QueryString["id"]);
                }
                catch(FormatException fex)
                {
                    Session["lastpage"] = "list.aspx";
                    Session["error"] = _functions.ErrorMessage(105);
                    Response.Redirect("error.aspx", false);
                    return;
                }

                PageTitle = "Reassign Equipment";
                string [,] arrBrdCrumbs = new string [3,2];
                arrBrdCrumbs[0,0]="main.aspx";
                arrBrdCrumbs[0,1]="Home";
                arrBrdCrumbs[1,0]="list.aspx";
                arrBrdCrumbs[1,1]="Equipment List";
                arrBrdCrumbs[2,0]="view.aspx?id="+EquipId;
                arrBrdCrumbs[2,1]="Equipment Detail";
                Header.BrdCrumbs=ParseBreadCrumbs(arrBrdCrumbs,PageTitle);
                Header.PageTitle="Reassign Equipment";
                SaveCancelControl.ParentPageURL=ParentPageURL;

                if(!IsPostBack)
                {
                    ViewState["EquipId"] = EquipId;

                    equip = new clsEquipment();
                    dtCustomFields = new DataTable();
                    dtCustomFields.Columns.Add("ValueName");
                    dtCustomFields.Columns.Add("Value");

                    equip.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                    equip.iId = EquipId;
                    equip.cAction = "S";

                    dtUsers = equip.GetEquipAssignTo();
                    if(dtUsers.Rows.Count < 1)
                    {
                        Session["lastpage"] = ParentPageURL;
                        Session["error"] = _functions.ErrorMessage(111);
                        Response.Redirect("error.aspx", false);
                        return;
                    }
                    ddAssignTo.DataTextField = "vchName";
                    ddAssignTo.DataValueField = "id";
                    ddAssignTo.DataSource = new DataView(dtUsers);
                    ddAssignTo.DataBind();
                    ddAssignTo.Items.Insert(0, "");

                    // getting equipment's data
                    dtCustomFieldsFromDB = equip.EquipmentDetail_CustomFields(null);

                    if(dtCustomFieldsFromDB.Rows.Count > 0)
                    {

                        if(dtCustomFieldsFromDB.Rows[0]["UserName"] == DBNull.Value)
                            lbAssignFrom.Text = "";
                        else
                            lbAssignFrom.Text = dtCustomFieldsFromDB.Rows[0]["UserName"].ToString();

                        dtCustomFields.Rows.Add(new object []{"Type", dtCustomFieldsFromDB.Rows[0]["TypeName"]});

                        // getting the custom fields in the DataList control
                        arrCFD = _functions.GetCustomFields(false, Convert.ToInt32(Session["EquipTypeId"]), HttpContext.Current.User.Identity.Name);
                        if(arrCFD.Count > 0)
                        {
                            // fill custom fields
                            for(int j = 0; j < arrCFD.Count; j++)
                            {
                                cfd = (clsCustomFieldsDef)arrCFD[j];
                                if(cfd.FieldTypeId == DBFieldType._lookup)
                                {
                                    switch(cfd.NameLookupTable)
                                    {
                                        case "EquipModels":
                                            mm = new clsMakesModels();
                                            mm.iOrgId = 1; // later change
                                            mm.iModelId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][_functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString()]);
                                            mm.GetModelMakes();
                                            dtCustomFields.Rows.Add(new object []{"Make/Model", mm.sMakeName + "/" + mm.sModelName});
                                            break;
                                        case "Departments":
                                            dep =  new clsDepartments();
                                            dep.cAction = "S";
                                            dep.iOrgId = 1;
                                            dep.iId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][_functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString()]);
                                            if(dep.DepartmentDetail() == 0)
                                            {
                                                dtCustomFields.Rows.Add(new object []{cfd.NameText, dep.sName.Value});
                                            }
                                            break;
                                        case "Locations":
                                            loc = new clsLocations();
                                            loc.cAction = "S";
                                            loc.iOrgId = 1;
                                            loc.iId = Convert.ToInt32(dtCustomFieldsFromDB.Rows[0][_functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString()]);
                                            if(loc.LocationDetail() == 0)
                                            {
                                                dtCustomFields.Rows.Add(new object []{cfd.NameText, loc.sName.Value});
                                            }
                                            break;
                                        default:
                                            break;
                                    }
                                }
                                else
                                {
                                    dtCustomFields.Rows.Add(new object []{cfd.NameText, dtCustomFieldsFromDB.Rows[0][_functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString()]});
                                }
                                cfd = null;
                            }
                            repCustomFields.DataSource = new DataView(dtCustomFields);
                            repCustomFields.DataBind();
                        }
                        else
                        {
                            Session["lastpage"] = ParentPageURL;
                            Session["error"] = _functions.ErrorMessage(102);
                            Response.Redirect("error.aspx", false);
                        }
                    }
                    else
                    {
                        Session["lastpage"] = ParentPageURL;
                        Session["error"] = _functions.ErrorMessage(102);
                        Response.Redirect("error.aspx", false);
                    }
                }
            }
            catch(Exception ex)
            {
                _functions.Log("Application error: \n" + ex.ToString());
                Session["lastpage"] = ParentPageURL;
                Session["error"] = ex.Message;
                Session["error_report"] = ex.ToString();
                Response.Redirect("error.aspx", false);
            }
            finally
            {
                if(loc != null)
                {
                    loc.Dispose();
                }
                if(dep != null)
                {
                    dep.Dispose();
                }
                if(mm != null)
                {
                    mm.Dispose();
                }
                if(equip != null)
                {
                    equip.Dispose();
                }
            }
        }
예제 #8
0
        private void ShowList()
        {
            int i, j;
            clsCustomFieldsDef cfd = null;
            string sTypeName;
            try
            {
                dgMainList.Controls.Clear();

                dtResult = new DataTable("Result");

                dtData = equip.GetEquipList();

                if(dtData.Rows.Count > 0)
                {
                    //arrCFD = _functions.CustomFieldsParse(dtData, Convert.ToInt32(Session["EquipTypeId"]));
                    arrCFD = _functions.GetCustomFields(false, equip.iTypeId.Value, HttpContext.Current.User.Identity.Name);

                    if(arrCFD.Count > 0)
                    {
                        // adding fixed fields
                        dtResult.Columns.Add("id");

                        // adding variable columns and fields
                        for(i = 0; i < arrCFD.Count; i++)
                        {
                            cfd = (clsCustomFieldsDef)arrCFD[i];
                            dtResult.Columns.Add(cfd.Name);
                            _column = new BoundColumn();
                            _column.DataField = cfd.Name;
                            _column.HeaderText = cfd.NameText;
                            dgMainList.Columns.Add( _column);
                            if(cfd.NameLookupTable == "EquipModels") // adding make column if model is exist
                            {
                                _column = null;
                                _column = new BoundColumn();
                                dtResult.Columns.Add("MakeName");
                                _column.DataField = "MakeName";
                                _column.HeaderText = "Make";
                                dgMainList.Columns.Add( _column);
                            }
                            cfd = null;
                            _column = null;
                        }
                        // fill fields
                        for(i=0; i< dtData.Rows.Count; i++)
                        {
                            // fill fixed fields
                            drItem = dtResult.NewRow();
                            drItem["Id"] = dtData.Rows[i]["Id"];

                            // fill variable fields
                            for(j = 0; j < arrCFD.Count; j++)
                            {
                                cfd = (clsCustomFieldsDef)arrCFD[j];
                                sTypeName = _functions.GetFieldTypeText(cfd.FieldTypeId) + cfd.NumberColumn.ToString();
                                switch(cfd.FieldTypeId)
                                {
                                    case DBFieldType._lookup:
                                        switch(cfd.NameLookupTable)
                                        {
                                            case "EquipModels":
                                                mm = new clsMakesModels();
                                                mm.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                                                mm.iModelId = Convert.ToInt32(dtData.Rows[i][sTypeName]);
                                                mm.GetModelMakes();
                                                drItem[cfd.Name] = mm.sModelName;
                                                drItem["MakeName"] = mm.sMakeName;
                                                break;
                                            case "Departments":
                                                dep = new clsDepartments();
                                                dep.cAction = "S";
                                                dep.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                                                dep.iId = Convert.ToInt32(dtData.Rows[i][sTypeName]);
                                                if(dep.DepartmentDetail() == 0)
                                                {
                                                    drItem[cfd.Name] = dep.sName.Value;
                                                }
                                                break;
                                            case "Locations":
                                                loc = new clsLocations();
                                                loc.cAction = "S";
                                                loc.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
                                                loc.iId = Convert.ToInt32(dtData.Rows[i][sTypeName]);
                                                if(loc.LocationDetail() == 0)
                                                {
                                                    drItem[cfd.Name] = loc.sName.Value;
                                                }
                                                break;
                                            default:
                                                break;
                                        }
                                        break;
                                    case DBFieldType._bit:
                                        if(((bool)dtData.Rows[i][sTypeName]) == true)
                                            drItem[cfd.Name] = "Yes";
                                        else
                                            drItem[cfd.Name] = "No";
                                        break;
                                    default:
                                        drItem[cfd.Name] = dtData.Rows[i][sTypeName];
                                        break;
                                }
                                cfd = null;
                            }
                            dtResult.Rows.Add(drItem);
                        }
                    }
                    else
                    {
                        Session["lastpage"] = ParentPageURL;
                        Session["error"] = _functions.ErrorMessage(102);
                        Response.Redirect("error.aspx", false);
                    }
                }
                dgMainList.DataSource = new DataView(dtResult);
                dgMainList.DataBind();

            }
            catch(Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                if(dtData != null)
                {
                    dtData.Dispose();
                }
                if(loc != null)
                {
                    loc.Dispose();
                }
                if(dep != null)
                {
                    dep.Dispose();
                }
                if(mm != null)
                {
                    mm.Dispose();
                }
            }
        }