예제 #1
0
        public IQueryable <tbl_Project> GetSearchedProjects(string searchField, string searchString, string searchOper)
        {
            var predicate = PredicateExtensions.True <tbl_Project>();

            switch (searchField)
            {
            case "ID":
                if (searchOper == "bw")
                {
                    predicate = predicate.And(p => p.Project_ID.ToString().StartsWith(searchString));
                }
                if (searchOper == "eq")
                {
                    predicate = predicate.And(p => p.Project_ID == int.Parse(searchString));
                }
                if (searchOper == "cn")
                {
                    predicate = predicate.And(p => p.Project_ID.ToString().Contains(searchString));
                }
                break;

            case "Project_Number":
                if (searchOper == "bw")
                {
                    predicate = predicate.And(p => p.Project_Number.ToString().StartsWith(searchString));
                }
                if (searchOper == "eq")
                {
                    predicate = predicate.And(p => p.Project_Number == int.Parse(searchString));
                }
                if (searchOper == "cn")
                {
                    predicate = predicate.And(p => p.Project_Number.ToString().Contains(searchString));
                }
                break;

            case "SAP_Number":
                if (searchOper == "bw")
                {
                    predicate = predicate.And(p => p.SAP_Number.StartsWith(searchString));
                }
                if (searchOper == "eq")
                {
                    predicate = predicate.And(p => p.SAP_Number == searchString);
                }
                if (searchOper == "cn")
                {
                    predicate = predicate.And(p => p.SAP_Number.ToString().Contains(searchString));
                }
                break;

            case "WBS":
                if (searchOper == "bw")
                {
                    predicate = predicate.And(p => p.WBS.StartsWith(searchString));
                }
                if (searchOper == "eq")
                {
                    predicate = predicate.And(p => p.WBS == searchString);
                }
                if (searchOper == "cn")
                {
                    predicate = predicate.And(p => p.WBS.ToString().Contains(searchString));
                }

                break;

            case "Project_Name":
                if (searchOper == "bw")
                {
                    predicate = predicate.And(p => p.Project_Name.StartsWith(searchString));
                }
                if (searchOper == "eq")
                {
                    predicate = predicate.And(p => p.Project_Name == searchString);
                }
                if (searchOper == "cn")
                {
                    predicate = predicate.And(p => p.Project_Name.ToString().Contains(searchString));
                }
                break;

            case "Status":
                if (searchOper == "bw")
                {
                    predicate = predicate.And(p => p.tbl_Status.Status.StartsWith(searchString));
                }
                if (searchOper == "eq")
                {
                    predicate = predicate.And(p => p.tbl_Status.Status == searchString);
                }
                if (searchOper == "cn")
                {
                    predicate = predicate.And(p => p.tbl_Status.Status.Contains(searchString));
                }
                break;
            }
            return(db.tbl_Projects.Where(predicate));
        }
예제 #2
0
        public IQueryable <tbl_User> GetSearchedUsers(string searchField, string searchString, string searchOper)
        {
            var predicate = PredicateExtensions.True <tbl_User>();

            switch (searchField)
            {
            case "User_CAI":
                if (searchOper == "bw")
                {
                    predicate = predicate.And(p => p.User_CAI.ToString().StartsWith(searchString));
                }
                if (searchOper == "eq")
                {
                    predicate = predicate.And(p => p.User_CAI == searchString);
                }
                if (searchOper == "cn")
                {
                    predicate = predicate.And(p => p.User_CAI.ToString().Contains(searchString));
                }
                break;

            case "User_FirstName":
                if (searchOper == "bw")
                {
                    predicate = predicate.And(p => p.User_FirstName.ToString().StartsWith(searchString));
                }
                if (searchOper == "eq")
                {
                    predicate = predicate.And(p => p.User_FirstName == searchString);
                }
                if (searchOper == "cn")
                {
                    predicate = predicate.And(p => p.User_FirstName.ToString().Contains(searchString));
                }
                break;

            case "User_LastName":
                if (searchOper == "bw")
                {
                    predicate = predicate.And(p => p.User_LastName.StartsWith(searchString));
                }
                if (searchOper == "eq")
                {
                    predicate = predicate.And(p => p.User_LastName == searchString);
                }
                if (searchOper == "cn")
                {
                    predicate = predicate.And(p => p.User_LastName.ToString().Contains(searchString));
                }
                break;

            case "User_Role":
                if (searchOper == "bw")
                {
                    predicate = predicate.And(p => p.tbl_User_Role.User_Role_Descr.StartsWith(searchString));
                }
                if (searchOper == "eq")
                {
                    predicate = predicate.And(p => p.tbl_User_Role.User_Role_Descr == searchString);
                }
                if (searchOper == "cn")
                {
                    predicate = predicate.And(p => p.tbl_User_Role.User_Role_Descr.ToString().Contains(searchString));
                }
                break;
            }
            return(db.tbl_Users.Where(predicate));
        }