public List <TB_USERS> GetAllBy(object param)
{
List <TB_USERS> list = new List <TB_USERS>();
list = new TB_USERSSql().SelectFromStore(AppSettingKeys.SP_GET_ALL_USER_BY, param);
return(list);
}
public List <TB_USERS> GetAllBy(string keyText, string status, string scheduleId, string type, int pageNumber, int pageSize, out int count)
{
object cTemp;
List <TB_USERS> list = new List <TB_USERS>();
list = new TB_USERSSql().SelectFromStoreOutParam(AppSettingKeys.GET_ALL_USER_BY, out cTemp, keyText, status, scheduleId, type, pageNumber, pageSize);
count = (int)cTemp;
return(list);
}
// LAY DANH SACH THONG TIN HOC SINH CUA 1 LOP HOC
public List <TB_USERS> GetStudiesBySchedule(string scheduleId, int pageNumber, int pageSize, out int count)
{
object cTemp;
List <TB_USERS> list = new List <TB_USERS>();
list = new TB_USERSSql().SelectFromStoreOutParam(AppSettingKeys.GET_STUDIES_BY_SCHEDULES, out cTemp, scheduleId, pageNumber, pageSize);
count = (int)cTemp;
return(list);
}
public List <TB_USERS> GetAllByOutCount(object param, out int count)
{
object cTemp;
List <TB_USERS> list = new List <TB_USERS>();
list = new TB_USERSSql().SelectFromStoreOutParam(AppSettingKeys.SP_GET_ALL_USER_BY, out cTemp, param);
count = (int)cTemp;
return(list);
}
// login vao webclient
public V_INFO_LOGIN_CLIENT CheckLogin(string userName, string passWord, string type)
{
string ecode, edesc;
List <TB_USERS> list = new List <TB_USERS>();
list = new TB_USERSSql().SelectFromStoreOutEcode(out ecode, out edesc, AppSettingKeys.CHECK_LOGIN_CLIENT, userName, passWord, type);
if (list == null)
{
list = new List <TB_USERS>();
}
V_INFO_LOGIN_CLIENT result = new V_INFO_LOGIN_CLIENT();
result = list.Select(x => new V_INFO_LOGIN_CLIENT
{
ecode = ecode,
edesc = edesc,
user = list.FirstOrDefault()
}).FirstOrDefault();
return(result);
}
