private static GynCases MapGynCase(IDataReader reader) { GynCases item = new GynCases(); Hospitals hosp = new Hospitals(); GynCategories cat = new GynCategories(); 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++); item.Admission = reader.GetSafeString(startingIndex++); item.Treatment = reader.GetSafeString(startingIndex++); item.SurgicalPath = reader.GetSafeString(startingIndex++); cat.Id = reader.GetSafeInt32(startingIndex++); cat.Category = reader.GetSafeString(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.Complication = cat; return(item); }
private static GynCategories MapGynCategory(IDataReader reader) { GynCategories item = new GynCategories(); int startingIndex = 0; item.Id = reader.GetSafeInt32(startingIndex++); item.Category = reader.GetSafeString(startingIndex++); return(item); }
//GYNECOLOGICAL/////////////////////////////////////////////////////////////// public static GynCategories GetGynCategory(int id) { GynCategories item = null; DataProvider.ExecuteCmd(GetConnection, "dbo.GynCategories_SelectById", inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", id); }, map : delegate(IDataReader reader, short set) { item = MapGynCategory(reader); }); return(item); }
public static List <GynCategories> GetGynCategoryList() { List <GynCategories> list = null; DataProvider.ExecuteCmd(GetConnection, "dbo.GynCategories_SelectAll", inputParamMapper : null, map : delegate(IDataReader reader, short set) { GynCategories item = MapGynCategory(reader); if (list == null) { list = new List <GynCategories>(); } list.Add(item); }); return(list); }