public IList <INVStore_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression)
{
IList <INVStore_DetailedEntity> iNVStore_DetailedEntityList = new List <INVStore_DetailedEntity>();
try
{
if (String.IsNullOrEmpty(sortExpression))
{
sortExpression = "StoreID";
}
Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1;
//startRowIndex = Convert.ToInt32( startRowIndex / pageSize) + 1;
if (pageSize == -1)
{
pageSize = 1000000000;
}
iNVStore_DetailedEntityList = FCCINVStore_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression);
if (iNVStore_DetailedEntityList != null && iNVStore_DetailedEntityList.Count > 0)
{
totalRowCount = iNVStore_DetailedEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(iNVStore_DetailedEntityList ?? new List <INVStore_DetailedEntity>());
}
public static IList <INVStore_DetailedEntity> GetAllStoresDetailed(Int32 pageSize, Int32 currentPage, String sortExpression, String filterExpression)
{
IList <INVStore_DetailedEntity> lst = new List <INVStore_DetailedEntity>();
try
{
lst = FCCINVStore_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression);
}
catch (Exception ex)
{
}
return(lst);
}
public static IList <INVStore_DetailedEntity> GetAllStoresDetailed()
{
IList <INVStore_DetailedEntity> lst = new List <INVStore_DetailedEntity>();
try
{
lst = FCCINVStore_Detailed.GetFacadeCreate().GetIL(1000000000, 1, String.Empty, String.Empty);
}
catch (Exception ex)
{
}
return(lst);
}
public static INVStore_DetailedEntity GetStoreDetailedByID(Int64 storeID)
{
INVStore_DetailedEntity ent = new INVStore_DetailedEntity();
try
{
IList <INVStore_DetailedEntity> lst = new List <INVStore_DetailedEntity>();
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression("INVStore." + INVStore_DetailedEntity.FLD_NAME_StoreID, storeID.ToString(), SQLMatchType.Equal);
lst = FCCINVStore_Detailed.GetFacadeCreate().GetIL(1, 1, String.Empty, filterExpression);
if (lst != null && lst.Count > 0)
{
ent = lst[0];
}
}
catch (Exception ex)
{
}
return(ent);
}
