private static ObCases MapObCase(IDataReader reader) { ObCases item = new ObCases(); Hospitals hosp = new Hospitals(); ObCategories ante = new ObCategories(); ObCategories post = new ObCategories(); int startingIndex = 0; item.Id = reader.GetSafeInt32(startingIndex++); item.PatientID = reader.GetSafeString(startingIndex++); item.Age = reader.GetSafeInt32(startingIndex++); item.Gravity = reader.GetSafeInt32(startingIndex++); item.Parity = reader.GetSafeInt32(startingIndex++); ante.Id = reader.GetSafeInt32(startingIndex++); ante.Category = reader.GetSafeString(startingIndex++); post.Id = reader.GetSafeInt32(startingIndex++); post.Category = reader.GetSafeString(startingIndex++); item.Treatment = reader.GetSafeString(startingIndex++); item.BirthWeight = reader.GetSafeInt32(startingIndex++); item.Death = reader.GetSafeString(startingIndex++); item.OneMinScore = reader.GetSafeInt32(startingIndex++); item.FiveMinScore = reader.GetSafeInt32(startingIndex++); hosp.Id = reader.GetSafeInt32(startingIndex++); hosp.Name = reader.GetSafeString(startingIndex++); item.DaysInHospital = reader.GetSafeInt32(startingIndex++); item.DateAdded = reader.GetSafeDateTime(startingIndex++); item.DateModified = reader.GetSafeDateTime(startingIndex++); item.Hospital = hosp; item.Antepartum = ante; item.Postpartum = post; return(item); }
public static ObCases GetObCase(int id) { ObCases item = null; DataProvider.ExecuteCmd(GetConnection, "dbo.ObstetricalCases_SelectById", inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", id); }, map : delegate(IDataReader reader, short set) { item = MapObCase(reader); }); return(item); }
public static List <ObCases> GetObCaseList() { List <ObCases> list = null; DataProvider.ExecuteCmd(GetConnection, "dbo.ObstetricalCases_SelectAll", inputParamMapper : null, map : delegate(IDataReader reader, short set) { ObCases item = MapObCase(reader); if (list == null) { list = new List <ObCases>(); } list.Add(item); }); return(list); }
public static List <ObCases> GetObCaseByHospital(int hospitalId) { List <ObCases> list = null; DataProvider.ExecuteCmd(GetConnection, "dbo.ObstetricalCases_SelectByHospitalID", inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@HospitalID", hospitalId); }, map : delegate(IDataReader reader, short set) { ObCases item = MapObCase(reader); if (list == null) { list = new List <ObCases>(); } list.Add(item); }); return(list); }