public List <Entities.PreEmploymentTestDetails> GetPreEmploymentTestDetailsByPreEmploymentId(Int32 preEmploymentId) { var testDetails = new List <Entities.PreEmploymentTestDetails>(); using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetPreEmploymentTestDetailsByPreEmploymentId)) { database.AddInParameter(dbCommand, "@pre_employment_id", DbType.Int32, preEmploymentId); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var employmentTestDetails = new Entities.PreEmploymentTestDetails() { PreEmploymentTestId = DRE.GetNullableInt32(reader, "pre_employment_test_id", 0), PreEmploymentId = DRE.GetNullableInt32(reader, "pre_employment_id", 0), MedicalTestId = DRE.GetNullableInt32(reader, "medical_test_id", null), MedicalTestParameterId = DRE.GetNullableInt32(reader, "medical_test_parameter_id", null), TestName = DRE.GetNullableString(reader, "test_name", null), TestValue = DRE.GetNullableString(reader, "test_value", null), IsParameters = DRE.GetNullableBoolean(reader, "is_parameters", null), IsTestGeneral = DRE.GetNullableBoolean(reader, "is_test_general", null) }; testDetails.Add(employmentTestDetails); } } } return(testDetails); }
/// <summary> /// Gets the permission by role and menu id. /// </summary> /// <param name="roleId">Specifies the role id.</param> /// <param name="menuId">Specifies the menu id.</param> /// <returns>An object of role permission.</returns> public Entities.RolePermission GetRolePermissionByRoleAndMenuId(Int32 roleId, Int32 menuId) { var rolePermission = new Entities.RolePermission(); DbCommand dbCommand = null; using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetPermissionDetailsByRoleAndMenuId)) { database.AddInParameter(dbCommand, "@role_id", DbType.Int32, roleId); database.AddInParameter(dbCommand, "@menu_id", DbType.Int32, menuId); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var _rolePermission = new Entities.RolePermission { RolePermissionId = DRE.GetNullableInt32(reader, "role_permission_id", 0), AddPermission = DRE.GetNullableBoolean(reader, "add_permission", null), ViewPermission = DRE.GetNullableBoolean(reader, "view_permission", null), EditPermission = DRE.GetNullableBoolean(reader, "edit_permission", null), DeletePermission = DRE.GetNullableBoolean(reader, "delete_permission", null) }; rolePermission = _rolePermission; } } } return(rolePermission); }
/// <summary> /// Gets the collection of all permissions /// </summary> /// <param name="roleId">Specifies the role id.</param> /// <returns>A collection of role permissions.</returns> public List <Entities.RolePermission> GetRolePermissionByRoleId(Int32 roleId) { var rolePermissions = new List <Entities.RolePermission>(); DbCommand dbCommand = null; using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetListOfPermissionsByRoleId)) { database.AddInParameter(dbCommand, "@role_id", DbType.Int32, roleId); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var rolePermission = new Entities.RolePermission { RolePermissionId = DRE.GetNullableInt32(reader, "role_permission_id", 0), RoleId = DRE.GetNullableInt32(reader, "role_id", null), MenuGroupId = DRE.GetNullableInt32(reader, "menu_group_id", null), MenuId = DRE.GetNullableInt32(reader, "menu_id", null), AddPermission = DRE.GetNullableBoolean(reader, "add_permission", null), ViewPermission = DRE.GetNullableBoolean(reader, "view_permission", null), EditPermission = DRE.GetNullableBoolean(reader, "edit_permission", null), DeletePermission = DRE.GetNullableBoolean(reader, "delete_permission", null) }; rolePermissions.Add(rolePermission); } } } return(rolePermissions); }
/// <summary> /// /// </summary> /// <param name="brandName"></param> /// <returns></returns> public Entities.MedicalTest SearchMedicalTestByName(string testName) { var medicalTestInfo = new Entities.MedicalTest(); using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchMedicalTestByName)) { database.AddInParameter(dbCommand, "@test_name", DbType.String, testName); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var medicalTest = new Entities.MedicalTest { MedicalTestId = DRE.GetNullableInt32(reader, "medical_test_id", 0), TestName = DRE.GetNullableString(reader, "medical_test_name", null), IsParameters = DRE.GetNullableBoolean(reader, "is_parameters", null), IsGeneralTest = DRE.GetNullableBoolean(reader, "is_test_general", null) }; medicalTestInfo = medicalTest; } } } return(medicalTestInfo); }
/// <summary> /// /// </summary> /// <returns></returns> public List <Entities.MedicalTest> SearchAllMedicalTests() { var medicalTests = new List <Entities.MedicalTest>(); using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchMedicalTestAll)) { using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { MedicalTestParameters medicalTestParameters = new MedicalTestParameters(); var medicalTest = new Entities.MedicalTest { MedicalTestId = DRE.GetNullableInt32(reader, "medical_test_id", 0), TestName = DRE.GetNullableString(reader, "medical_test_name", null), IsParameters = DRE.GetNullableBoolean(reader, "is_parameters", null), IsGeneralTest = DRE.GetNullableBoolean(reader, "is_test_general", null), MedicalTestParameters = medicalTestParameters.GetMedicalTestParameterDetailsByTestId(DRE.GetInt32(reader, "medical_test_id")) }; medicalTests.Add(medicalTest); } } } return(medicalTests); }
public List <Entities.XRayIssue> SearchXRayIssue(Entities.XRayIssue xrayIssue) { var xRayIssues = new List <Entities.XRayIssue>(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchXRayIssue)) { database.AddInParameter(dbCommand, "@financial_year", DbType.String, xrayIssue.FinancialYear); database.AddInParameter(dbCommand, "@first_name", DbType.String, xrayIssue.FirstName); database.AddInParameter(dbCommand, "@last_name", DbType.String, xrayIssue.LastName); database.AddInParameter(dbCommand, "@xray_issue_from_date", DbType.String, xrayIssue.XRayIssueFromDate); database.AddInParameter(dbCommand, "@xray_issue_to_date", DbType.String, xrayIssue.XRayIssueToDate); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var xrayFilmUsed = new DataModel.XRayFilmUsed(); var xRayIssue = new Entities.XRayIssue() { XRayIssueId = DRE.GetNullableInt32(reader, "xray_issue_id", 0), XRayIssueNo = DRE.GetNullableInt32(reader, "xray_issue_no", null), XRayIssueDate = DRE.GetNullableString(reader, "xray_issue_date", null), PartOfBodyToXRay = DRE.GetNullableString(reader, "part_of_body_to_xray", null), IsECGDone = DRE.GetNullableBoolean(reader, "is_ecg_done", null), Purpose = DRE.GetNullableString(reader, "purpose", null), Impression = DRE.GetNullableString(reader, "impression", null), PatientId = DRE.GetNullableInt32(reader, "patient_id", null), PatientCode = DRE.GetNullableInt32(reader, "patient_code", null), PatientName = DRE.GetNullableString(reader, "full_name", null), EmployerId = DRE.GetNullableInt32(reader, "employer_id", null), EmployerCode = DRE.GetNullableInt32(reader, "employer_code", null), EmployerName = DRE.GetNullableString(reader, "employer_name", null), WorkingPeriodId = DRE.GetNullableInt32(reader, "working_period_id", null), FinancialYear = DRE.GetNullableString(reader, "financial_year", null), XRayFilmsUsed = xrayFilmUsed.GetFilmUsedDetailsByXRayIssueId(DRE.GetInt32(reader, "xray_issue_id")) }; xRayIssues.Add(xRayIssue); } } } } catch (Exception e) { throw e; } return(xRayIssues); }