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