Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
        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);
        }
Exemplo n.º 3
0
        //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);
        }
Exemplo n.º 4
0
        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);
        }