public static T_COM_Master_GradeCollection Search(SearchFilter SearchKey) { T_COM_Master_GradeCollection collection = new T_COM_Master_GradeCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Grade_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey))) { while (reader.Read()) { T_COM_Master_Grade obj = new T_COM_Master_Grade(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_COM_Master_GradeCollection GetbyUser(string CreatedUser) { T_COM_Master_GradeCollection collection = new T_COM_Master_GradeCollection(); T_COM_Master_Grade obj; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Grade_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser))) { while (reader.Read()) { obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_COM_Master_GradeCollection GetAllItem() { T_COM_Master_GradeCollection collection = new T_COM_Master_GradeCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Grade_GetAll", null)) { while (reader.Read()) { T_COM_Master_Grade obj = new T_COM_Master_Grade(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }