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); }
private static ObCategories MapObCategory(IDataReader reader) { ObCategories item = new ObCategories(); int startingIndex = 0; item.Id = reader.GetSafeInt32(startingIndex++); item.Category = reader.GetSafeString(startingIndex++); return(item); }
//OBSTETRICAL/////////////////////////////////////////////////////////////// public static ObCategories GetObCategory(int id) { ObCategories item = null; DataProvider.ExecuteCmd(GetConnection, "dbo.ObCategories_SelectById", inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", id); }, map : delegate(IDataReader reader, short set) { item = MapObCategory(reader); }); return(item); }
public static List <ObCategories> GetObCategoryList() { List <ObCategories> list = null; DataProvider.ExecuteCmd(GetConnection, "dbo.ObCategories_SelectAll", inputParamMapper : null, map : delegate(IDataReader reader, short set) { ObCategories item = MapObCategory(reader); if (list == null) { list = new List <ObCategories>(); } list.Add(item); }); return(list); }