public LabTestGroup GetGroupLabTest(int mainTestId)
{
LabTest mainLabTest = this.GetLabTestById(mainTestId);
ClsObject obj = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddExtendedParameters("@MainTestId", SqlDbType.Int, mainTestId);
DataTable dt = (DataTable)obj.ReturnObject(ClsUtility.theParams, "Laboratory_GroupGetLabTest", ClsUtility.ObjectEnum.DataTable);
LabTestGroup groupLab = new LabTestGroup()
{
GroupTest = mainLabTest
};
TestDepartment department = null;
var component = (from row in dt.AsEnumerable()
select new LabTest()
{
Id = Convert.ToInt32(row["Id"]),
Name = row["Name"].ToString(),
IsGroup = Convert.ToBoolean(row["IsGroup"]),
ReferenceId = row["ReferenceId"].ToString(),
ParameterCount = Convert.ToInt32(row["ParameterCount"]),
Department = row["DepartmentId"] == DBNull.Value ? department : new TestDepartment()
{
Id = Convert.ToInt32(row["DepartmentId"]), Name = row["Department"].ToString()
},
DeleteFlag = Convert.ToBoolean(row["DeleteFlag"]),
Active = Convert.ToBoolean(row["Active"]),
TestParameter = null
}
).ToList <LabTest>();
groupLab.ComponentTest = component;
obj = null;
return(groupLab);
}
public LabTest GetLabTestById(int LabTestId)
{
DataTable dt = this.GetLabTests(null);
LabTest result = null;
TestDepartment department = null;
if (null != dt && dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
result = new LabTest()
{
Id = Convert.ToInt32(row["Id"]),
Name = row["Name"].ToString(),
IsGroup = Convert.ToBoolean(row["IsGroup"]),
ReferenceId = row["ReferenceId"].ToString(),
ParameterCount = Convert.ToInt32(row["ParameterCount"]),
Department = row["DepartmentId"] == DBNull.Value ? department : new TestDepartment()
{
Id = Convert.ToInt32(row["DepartmentId"]), Name = row["Department"].ToString()
},
Active = Convert.ToBoolean(row["Active"]),
DeleteFlag = Convert.ToBoolean(row["DeleteFlag"]),
TestParameter = this.GetLabTestParameters(LabTestId)
};
}
return(result);
}
public ActionResult EditDept(AppDeptViewModel vm, int id, IFormCollection collection)
{
var tr = new TestDepartment
{
DeptId = vm.DepartmentId,
Department = vm.Department,
};
try
{
if (id > 0)
{
_testRepo.UpdateDepartment(tr);
}
else
{
_testRepo.UpdateDepartment(tr);
}
_testRepo.SaveChangesAsync();
return(RedirectToAction("Department", "Home"));
}
catch
{
return(View(tr));
}
}
private async Task InitOnce()
{
if (_app != null) return;
_app = new DefaultWebApplicationFactory();
var options = new WebApplicationFactoryClientOptions()
{
AllowAutoRedirect = false
};
_httpClient = _app.CreateClient(options);
_apiClient = new ApiClient(_httpClient, _app.GetLogger<ApiClient>());
// create tenants here
await _apiClient.AsSiteAdminAsync(_httpClient);
_gryffindorHouse = await TestTenants.CreateTenantWithRolesAndUsers(_apiClient, _httpClient, TestTenants.GryffindorHouse);
await TestBranchOffice.SeedDefaultBranchOffice(_apiClient, _httpClient, _gryffindorHouse);
await TestDepartment.SeedDefaultDepartments(_apiClient, _gryffindorHouse);
await TestPosition.SeedDefaultPosition(_apiClient, _gryffindorHouse);
await TestEmployees.SeedDefaultEmployees(_apiClient, _gryffindorHouse);
_gryffindorEmployees = (await _apiClient.GetEmployeesAsync()).ToList();
await _apiClient.AsSiteAdminAsync(_httpClient);
_slytherinHouse = await TestTenants.CreateTenantWithRolesAndUsers(_apiClient, _httpClient, TestTenants.SlytherinHouse);
await TestBranchOffice.SeedDefaultBranchOffice(_apiClient, _httpClient, _slytherinHouse);
await TestDepartment.SeedDefaultDepartments(_apiClient, _slytherinHouse);
await TestPosition.SeedDefaultPosition(_apiClient, _slytherinHouse);
await TestEmployees.SeedDefaultEmployees(_apiClient, _slytherinHouse);
}
public void TestInitialize()
{
IDepartment department = new TestDepartment();
TestLocalDataContext _tldc = new TestLocalDataContext();
TestDataFiller.Fill(_tldc);
ITestDataService _testDataService = new TestDataService(_tldc);
IDataContext _dataContext = new DataContext(_testDataService);
_mainWindowViewModel = new MainWindowViewModel(_dataContext, department);
}
public List <LabOrderTest> GetOrderedTests(int orderId, int?labOrderTestId = null)
{
ClsObject obj = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddExtendedParameters("@LabOrderId", SqlDbType.Int, orderId);
if (labOrderTestId.HasValue)
{
ClsUtility.AddExtendedParameters("@LabOrderTestId", SqlDbType.Int, labOrderTestId.Value);
}
int? nullint = null;
DateTime? nullDate = null;
TestDepartment nullDepartment = null;
DataTable dt = (DataTable)obj.ReturnObject(ClsUtility.theParams, "Laboratory_GetLabOrderTests", ClsUtility.ObjectEnum.DataTable);
obj = null;
ClsUtility.Init_Hashtable();
var result = (from row in dt.AsEnumerable()
select new LabOrderTest
{
Id = row.Field <int>("TestOrderId"),
OrderDate = Convert.ToDateTime(row["OrderDate"]),
OrderNumber = row["OrderNumber"].ToString(),
OrderedBy = row.Field <int>("OrderedBy"),
ServiceAreaId = row.Field <int>("ModuleId"),
DeleteFlag = row.Field <bool>("DeleteFlag"),
LabOrderId = row.Field <int>("LabOrderId"),
ParentLabTestId = row["ParentTestId"] == DBNull.Value ? nullint : row.Field <int>("ParentTestId"),
Test = new LabTest()
{
Id = row.Field <int>("TestId"),
DeleteFlag = row.Field <bool>("TestDeleteFlag"),
Name = row["TestName"].ToString(),
ReferenceId = row["ReferenceId"].ToString(),
Department = row["DepartmentId"] != DBNull.Value ? new TestDepartment()
{
Id = Convert.ToInt32(row["DepartmentId"]), Name = row["Department"].ToString()
} : nullDepartment,
IsGroup = row.Field <bool>("IsGroup")
},
TestNotes = row["TestNotes"].ToString(),
ResultBy = row["ResultBy"] == DBNull.Value ? nullint : Convert.ToInt32(row["ResultBy"]),
ResultDate = row["ResultDate"] == DBNull.Value ? nullDate : Convert.ToDateTime(row["ResultDate"]),
ResultNotes = row["ResultNotes"].ToString(),
ParameterResults = GetLabTestParameterResult(row.Field <int>("TestOrderId"))
}
).ToList();
return(result);
}
public void AddDepartmentTest()
{
int departmentsNum = _mainWindowViewModel.Departments.Count;
IDepartment department = new TestDepartment(25, "testName", "testGroup", DateTime.Now);
_mainWindowViewModel.Name = department.Name;
_mainWindowViewModel.GroupName = department.GroupName;
_mainWindowViewModel.DepartmentID = department.DepartmentID;
_mainWindowViewModel.AddDepartmentCommand.Execute(null);
Thread.Sleep(100);
Assert.AreEqual(departmentsNum + 1, _mainWindowViewModel.Departments.Count);
}
private async Task InitOnce()
{
if (_app != null)
{
return;
}
LogHelper.ConfigureConsoleLogger();
_app = new DefaultWebApplicationFactory();
var options = new WebApplicationFactoryClientOptions {
AllowAutoRedirect = false
};
_httpClient = _app.CreateClient(options);
var apiClient = new ApiClient(_httpClient, _app.GetLogger <ApiClient>());
apiClient.TraceResponseOnException = true;
_apiClient = apiClient;
// site admin creates 2 tenants
await _apiClient.AsSiteAdminAsync(_httpClient);
_gryffindorHouse = await TestTenants.CreateTenantWithRolesAndUsers(_apiClient, _httpClient, TestTenants.GryffindorHouse);
await _apiClient.AsSiteAdminAsync(_httpClient);
_slytherinHouse = await TestTenants.CreateTenantWithRolesAndUsers(_apiClient, _httpClient, TestTenants.SlytherinHouse);
// Slytherin House admin creates branch office and departments
await _apiClient.AsSlytherinAdminAsync(_httpClient);
TestBranchOffice.SeedDefaultBranchOffice(_apiClient, _httpClient, _slytherinHouse).Wait();
TestDepartment.SeedDefaultDepartments(_apiClient, _slytherinHouse).Wait();
TestPosition.SeedDefaultPosition(_apiClient, _slytherinHouse).Wait();
TestEmployees.SeedDefaultEmployees(_apiClient, _slytherinHouse).Wait();
// Gryffindor House admin creates branch office and departments
await _apiClient.AsGryffindorAdminAsync(_httpClient);
TestBranchOffice.SeedDefaultBranchOffice(_apiClient, _httpClient, _gryffindorHouse).Wait();
TestDepartment.SeedDefaultDepartments(_apiClient, _gryffindorHouse).Wait();
TestPosition.SeedDefaultPosition(_apiClient, _gryffindorHouse).Wait();
TestEmployees.SeedDefaultEmployees(_apiClient, _gryffindorHouse).Wait();
_workDepartmentId = _gryffindorHouse.Department_1_2.Department.Id;
}
protected void buttonSave_Click(object sender, EventArgs e)
{
try
{
string testName = textLabName.Text.Trim();
string testRef = textReference.Text;
if (testRef == "")
{
textLabName.Text.Trim().ToUpper().Replace(' ', '_');
}
bool isGroup = chkGroupYes.Checked;
TestDepartment department = null;
if (!isGroup)
{
if (ddlDepartment.SelectedValue == "-1")
{
throw new Exception("Please select department");
}
department = new TestDepartment()
{
Id = Convert.ToInt32(ddlDepartment.SelectedValue), Name = ddlDepartment.SelectedItem.Text
};
}
LabTest test = new LabTest()
{
Id = -1,
Name = testName,
ReferenceId = testRef,
IsGroup = isGroup,
DeleteFlag = false,
Department = department,
LoincCode = txtLoinc.Text.Trim(),
UserId = this.UserId,
TestParameter = null
};
LabTest result = mGr.SaveLabTest(test, this.UserId);
this.PopulateLabTests();
IQCareMsgBox.NotifyAction("Lab " + result.Name + " successfully saved", "Success", false, this, "javascript:HideModalPopup();return false;");
}
catch (Exception ex)
{
this.ShowErrorMessage(ref ex);
}
}
public async Task <ActionResult> CreateDept(AppDeptViewModel vm, IFormCollection collection)
{
var tes = new TestDepartment
{
DeptId = vm.DepartmentId,
Department = vm.Department
//Patients = new PatientForm
//{
// Fullname = vm.Fullname,
// Age = vm.Age,
// ClinicalDiagnosis = vm.ClinicalDiagnosis,
// DateOfRequest = vm.DateOfRequest,
// Physician = new Physician
// {
// PhysicianName = vm.Physician
// }
//},
//Tests = /*(from product in _ctx.Tests new PatientTest)*/{
//},
// Result = new TestResult
// {
// IsCompleted = vm.IsCompleted
// },
};
try
{
_testRepo.AddDepartment(tes);
await _testRepo.SaveChangesAsync();
return(RedirectToAction("Department", "Home"));
}
catch
{
return(View(tes));
}
}
public LabTest SaveLabTest(LabTest labTest, int userId)
{
ClsObject obj = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddExtendedParameters("@ReferenceId", SqlDbType.VarChar, labTest.ReferenceId);
ClsUtility.AddExtendedParameters("@TestName", SqlDbType.VarChar, labTest.Name);
ClsUtility.AddExtendedParameters("@IsGroup", SqlDbType.Bit, labTest.IsGroup);
ClsUtility.AddExtendedParameters("@UserId", SqlDbType.Int, userId);
if (labTest.Department != null)
{
ClsUtility.AddExtendedParameters("@DepartmentId", SqlDbType.Int, labTest.DepartmentId);
ClsUtility.AddExtendedParameters("@LoincCode", SqlDbType.VarChar, labTest.LoincCode);
}
try
{
DataTable dt = (DataTable)obj.ReturnObject(ClsUtility.theParams, "Laboratory_SaveLabTest", ClsUtility.ObjectEnum.DataTable);
TestDepartment department = null;
labTest.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
labTest.ParameterCount = Convert.ToInt32(dt.Rows[0]["ParameterCount"]);
labTest.Department = dt.Rows[0]["DepartmentId"] == DBNull.Value ? department : new TestDepartment()
{
Id = Convert.ToInt32(dt.Rows[0]["DepartmentId"]), Name = dt.Rows[0]["Department"].ToString()
};
labTest.ReferenceId = dt.Rows[0]["ReferenceId"].ToString();
labTest.DeleteFlag = Convert.ToBoolean(dt.Rows[0]["DeleteFlag"]);
labTest.Active = Convert.ToBoolean(dt.Rows[0]["Active"]);
labTest.Name = dt.Rows[0]["Name"].ToString();
labTest.TestParameter = null;
return(labTest);
}
catch
{
throw;
}
}
public List <LabTest> GetLabTests()
{
DataTable dt = this.GetLabTests(null);
TestDepartment department = null;
var result = (from row in dt.AsEnumerable()
select new LabTest()
{
Id = Convert.ToInt32(row["Id"]),
Name = row["Name"].ToString(),
IsGroup = Convert.ToBoolean(row["IsGroup"]),
ReferenceId = row["ReferenceId"].ToString(),
ParameterCount = Convert.ToInt32(row["ParameterCount"]),
Department = row["DepartmentId"] == DBNull.Value ? department : new TestDepartment()
{
Id = Convert.ToInt32(row["DepartmentId"]), Name = row["Department"].ToString()
},
Active = Convert.ToBoolean(row["Active"]),
DeleteFlag = Convert.ToBoolean(row["DeleteFlag"]),
TestParameter = null
}
);
return(result.ToList());;
}
public static void Seed(IServiceProvider serviceProvider)
{
using (var context = new AppDbContext(serviceProvider.GetRequiredService <DbContextOptions <AppDbContext> >()))
{
//AppDbContext context = applicationBuilder.ApplicationServices.GetRequiredService<AppDbContext>();
//UserManager<IdentityUser> userManager = serviceProvider.GetRequiredService<UserManager<IdentityUser>>();
// Add Customers
//var justin = new PatientForm
//{
//var user = new IdentityUser("tenece");
// userManager.CreateAsync(user, "%ten");
var mike = new Physician
{
Id = 2,
PhysicianName = "Dave bane"
};
context.Physicians.Add(mike);
var pat = new PatientForm
{
Id = 1,
Fullname = "Justin Noon",
Age = 27,
ClinicalDiagnosis = "RVS",
ClinicNo = 3,
DepartmentId = 3,
//Test = new PatientTest
//{
// t
//}
//PhysicianId = 2,
//Test = 5,
//Department = "Infection and Disease"
};
context.Patients.Add(pat);
var arv = new PatientTest
{
TestId = 5,
TestName = "HIV",
DepartmentId = 3
};
context.Tests.Add(arv);
var vir = new TestDepartment
{
DeptId = 3,
Department = "Virus"
};
context.Departments.Add(vir);
//};
var ruth = new TestRegister
{
Id = 1,
Date = DateTime.Now,
PatientId = 1,
TId = 5,
ResultId = 8
};
context.Appointments.Add(ruth);
var res = new TestResult
{
Id = 8,
IsCompleted = true
};
context.Results.Add(res);
context.SaveChanges();
}
}
public void UpdateDepartment(TestDepartment dept)
{
_appDbContext.Departments.Update(dept);
}
public void AddDepartment(TestDepartment dept)
{
_appDbContext.Departments.Add(dept);
}
public void RemoveDepartment(TestDepartment dept)
{
_appDbContext.Departments.Remove(dept);
}
public void Add(TestDepartment TestDept)
{
_TestDeptRepository.Insert(TestDept);
}
