Ejemplo n.º 1
0
        public static UserInfoCollection Search(SearchFilter SearchKey)
        {
            UserInfoCollection collection = new UserInfoCollection();

            using (var reader = SqlHelper.ExecuteReader("UserInfo_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
            {
                while (reader.Read())
                {
                    UserInfo obj = new UserInfo();
                    obj = GetItemFromReader(reader);
                    obj.userLogin.Password = "******";
                    collection.Add(obj);
                }
            }
            return(collection);
        }
Ejemplo n.º 2
0
        public static UserInfoCollection GetbyUser(string CreatedUser, int CompanyID)
        {
            UserInfoCollection collection = new UserInfoCollection();
            UserInfo           obj;
            var sqlParams = new SqlParameter[]
            {
                new SqlParameter("@CreatedUser", CreatedUser),
                new SqlParameter("@CompanyID", CompanyID),
            };

            using (var reader = SqlHelper.ExecuteReader("tblUserInfo_GetAll_byUser", sqlParams))
            {
                while (reader.Read())
                {
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }
Ejemplo n.º 3
0
        public static UserInfoCollection GetItembyEmpCD(int CompanyID, string EmpCD)
        {
            UserInfoCollection collection = new UserInfoCollection();

            var sqlParams = new SqlParameter[]
            {
                new SqlParameter("@CompanyID", CompanyID),
                new SqlParameter("@EmpCD", EmpCD),
            };

            using (var reader = SqlHelper.ExecuteReader("tblUserInfo_GetbyEmpCD", sqlParams))
            {
                while (reader.Read())
                {
                    UserInfo obj = new UserInfo();
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }