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); } } } }