示例#1
0
        public Entities.PreEmploymentDetails GetPatientAndTestDetails(Int32 patientId)
        {
            var patientAndTestDetails = new Entities.PreEmploymentDetails();

            try
            {
                using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetPreEmploymentPatientDetailsByPatientId))
                {
                    database.AddInParameter(dbCommand, "@patient_id", DbType.Int32, patientId);

                    using (IDataReader reader = database.ExecuteReader(dbCommand))
                    {
                        while (reader.Read())
                        {
                            var preEmploymentTestDetails = new DataModel.PreEmploymentTestDetails();

                            var preEmployment = new Entities.PreEmploymentDetails()
                            {
                                PreEmploymentId     = DRE.GetNullableInt32(reader, "pre_employment_id", 0),
                                PreEmploymentCodeNo = DRE.GetNullableInt32(reader, "pre_employment_code_no", 0),
                                PatientId           = DRE.GetNullableInt32(reader, "patient_id", null),
                                PatientCode         = DRE.GetNullableInt32(reader, "patient_code", null),
                                PatientFullName     = DRE.GetNullableString(reader, "full_name", null),
                                Gender             = DRE.GetNullableString(reader, "gender", null),
                                Age                = DRE.GetNullableInt32(reader, "age", null),
                                ConsultDate        = DRE.GetNullableString(reader, "consult_date", null),
                                MaritalStatus      = DRE.GetNullableString(reader, "marital_status", null),
                                NoOfSons           = DRE.GetNullableInt32(reader, "no_of_sons", null),
                                NoOfDaughters      = DRE.GetNullableInt32(reader, "no_of_daughters", null),
                                EmployerId         = DRE.GetNullableInt32(reader, "employer_id", null),
                                EmployerCode       = DRE.GetNullableInt32(reader, "employer_code", null),
                                EmployerName       = DRE.GetNullableString(reader, "employer_name", null),
                                Designation        = DRE.GetNullableString(reader, "designation", null),
                                IdentificationMark = DRE.GetNullableString(reader, "identification_mark", null),
                                AllergicTo         = DRE.GetNullableString(reader, "allergic_to", null),
                                Micturation        = DRE.GetNullableString(reader, "micturation", null),
                                Bowels             = DRE.GetNullableString(reader, "bowels", null),
                                Sleep              = DRE.GetNullableString(reader, "sleep", null),
                                Alcohol            = DRE.GetNullableString(reader, "alcohol", null),
                                Smoking            = DRE.GetNullableString(reader, "smoking", null),
                                MC                       = DRE.GetNullableString(reader, "mc", null),
                                PastHistory              = DRE.GetNullableString(reader, "past_history", null),
                                FamilyHistory            = DRE.GetNullableString(reader, "family_history", null),
                                WorkingPeriodId          = DRE.GetNullableInt32(reader, "working_period_id", null),
                                FinancialYear            = DRE.GetNullableString(reader, "financial_year", null),
                                PreEmploymentTestDetails = preEmploymentTestDetails.GetAllTestDetails()
                            };

                            patientAndTestDetails = preEmployment;
                        }
                    }
                }
            }
            catch (Exception e)
            {
                throw e;
            }

            return(patientAndTestDetails);
        }
示例#2
0
        public List <Entities.PreEmploymentDetails> SearchPreEmploymentDetails(Entities.PreEmploymentDetails preEmploymentDetails)
        {
            var preEmploymentDetailsList = new List <Entities.PreEmploymentDetails>();

            try
            {
                using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchPreEmploymentDetails))
                {
                    database.AddInParameter(dbCommand, "@pre_employment_or_health_checkup", DbType.String, preEmploymentDetails.PreEmploymentOrHealthCheckup);
                    database.AddInParameter(dbCommand, "@financial_year", DbType.String, preEmploymentDetails.FinancialYear);
                    database.AddInParameter(dbCommand, "@first_name", DbType.String, preEmploymentDetails.FirstName);
                    database.AddInParameter(dbCommand, "@last_name", DbType.String, preEmploymentDetails.LastName);
                    database.AddInParameter(dbCommand, "@consult_from_date", DbType.String, preEmploymentDetails.ConsultFromDate);
                    database.AddInParameter(dbCommand, "@consult_to_date", DbType.String, preEmploymentDetails.ConsultToDate);

                    using (IDataReader reader = database.ExecuteReader(dbCommand))
                    {
                        while (reader.Read())
                        {
                            var preEmploymentTestDetails = new DataModel.PreEmploymentTestDetails();

                            var preEmployment = new Entities.PreEmploymentDetails()
                            {
                                PreEmploymentId              = DRE.GetNullableInt32(reader, "pre_employment_id", 0),
                                PreEmploymentCodeNo          = DRE.GetNullableInt32(reader, "pre_employment_code_no", null),
                                PreEmploymentOrHealthCheckup = DRE.GetNullableString(reader, "pre_employment_or_health_checkup", null),
                                PatientId          = DRE.GetNullableInt32(reader, "patient_id", null),
                                PatientCode        = DRE.GetNullableInt32(reader, "patient_code", null),
                                PatientFullName    = DRE.GetNullableString(reader, "full_name", null),
                                Gender             = DRE.GetNullableString(reader, "gender", null),
                                Age                = DRE.GetNullableInt32(reader, "age", null),
                                ConsultDate        = DRE.GetNullableString(reader, "consult_date", null),
                                MaritalStatus      = DRE.GetNullableString(reader, "marital_status", null),
                                NoOfSons           = DRE.GetNullableInt32(reader, "no_of_sons", null),
                                NoOfDaughters      = DRE.GetNullableInt32(reader, "no_of_daughters", null),
                                EmployerId         = DRE.GetNullableInt32(reader, "employer_id", null),
                                EmployerCode       = DRE.GetNullableInt32(reader, "employer_code", null),
                                EmployerName       = DRE.GetNullableString(reader, "employer_name", null),
                                Designation        = DRE.GetNullableString(reader, "designation", null),
                                IdentificationMark = DRE.GetNullableString(reader, "identification_mark", null),
                                AllergicTo         = DRE.GetNullableString(reader, "allergic_to", null),
                                Micturation        = DRE.GetNullableString(reader, "micturation", null),
                                Bowels             = DRE.GetNullableString(reader, "bowels", null),
                                Sleep              = DRE.GetNullableString(reader, "sleep", null),
                                Alcohol            = DRE.GetNullableString(reader, "alcohol", null),
                                Smoking            = DRE.GetNullableString(reader, "smoking", null),
                                MC                       = DRE.GetNullableString(reader, "mc", null),
                                PastHistory              = DRE.GetNullableString(reader, "past_history", null),
                                FamilyHistory            = DRE.GetNullableString(reader, "family_history", null),
                                OtherDetails             = DRE.GetNullableString(reader, "other_details", null),
                                Remarks                  = DRE.GetNullableString(reader, "remarks", null),
                                WorkingPeriodId          = DRE.GetNullableInt32(reader, "working_period_id", null),
                                FinancialYear            = DRE.GetNullableString(reader, "financial_year", null),
                                PreEmploymentTestDetails = preEmploymentTestDetails.GetPreEmploymentTestDetailsByPreEmploymentId(DRE.GetInt32(reader, "pre_employment_id"))
                            };

                            preEmploymentDetailsList.Add(preEmployment);
                        }
                    }
                }
            }
            catch (Exception e)
            {
                throw e;
            }

            return(preEmploymentDetailsList);
        }