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);
}
