private static UncomplicatedCases MapCase(IDataReader reader) { UncomplicatedCases item = new UncomplicatedCases(); Hospitals hosp = new Hospitals(); int startingIndex = 0; item.Id = reader.GetSafeInt32(startingIndex++); hosp.Id = reader.GetSafeInt32(startingIndex++); hosp.Name = reader.GetSafeString(startingIndex++); item.DateAdded = reader.GetSafeDateTime(startingIndex++); item.Hospital = hosp; return(item); }
public static List <UncomplicatedCases> GetCaseByHospital(int hospitalId) { List <UncomplicatedCases> list = null; DataProvider.ExecuteCmd(GetConnection, "dbo.UncomplicatedCases_SelectByHospitalID", inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@HospitalID", hospitalId); }, map : delegate(IDataReader reader, short set) { UncomplicatedCases item = MapCase(reader); if (list == null) { list = new List <UncomplicatedCases>(); } list.Add(item); //list = MapGynCase(reader); }); return(list); }