예제 #1
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;
                SourcePageName = "reassign.aspx.cs";
                if (!IsPostBack)
                {
                    equip = new clsEquipment();

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

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

                    // getting equipment's data
                    if (equip.EquipmentDetail() != 0)
                    {
                        Session["lastpage"] = ParentPageURL;
                        Session["error"]    = _functions.ErrorMessage(102);
                        Response.Redirect("error.aspx", false);
                        return;
                    }
                    lblEquipment.Text  = equip.sEquipId.Value;
                    lblType.Text       = equip.sType.Value;
                    lblMakeModel.Text  = equip.sMakeModelName.Value;
                    lblYear.Text       = equip.iYear.Value.ToString();
                    lblSerial.Text     = equip.sVinSerial.Value;
                    lblFuelCode.Text   = equip.sFuelCode.Value;
                    lblDepartment.Text = equip.sDeptName.Value;
                    lblLocation.Text   = equip.sLocName.Value;
                    lblShare.Text      = equip.bShare.Value?"Yes":"No";
                    lbAssignFrom.Text  = equip.sAssignedTo.Value;
                }
            }
            catch (Exception ex)
            {
                _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
                Session["lastpage"]     = ParentPageURL;
                Session["error"]        = ex.Message;
                Session["error_report"] = ex.ToString();
                Response.Redirect("error.aspx", false);
            }
            finally
            {
                if (loc != null)
                {
                    loc.Dispose();
                }
                if (dep != null)
                {
                    dep.Dispose();
                }
                if (mm != null)
                {
                    mm.Dispose();
                }
                if (equip != null)
                {
                    equip.Dispose();
                }
            }
        }
예제 #2
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();
                }
            }
        }