public TRClass GetTRClassByKey(System.Int64 classId, string regionCode)
{
TRClass.CleanError();
using (Database dbObj = Utils.GetMainDB())
{
using (IDataReader rs = dbObj.RunSPReturnRS("dbo._TRClass_GetAll",
new SqlParameter("@Filter", "ClassId = " + classId.ToString() + " AND RegionCode = '" + regionCode + "'"),
new SqlParameter("@Company", SessionState.CompanyName)))
{
if (dbObj.LastError != null && dbObj.LastError.Length == 0)
{
HyperCatalog.DataAccessLayer.SqlDataAccessLayer.GenerateCollectionFromReader col = new HyperCatalog.DataAccessLayer.SqlDataAccessLayer.GenerateCollectionFromReader(GenerateTRClassCollectionFromReader);
TRClassList objCol = (TRClassList)col(rs);
rs.Close();
if (objCol.Count > 0)
{
return(objCol[0]);
}
else
{
return(null);
}
}
else
{
throw new DataException("SQLDataAccessLayer: GetTRClassByKey-> " + dbObj.LastError);
}
}
}
}
//Added by venkata 07-10-16
public TRClassList GetAllTRClass(string filter)
{
using (Database dbObj = Utils.GetMainDB())
{
using (IDataReader rs = dbObj.RunSPReturnRS("_TRClass_GetAll",
new SqlParameter("@Filter", filter),
new SqlParameter("@Company", SessionState.CompanyName)))
{
if (dbObj.LastError != null && dbObj.LastError.Length == 0)
{
HyperCatalog.DataAccessLayer.SqlDataAccessLayer.GenerateCollectionFromReader col = new HyperCatalog.DataAccessLayer.SqlDataAccessLayer.GenerateCollectionFromReader(GenerateTRClassCollectionFromReader);
TRClassList objCol = (TRClassList)col(rs);
rs.Close();
return(objCol);
}
else
{
throw new DataException("SQLDataAccessLayer: GetAllTRClass-> " + dbObj.LastError);
}
}
}
}
