public static IEnumerable <VaaaN.MLFF.Libraries.CommonLibrary.CBE.UserCBE> GetAll(VaaaN.MLFF.Libraries.CommonLibrary.Common.SortingPagingInfo info, ref Int32 RecordCount)
{
IEnumerable <VaaaN.MLFF.Libraries.CommonLibrary.CBE.UserCBE> users;
try
{
string spName = Constants.oraclePackagePrefix + "USER_GETALL_PAGING";
DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName);
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_PAGE_INDEX", DbType.Int32, info.CurrentPageIndex, ParameterDirection.Input));
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_PAGE_SIZE", DbType.Int32, info.PageSize, ParameterDirection.Input));
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_SEARCH_TEXT", DbType.String, info.SearchText, ParameterDirection.Input));
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_RECORD_COUNT", DbType.Int32, info.RecordCount, ParameterDirection.Output));
DataTable dt = (VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName).Tables[tableName]);
users = ConvertTableToIEnurable(dt);
RecordCount = dt.Rows.Count;//Convert.ToInt32(command.Parameters["P_RECORD_COUNT"].Value);
}
catch (Exception ex)
{
throw ex;
}
return(users);
}
public static IEnumerable <VaaaN.MLFF.Libraries.CommonLibrary.CBE.RoleCBE> GetRoleList(VaaaN.MLFF.Libraries.CommonLibrary.Common.SortingPagingInfo info, ref Int32 RecordCount)
{
return(VaaaN.MLFF.Libraries.CommonLibrary.DAL.RoleDAL.GetRoleList(info, ref RecordCount));
}
public static IEnumerable <VaaaN.MLFF.Libraries.CommonLibrary.CBE.UserCBE> GetAll(VaaaN.MLFF.Libraries.CommonLibrary.Common.SortingPagingInfo info, ref Int32 RecordCount)
{
return(VaaaN.MLFF.Libraries.CommonLibrary.DAL.UserDAL.GetAll(info, ref RecordCount));
}
