public static CustomList <MedicalReinSetup> GetAllMedicalReinSetup(string fyKey, string empKey) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <MedicalReinSetup> MedicalReinSetupCollection = new CustomList <MedicalReinSetup>(); IDataReader reader = null; String sql = "select *from MedicalReinSetup Where FYKey=" + fyKey + " and EmpKey=" + empKey; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { MedicalReinSetup newMedicalReinSetup = new MedicalReinSetup(); newMedicalReinSetup.SetData(reader); MedicalReinSetupCollection.Add(newMedicalReinSetup); } return(MedicalReinSetupCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList <MedicalReinSetup> GetAllMedicalReinSetup() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <MedicalReinSetup> MedicalReinSetupCollection = new CustomList <MedicalReinSetup>(); IDataReader reader = null; const String sql = "select *from MedicalReinSetup"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { MedicalReinSetup newMedicalReinSetup = new MedicalReinSetup(); newMedicalReinSetup.SetData(reader); MedicalReinSetupCollection.Add(newMedicalReinSetup); } MedicalReinSetupCollection.InsertSpName = "spInsertMedicalReinSetup"; MedicalReinSetupCollection.UpdateSpName = "spUpdateMedicalReinSetup"; MedicalReinSetupCollection.DeleteSpName = "spDeleteMedicalReinSetup"; return(MedicalReinSetupCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }