public BECategorys GetCategorys(SQLHelper sqlHelper, int startIndex, int maxRows, string categoryName)
{
string sql = string.Empty;
string subQuery = string.Empty;
int startRow = (startIndex - 1) * maxRows + 1;
int endRow = startIndex + maxRows - 1;
BECategorys Categorys = new BECategorys();
try
{
subQuery = GetSubQuery(sqlHelper, categoryName);
sql = sqlHelper.MakeSQL(@"SELECT * FROM TblCategory WHERE IsDeleted=$b $q ORDER BY CATEGORYID", false, subQuery);
if (maxRows > 0)
{
sql = DBUtility.GetPagingSQL(sql, startRow, endRow);
}
IDataReader reader = sqlHelper.ExecuteQuery(sql);
AddToCategoryCollection(Categorys, reader);
reader.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(Categorys);
}
public BECategory GetCategory(SQLHelper sqlHelper, int categoryId)
{
string sql = string.Empty;
BECategorys categorys = new BECategorys();
try
{
sql = sqlHelper.MakeSQL(@"SELECT * FROM TblCategory WHERE CategoryId =$n ORDER BY Code, CategoryName", categoryId);
IDataReader reader = sqlHelper.ExecuteQuery(sql);
AddToCategoryCollection(categorys, reader);
reader.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
if (categorys.Count > 0)
{
return(categorys[0]);
}
else
{
return(new BECategory());
}
}
public int GetCategorysCount(SQLHelper sqlHelper, string categoryName)
{
string sql = string.Empty;
string subQuery = string.Empty;
BECategorys Categorys = new BECategorys();
int rowCount = 0;
try
{
subQuery = GetSubQuery(sqlHelper, categoryName);
sql = sqlHelper.MakeSQL("SELECT COUNT(CATEGORYID) FROM TblCategory WHERE IsDeleted=$b $q", false, subQuery);
IDataReader reader = sqlHelper.ExecuteQuery(sql);
if (reader.Read())
{
rowCount = Convert.ToInt32(reader[0].ToString());
}
reader.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(rowCount);
}
private BECategorys AddToCategoryCollection(BECategorys categorys, IDataReader reader)
{
NULLHandler nullHandler = new NULLHandler(reader);
while (reader.Read())
{
categorys.Add(PreaperCategoryObject(nullHandler));
}
return(categorys);
}
public BECategorys GetCategorys(int startIndex, int maxRows, string categoryName)
{
try
{
BECategorys categorys = null;
sqlHelper = new SQLHelper();
categorys = daCategory.GetCategorys(sqlHelper, startIndex, maxRows, categoryName);
sqlHelper.CommitTran();
return(categorys);
}
catch (Exception ex)
{
RnD.BLTemp.Common.Utility.SaveErrorLog(this.GetType().ToString(), "", ex);
if (sqlHelper != null)
{
sqlHelper.Rollback();
}
throw ex;
}
}
