private static OfficePracticeCases MapOfficePracticeCase(IDataReader reader)
{
OfficePracticeCases item = new OfficePracticeCases();
OfficeCategories cat = new OfficeCategories();
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.Visits = reader.GetSafeInt32(startingIndex++);
item.Problem = reader.GetSafeString(startingIndex++);
item.DiagnosticProc = reader.GetSafeString(startingIndex++);
cat.Id = reader.GetSafeInt32(startingIndex++);
cat.Category = reader.GetSafeString(startingIndex++);
item.Treatment = reader.GetSafeString(startingIndex++);
item.Result = reader.GetSafeString(startingIndex++);
item.DateAdded = reader.GetSafeDateTime(startingIndex++);
item.DateModified = reader.GetSafeDateTime(startingIndex++);
item.Complication = cat;
return(item);
}
private static OfficeCategories MapOfficeCategory(IDataReader reader)
{
OfficeCategories item = new OfficeCategories();
int startingIndex = 0;
item.Id = reader.GetSafeInt32(startingIndex++);
item.Category = reader.GetSafeString(startingIndex++);
return(item);
}
//OFFICE PRACTICE///////////////////////////////////////////////////////////////
public static OfficeCategories GetOfficeCategory(int id)
{
OfficeCategories item = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.OfficeCategories_SelectById",
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}, map : delegate(IDataReader reader, short set)
{
item = MapOfficeCategory(reader);
});
return(item);
}
public static List <OfficeCategories> GetOfficeCategoryList()
{
List <OfficeCategories> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.OfficeCategories_SelectAll",
inputParamMapper : null,
map : delegate(IDataReader reader, short set)
{
OfficeCategories item = MapOfficeCategory(reader);
if (list == null)
{
list = new List <OfficeCategories>();
}
list.Add(item);
});
return(list);
}
