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