private void BindGridViewDegree(string search)
        {
            FiltersModel fm = Session["FiltersModel"] as FiltersModel;
            List <HR_Emp_Qualification> _View     = new List <HR_Emp_Qualification>();
            List <HR_Emp_Qualification> _TempView = new List <HR_Emp_Qualification>();
            ViewUserEmp  LoggedInUser             = HttpContext.Current.Session["LoggedUser"] as ViewUserEmp;
            QueryBuilder qb    = new QueryBuilder();
            string       query = qb.QueryForReportsDepartment(LoggedInUser);
            DataTable    dt    = new DataTable();

            if (query != "where")
            {
                dt = qb.GetValuesfromDB("select distinct Degree from HR_Emp_Qualification where isnull(Deleted,0)=0 and isnull(Degree,'') <> ''");
            }
            _View = dt.ToList <HR_Emp_Qualification>();
            GridViewDegree.DataSource = _View.Where(aa => aa.Degree.ToUpper().Contains(search.ToUpper())).OrderBy(aa => aa.Degree).ToList();
            GridViewDegree.DataBind();
        }
Exemple #2
0
        /// <summary>
        /// If there is an existing PI in the request, the pop-out form will populate with
        /// the PI information already stored into the database.
        ///
        /// Otherwise, a brand new, blank form will be presented to the user.
        /// </summary>
        /// <param name="piId"></param>
        private void BindControl(string piId)
        {
            using (ProjectTrackerContainer db = new ProjectTrackerContainer())
            {
                IDictionary <int, string> dropDownSource = new Dictionary <int, string>();

                int id = 0;
                Int32.TryParse(piId, out id);

                if (id > 0)
                {
                    var query1 = db.Invests
                                 .Join(db.InvestStatus, i => i.InvestStatusId, s => s.Id,
                                       (i, s) => new { i.Id, i.FirstName, i.LastName, i.Email, i.Phone, s.StatusValue })
                                 .Where(d => d.Id == id)
                                 .OrderBy(d => d.Id);

                    //GridView1.DataSource = query1.ToList();
                    //GridView1.DataBind();

                    rptPI.DataSource = query1.ToList();
                    rptPI.DataBind();
                }
                else
                {
                    var query = db.Invests
                                .Join(db.InvestStatus, i => i.InvestStatusId, s => s.Id,
                                      (i, s) => new { i.Id, i.FirstName, i.LastName, i.Email, i.Phone, s.StatusValue })
                                .Where(d => d.Id > 0)
                                .OrderBy(d => d.Id);

                    //GridView1.DataSource = query.ToList();
                    //GridView1.DataBind();

                    rptPI.DataSource = query.ToList();
                    rptPI.DataBind();
                }

                var statusQuery = db.InvestStatus
                                  .OrderBy(d => d.DisplayOrder);

                ddlStatus.DataSource     = statusQuery.ToList();
                ddlStatus.DataValueField = "Id";
                ddlStatus.DataTextField  = "StatusValue";

                ddlStatus.DataBind();

                //uhfaculty
                var uhfacultyQuery = db.JabsomAffils
                                     .Where(d => d.Type == "UHFaculty")
                                     .OrderBy(d => d.Id);

                ddlUHFaculty.DataSource     = uhfacultyQuery.ToList();
                ddlUHFaculty.DataValueField = "Id";
                ddlUHFaculty.DataTextField  = "Name";
                ddlUHFaculty.DataBind();
                ddlUHFaculty.Items.Insert(0, new ListItem(String.Empty, String.Empty));

                //degree
                var queryDegree = db.JabsomAffils
                                  .Where(d => d.Type == "Degree");

                GridViewDegree.DataSource = queryDegree.ToList();
                GridViewDegree.DataBind();

                //department
                var queryDept = db.JabsomAffils
                                .Where(d => d.Type == "Department");

                GridViewDept.DataSource = queryDept.ToList();
                GridViewDept.DataBind();

                var queryOffice = db.JabsomAffils
                                  .Where(d => d.Type == "Office");

                GridViewOffice.DataSource = queryOffice.ToList();
                GridViewOffice.DataBind();

                //ddlJabsomOther
                dropDownSource = db.JabsomAffils
                                 .Where(d => d.Type == "College")
                                 .ToDictionary(c => c.Id, c => c.Name);

                PageUtility.BindDropDownList(ddlJabsomOther, dropDownSource, string.Empty);

                var queryUHDept = db.JabsomAffils
                                  .Where(d => d.Type == "UHSchool");

                GridViewUHDept.DataSource = queryUHDept.ToList();
                GridViewUHDept.DataBind();

                //GridViewCommunityCollege
                var queryCommunityCollege = db.JabsomAffils
                                            .Where(d => d.Type == "CommunityCollege");

                GridViewCommunityCollege.DataSource = queryCommunityCollege.ToList();
                GridViewCommunityCollege.DataBind();

                //GridViewCommunityPartner
                var queryCommunityPartner = db.JabsomAffils
                                            .Where(d => d.Type == "CommunityPartner");

                GridViewCommunityPartner.DataSource = queryCommunityPartner.ToList();
                GridViewCommunityPartner.DataBind();

                //ddlHospital
                dropDownSource = db.JabsomAffils
                                 .Where(d => d.Type == "MajorHospital")
                                 .ToDictionary(c => c.Id, c => c.Name);

                //PageUtility.BindDropDownList(ddlHospital, dropDownSource, String.Empty);

                ////GridViewHph
                //var queryHph = db.JabsomAffils
                //               .Where(d => d.Type == "HawaiiPacificHealth");

                //GridViewHph.DataSource = queryHph.ToList();
                //GridViewHph.DataBind();

                //GridViewNonUH
                var queryNonUH = db.JabsomAffils
                                 .Where(d => d.Type == "MajorHospital");

                GridViewNonUH.DataSource = queryNonUH.ToList();
                GridViewNonUH.DataBind();

                //if (!Page.User.IsInRole("Admin"))
                //{
                //    btnAdd.Visible = false;
                //    btnSave.Visible = false;
                //}

                //var principleI = db.Invests.Where(i => i.Id > 0)
                //                .Select(x => new { FullName = x.FirstName + " " + x.LastName });
                //textAreaPI.Value = Newtonsoft.Json.JsonConvert.SerializeObject(principleI);
            }
        }