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);
}
public static OfficePracticeCases GetOfficePracticeCase(int id)
{
OfficePracticeCases item = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.OfficePracticeCases_SelectById",
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}, map : delegate(IDataReader reader, short set)
{
item = MapOfficePracticeCase(reader);
});
return(item);
}
public static List <OfficePracticeCases> GetOfficePracticeCaseList()
{
List <OfficePracticeCases> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.OfficePracticeCases_SelectAll",
inputParamMapper : null,
map : delegate(IDataReader reader, short set)
{
OfficePracticeCases item = MapOfficePracticeCase(reader);
if (list == null)
{
list = new List <OfficePracticeCases>();
}
list.Add(item);
});
return(list);
}
