public void Delete(Hospital_Entity_Framework.Management management)
{
var delete = _db.Managements.Single(v => v.Id == management.Id);
_db.Managements.Remove(delete);
_db.SaveChanges();
}
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();
}
private void Insert(int accId)
{
var insert = new Hospital_Entity_Framework.Management()
{
AccountId = accId
};
_db.Managements.Add(insert);
_db.SaveChanges();
}
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);
}