private void DeleteForm(Hospital_Entity_Framework.Account acc) { var getManagement = _db.Managements.FirstOrDefault(v => v.AccountId == acc.Id); if (getManagement != null) { if (getManagement.Forms != null) { foreach (var item in getManagement.Forms.ToList()) { if (item.Id == 6) { continue; } var getItem = _db.Forms.First(v => v.Id == item.Id); getManagement.Forms.Remove(getItem); } } } else { var insert = new Hospital_Entity_Framework.Management() { AccountId = acc.Id }; _db.Managements.Add(insert); } _db.SaveChanges(); }
public void SubmitManagement(Hospital_Entity_Framework.Account acc) { DeleteForm(acc); var getTemp = _db.TempManagements; var getManagement = _db.Managements.First(v => v.AccountId == acc.Id); foreach (var itemTemp in getTemp) { if (itemTemp.Forms == "Worker's Form") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.Forms.First(v => v.Id == get); getManagement.Forms.Add(chk); } if (itemTemp.Forms == "Patient's Form") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.Forms.First(v => v.Id == get); getManagement.Forms.Add(chk); } if (itemTemp.Forms == "CheckIn's Form") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.Forms.First(v => v.Id == get); getManagement.Forms.Add(chk); } if (itemTemp.Forms == "Management's Form") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.Forms.First(v => v.Id == get); getManagement.Forms.Add(chk); } if (itemTemp.Forms == "Sample's Form") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.Forms.First(v => v.Id == get); getManagement.Forms.Add(chk); } if (itemTemp.Forms == "Category's Form") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.Forms.First(v => v.Id == get); getManagement.Forms.Add(chk); } if (itemTemp.Forms == "Admin's Form") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.Forms.First(v => v.Id == get); getManagement.Forms.Add(chk); } if (itemTemp.Forms == "WaitingList's Form") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.Forms.First(v => v.Id == get); getManagement.Forms.Add(chk); } } _db.SaveChanges(); }
public void DeleteManagementAndAccount(Hospital_Entity_Framework.Account acc) { DeleteCategory(acc); DeleteForm(acc); var delete = _db.Managements.First(v => v.AccountId == acc.Id); _db.Managements.Remove(delete); _db.Accounts.Remove(acc); _db.SaveChanges(); }
private void DeleteCategory(Hospital_Entity_Framework.Account acc) { var getManagement = _db.Managements.FirstOrDefault(v => v.AccountId == acc.Id); if (getManagement != null) { if (getManagement.ConsultationCategories != null) { foreach (var item in getManagement.ConsultationCategories.ToList()) { var getItem = _db.ConsultationCategories.FirstOrDefault(v => v.Id == item.Id); getManagement.ConsultationCategories.Remove(getItem); } } if (getManagement.LaboratoryCategories != null) { foreach (var item in getManagement.LaboratoryCategories.ToList()) { var getItem = _db.LaboratoryCategories.First(v => v.Id == item.Id); getManagement.LaboratoryCategories.Remove(getItem); } } if (getManagement.MedicalImagingCategories != null) { foreach (var item in getManagement.MedicalImagingCategories.ToList()) { var getItem = _db.MedicalImagingCategories.First(v => v.Id == item.Id); getManagement.MedicalImagingCategories.Remove(getItem); } } if (getManagement.PrescriptionCategories != null) { foreach (var item in getManagement.PrescriptionCategories.ToList()) { var getItem = _db.PrescriptionCategories.First(v => v.Id == item.Id); getManagement.PrescriptionCategories.Remove(getItem); } } if (getManagement.VariousDocumentCategories != null) { foreach (var item in getManagement.VariousDocumentCategories.ToList()) { var getItem = _db.VariousDocumentCategories.First(v => v.Id == item.Id); getManagement.VariousDocumentCategories.Remove(getItem); } } if (getManagement.Forms.Any(v => v.Name == "Medical's Form")) { var getItem = _db.Forms.First(v => v.Name == "Medical's Form"); getManagement.Forms.Remove(getItem); } _db.SaveChanges(); } }
public void Insert(int workerId, string username, string password) { var check = _db.Accounts.Any(v => v.WorkerId == workerId); if (check) { return; } var insert = new Hospital_Entity_Framework.Account { WorkerId = workerId, UserName = username, Password = password }; _db.Accounts.Add(insert); _db.SaveChanges(); }
public Hospital_Entity_Framework.Account Selection(Hospital_Entity_Framework.Worker worker) { var selection = from v in _db.Accounts where v.WorkerId == worker.Id select new { v.Id, v.WorkerId, v.UserName, v.Password }; foreach (var item in selection) { var account = new Hospital_Entity_Framework.Account() { Id = item.Id, WorkerId = item.WorkerId, UserName = item.UserName, Password = item.Password }; return(account); } return(null); }
public FlowLayoutPanel ButtonToForm(Hospital_Entity_Framework.Account account) { var flpn = new FlowLayoutPanel() { FlowDirection = FlowDirection.TopDown, Dock = DockStyle.Fill, Name = @"flpnButtonForm", AutoScroll = true, WrapContents = false }; _account = account; var firstOrDefault = _db.Managements.FirstOrDefault(v => v.AccountId == account.Id); if (firstOrDefault != null) { var checkForm = firstOrDefault.Forms; foreach (var form in checkForm) { var color = ColorTranslator.FromHtml("#3399FF"); var btn = new Button { Font = new Font("Nova Cut", 12), Text = form.Name.Remove(form.Name.Length - 7), Height = 50, Width = flpn.Width, BackColor = Color.FromArgb(128, color) }; btn.MouseHover += MouseHover; btn.MouseLeave += MouseLeave; btn.Click += OpenForm; flpn.Controls.Add(btn); } } return(flpn); }
public void ClearCatergory(Hospital_Entity_Framework.Account acc, CategorySelection categorySelection) { var chk = _db.TempManagements.Where(v => v.Forms == "Medical's Form"); foreach (var item in chk.Where(v => v.Services == "Consultation")) { _db.TempManagements.Remove(item); } foreach (var item in chk.Where(v => v.Services == "Laboratory")) { _db.TempManagements.Remove(item); } foreach (var item in chk.Where(v => v.Services == "MedicalImaging")) { _db.TempManagements.Remove(item); } foreach (var item in chk.Where(v => v.Services == "Prescription")) { _db.TempManagements.Remove(item); } foreach (var item in chk.Where(v => v.Services == "VariousDocument")) { _db.TempManagements.Remove(item); } _db.SaveChanges(); categorySelection.tabCategory.Controls.Clear(); categorySelection.Account = _account; categorySelection.tabCategory.Controls.AddRange(new Control[] { TabConsultation(acc, categorySelection), TabLaboratory(acc, categorySelection), TabMedicalImaging(acc, categorySelection), TabPrescription(acc, categorySelection), TabVariousDocument(acc, categorySelection) }); }
public TabPage TabVariousDocument(Hospital_Entity_Framework.Account acc, CategorySelection categorySelection) { var tab = new TabPage() { AutoScroll = true, Text = @"VariousDocument", Name = @"VariousDocument" }; var flpn = new FlowLayoutPanel() { Dock = DockStyle.Fill, AutoScroll = true }; flpn.Controls.Clear(); _categorySelection = null; _categorySelection = categorySelection; _account = acc; var getTemp = _db.TempManagements.Where(v => v.Forms == "Medical's Form").Where(v => v.Services == "VariousDocument"); var getCategory = _db.VariousDocumentCategories; foreach (var itemCategory in getCategory) { if (getTemp.Any(v => v.Categorys == itemCategory.Id.ToString())) { var dic = new Dictionary <int, string> { { acc.WorkerId, "VariousDocument" } }; var btn = new Button { Size = new Size(180, 90), Text = itemCategory.Name, Name = itemCategory.Id.ToString(), BackColor = Color.LimeGreen, Font = new Font("November", 12), Tag = dic }; flpn.Controls.Add(btn); btn.Click += RemoveCategory_Click; } else { var dic = new Dictionary <int, string> { { acc.WorkerId, "VariousDocument" } }; var btn = new Button { Location = new Point(3, 3), Size = new Size(180, 90), Text = itemCategory.Name, Name = itemCategory.Id.ToString(), BackColor = Color.Khaki, Font = new Font("November", 12), Tag = dic }; flpn.Controls.Add(btn); btn.Click += TakeCategory_Click; } } tab.Controls.Add(flpn); return(tab); }
public TabPage TabConsultation(Hospital_Entity_Framework.Account acc, CategorySelection categorySelection) { var tab = new TabPage() { AutoScroll = true, Text = @"Consultation", Name = @"Consultation" }; var flpn = new FlowLayoutPanel() { Dock = DockStyle.Fill, AutoScroll = true }; flpn.Controls.Clear(); _categorySelection = null; _categorySelection = categorySelection; _account = acc; var chkMedicalForm = _db.TempManagements.Where(v => v.WorkerId == acc.WorkerId) .Any(v => v.Forms == "Medical's Form"); if (chkMedicalForm) { var getTemp = _db.TempManagements.Where(v => v.Forms == "Medical's Form").Where(v => v.Services == "Consultation"); var getCategory = _db.ConsultationCategories; foreach (var itemCategory in getCategory) { if (getTemp.Any(v => v.Categorys == itemCategory.Id.ToString())) { var dic = new Dictionary <int, string> { { acc.WorkerId, "Consultation" } }; var btn = new Button { Size = new Size(180, 90), Text = itemCategory.Name, Name = itemCategory.Id.ToString(), BackColor = Color.LimeGreen, Font = new Font("November", 12), Tag = dic }; flpn.Controls.Add(btn); btn.Click += RemoveCategory_Click; } else { var dic = new Dictionary <int, string> { { acc.WorkerId, "Consultation" } }; var btn = new Button { Location = new Point(3, 3), Size = new Size(180, 90), Text = itemCategory.Name, Name = itemCategory.Id.ToString(), BackColor = Color.Khaki, Font = new Font("November", 12), Tag = dic }; flpn.Controls.Add(btn); btn.Click += TakeCategory_Click; } } } else { var getManagement = _db.Managements.Any(v => v.AccountId == acc.Id); if (getManagement) { var getCategoryforManagement = _db.Managements.First(v => v.AccountId == acc.Id); if (getCategoryforManagement.ConsultationCategories != null) { foreach (var item in getCategoryforManagement.ConsultationCategories.ToList()) { var insertTemp = new TempManagement() { WorkerId = acc.WorkerId, Forms = "Medical's Form", Services = "Consultation", Categorys = item.Id.ToString() }; _db.TempManagements.Add(insertTemp); } } if (getCategoryforManagement.LaboratoryCategories != null) { foreach (var item in getCategoryforManagement.LaboratoryCategories.ToList()) { var insertTemp = new TempManagement() { WorkerId = acc.WorkerId, Forms = "Medical's Form", Services = "Laboratory", Categorys = item.Id.ToString() }; _db.TempManagements.Add(insertTemp); } } if (getCategoryforManagement.MedicalImagingCategories != null) { foreach (var item in getCategoryforManagement.MedicalImagingCategories.ToList()) { var insertTemp = new TempManagement() { WorkerId = acc.WorkerId, Forms = "Medical's Form", Services = "MedicalImaging", Categorys = item.Id.ToString() }; _db.TempManagements.Add(insertTemp); } } if (getCategoryforManagement.PrescriptionCategories != null) { foreach (var item in getCategoryforManagement.PrescriptionCategories.ToList()) { var insertTemp = new TempManagement() { WorkerId = acc.WorkerId, Forms = "Medical's Form", Services = "Prescription", Categorys = item.Id.ToString() }; _db.TempManagements.Add(insertTemp); } } if (getCategoryforManagement.VariousDocumentCategories != null) { foreach (var item in getCategoryforManagement.VariousDocumentCategories.ToList()) { var insertTemp = new TempManagement() { WorkerId = acc.WorkerId, Forms = "Medical's Form", Services = "VariousDocument", Categorys = item.Id.ToString() }; _db.TempManagements.Add(insertTemp); } } _db.SaveChanges(); var getTemp = _db.TempManagements.Where(v => v.Forms == "Medical's Form").Where(v => v.Services == "Consultation"); var getCategory = _db.ConsultationCategories; foreach (var itemCategory in getCategory) { if (getTemp.Any(v => v.Categorys == itemCategory.Id.ToString())) { var dic = new Dictionary <int, string> { { acc.WorkerId, "Consultation" } }; var btn = new Button { Size = new Size(180, 90), Text = itemCategory.Name, Name = itemCategory.Id.ToString(), BackColor = Color.LimeGreen, Font = new Font("November", 12), Tag = dic }; flpn.Controls.Add(btn); btn.Click += RemoveCategory_Click; } else { var dic = new Dictionary <int, string> { { acc.WorkerId, "Consultation" } }; var btn = new Button { Location = new Point(3, 3), Size = new Size(180, 90), Text = itemCategory.Name, Name = itemCategory.Id.ToString(), BackColor = Color.Khaki, Font = new Font("November", 12), Tag = dic }; flpn.Controls.Add(btn); btn.Click += TakeCategory_Click; } } } else { var create = new Hospital_Entity_Framework.Management() { AccountId = acc.Id }; _db.Managements.Add(create); _db.SaveChanges(); var getTemp = _db.TempManagements.Where(v => v.Forms == "Medical's Form").Where(v => v.Services == "Consultation"); var getCategory = _db.ConsultationCategories; foreach (var itemCategory in getCategory) { if (getTemp.Any(v => v.Categorys == itemCategory.Id.ToString())) { var dic = new Dictionary <int, string> { { acc.WorkerId, "Consultation" } }; var btn = new Button { Size = new Size(180, 90), Text = itemCategory.Name, Name = itemCategory.Id.ToString(), BackColor = Color.LimeGreen, Font = new Font("November", 12), Tag = dic }; flpn.Controls.Add(btn); btn.Click += RemoveCategory_Click; } else { var dic = new Dictionary <int, string> { { acc.WorkerId, "Consultation" } }; var btn = new Button { Location = new Point(3, 3), Size = new Size(180, 90), Text = itemCategory.Name, Name = itemCategory.Id.ToString(), BackColor = Color.Khaki, Font = new Font("November", 12), Tag = dic }; flpn.Controls.Add(btn); btn.Click += TakeCategory_Click; } } } } tab.Controls.Add(flpn); return(tab); }
public void SubmitCategory(Hospital_Entity_Framework.Account acc, CategorySelection categorySelection) { DeleteCategory(acc); var getTemp = _db.TempManagements.Where(v => v.WorkerId == acc.WorkerId && v.Forms == "Medical's Form"); var getManagement = _db.Managements.First(v => v.AccountId == acc.Id); var getItem = _db.Forms.First(v => v.Name == "Medical's Form"); getManagement.Forms.Add(getItem); foreach (var itemTemp in getTemp) { if (itemTemp.Services == "Consultation") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.ConsultationCategories.First(v => v.Id == get); getManagement.ConsultationCategories.Add(chk); } if (itemTemp.Services == "Laboratory") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.LaboratoryCategories.First(v => v.Id == get); getManagement.LaboratoryCategories.Add(chk); } if (itemTemp.Services == "MedicalImaging") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.MedicalImagingCategories.First(v => v.Id == get); getManagement.MedicalImagingCategories.Add(chk); } if (itemTemp.Services == "Prescription") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.PrescriptionCategories.First(v => v.Id == get); getManagement.PrescriptionCategories.Add(chk); } if (itemTemp.Services == "VariousDocument") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.VariousDocumentCategories.First(v => v.Id == get); getManagement.VariousDocumentCategories.Add(chk); } if (itemTemp.Services == "Medical's Form") { var get = Convert.ToInt32(itemTemp.Categorys); var chk = _db.Forms.First(v => v.Id == get); getManagement.Forms.Add(chk); } } _db.SaveChanges(); categorySelection.tabCategory.Controls.Clear(); categorySelection.Account = _account; categorySelection.tabCategory.Controls.AddRange(new Control[] { TabConsultation(acc, categorySelection), TabLaboratory(acc, categorySelection), TabMedicalImaging(acc, categorySelection), TabPrescription(acc, categorySelection), TabVariousDocument(acc, categorySelection) }); categorySelection.tabCategory.Enabled = false; categorySelection.tabCategory.SelectTab("Consultation"); categorySelection.tabCategory.Enabled = true; }