public static int?GetManagerIdByUsername(string username) //get id of given username
{
DataClasses1DataContext dc = new DataClasses1DataContext();
var res = from p in dc.Laboratory_managers
where (p.user_name.Equals(username))
select p;
Laboratory_manager tmp = res.FirstOrDefault();
if (tmp != null)
{
return(res.FirstOrDefault().id_laboratory_manager);
}
else
{
return(null);
}
}
private void SeedLaboratoryManagers(DataClasses1DataContext dc, ref int index_labm)
{
var labmIdsOfCurrentLabms = from el in dc.Laboratory_managers
where el.user_name.Equals("labm")
select el.id_laboratory_manager;
if (labmIdsOfCurrentLabms.Any())
{
index_labm = labmIdsOfCurrentLabms.First();
}
else
{
Laboratory_manager labm = new Laboratory_manager();
labm.user_name = "labm";
dc.Laboratory_managers.InsertOnSubmit(labm);
dc.SubmitChanges();
}
}
private void Initialize()
{
if (id_exam != 0)
{
Laboratory_examination labExam = CommonFacade.GetLabExam(id_exam);
Patient patient = CommonFacade.GetPatientByVisit(labExam.id_visit);
LabExaminationPatientFirstNameTextBox.Text = patient.fname;
LabExaminationPatientLastNameTextBox.Text = patient.lname;
LabExaminationPatientPeselTextBox.Text = patient.PESEL;
LabExaminationExamTypeComboBox.Items.Add(CommonFacade.GetExamCodeName(labExam.code));
LabExaminationExamTypeComboBox.SelectedIndex = 0;
string state;
switch (labExam.state)
{
case ("ORD"):
state = "Ordered";
break;
case ("DONE"):
state = "Waiting for approval";
break;
case ("APP"):
state = "Approved";
break;
case ("CANC_LABW"):
state = "Canceled by laboratory worker";
break;
case ("CANC_LABM"):
state = "Canceled by laboratory manager";
break;
default:
state = "";
break;
}
LabExaminationExamStateComboBox.Items.Add(state);
LabExaminationExamStateComboBox.SelectedIndex = 0;
DataLayer.Doctor doctor = CommonFacade.GetDoctorByVisit(labExam.id_visit);
LabExaminationDoctorFirstNameTextBox.Text = doctor.User.fname;
LabExaminationDoctorLastNameTextBox.Text = doctor.User.lname;
LabExaminationExamOrderDateTimePicker.Value = labExam.order_date;
LabExaminationDoctorCommentsTextBox.Text = labExam.doctor_comments;
if (labExam.id_laboratory_woker != null)
{
Laboratory_worker labw = CommonFacade.GetLabW(labExam.id_laboratory_woker.Value);
LabExaminationLabWorkerFirstNameTextBox.Text = labw.User.fname;
LabExaminationLabWorkerLastNameTextBox.Text = labw.User.lname;
}
if (labExam.examination_execution_date == null)
{
LabExaminationExamExaminationDateTimePicker.CustomFormat = " ";
LabExaminationExamExaminationDateTimePicker.Format = DateTimePickerFormat.Custom;
}
else
{
LabExaminationExamExaminationDateTimePicker.CustomFormat = "dd/MM/yyyy hh:mm:ss";
LabExaminationExamExaminationDateTimePicker.Value = labExam.examination_execution_date.Value;
}
LabExaminationExamResultTextBox.Text = labExam.result;
if (labExam.id_laboratory_manager != null)
{
Laboratory_manager labm = CommonFacade.GetLabM(labExam.id_laboratory_manager.Value);
LabExaminationLabManagerFirstNameTextBox.Text = labm.User.fname;
LabExaminationLabManagerLastNameTextBox.Text = labm.User.lname;
}
if (labExam.examination_approval_date == null)
{
LabExaminationExamApprovalDateTimePicker.CustomFormat = " ";
LabExaminationExamApprovalDateTimePicker.Format = DateTimePickerFormat.Custom;
}
else
{
LabExaminationExamApprovalDateTimePicker.CustomFormat = "dd/MM/yyyy hh:mm:ss";
LabExaminationExamApprovalDateTimePicker.Value = labExam.examination_approval_date.Value;
}
LabExaminationLabManagerCommentsTextBox.Text = labExam.lab_manager_comments;
}
}
private void SetWindowMode(int mode)//0 - lab worker, 1 - lab manager
{
switch (mode)
{
case 0:
{ //lab worker
//patient
//LabExaminationPatientFirstNameTextBox.ReadOnly = true;
//LabExaminationPatientLastNameTextBox.ReadOnly = true;
//LabExaminationPatientPeselTextBox.ReadOnly = true;
////doctor
//LabExaminationDoctorFirstNameTextBox.ReadOnly = true;
//LabExaminationDoctorLastNameTextBox.ReadOnly = true;
//LabExaminationDoctorCommentsTextBox.ReadOnly = true;
//lab worker
//LabExaminationLabWorkerFirstNameTextBox.ReadOnly = true;
//LabExaminationLabWorkerLastNameTextBox.ReadOnly = true;
LabExaminationExamResultTextBox.ReadOnly = false;
LabExaminationExamResultTextBox.Enabled = true;
LabExaminationLabWorkerSubmitButton.Enabled = true;
LabExaminationLabWorkerCancelButton.Enabled = true;
//lab manager
//LabExaminationLabManagerFirstNameTextBox.ReadOnly = true;
//LabExaminationLabManagerLastNameTextBox.ReadOnly = true;
LabExaminationLabManagerCommentsTextBox.ReadOnly = true;
LabExaminationLabManagerApproveButton.Enabled = false;
LabExaminationLabManagerCancelButton.Enabled = false;
//other
//LabExaminationExamStateComboBox.Enabled = false;
//LabExaminationExamTypeComboBox.Enabled = false;
//LabExaminationExamOrderDateTimePicker.Enabled = false;
Laboratory_worker labW = CommonFacade.GetLabW(id_user);
LabExaminationLabWorkerFirstNameTextBox.Text = labW.User.fname;
LabExaminationLabWorkerLastNameTextBox.Text = labW.User.lname;
//LabExaminationExamExaminationDateTimePicker.CustomFormat = "dd/MM/yyyy hh:mm:ss";
LabExaminationExamExaminationDateTimePicker.Format = DateTimePickerFormat.Long;
LabExaminationExamExaminationDateTimePicker.Value = DateTime.Now;
}
break;
case 1:
{ //lab manager
//patient
//LabExaminationPatientFirstNameTextBox.ReadOnly = true;
//LabExaminationPatientLastNameTextBox.ReadOnly = true;
//LabExaminationPatientPeselTextBox.ReadOnly = true;
////doctor
//LabExaminationDoctorFirstNameTextBox.ReadOnly = true;
//LabExaminationDoctorLastNameTextBox.ReadOnly = true;
//LabExaminationDoctorCommentsTextBox.ReadOnly = true;
//lab worker
//LabExaminationLabWorkerFirstNameTextBox.ReadOnly = true;
//LabExaminationLabWorkerLastNameTextBox.ReadOnly = true;
LabExaminationExamResultTextBox.ReadOnly = true;
LabExaminationLabWorkerSubmitButton.Enabled = false;
LabExaminationLabWorkerCancelButton.Enabled = false;
//lab manager
//LabExaminationLabManagerFirstNameTextBox.ReadOnly = true;
//LabExaminationLabManagerLastNameTextBox.ReadOnly = true;
LabExaminationLabManagerCommentsTextBox.ReadOnly = false;
LabExaminationLabManagerCommentsTextBox.Enabled = true;
LabExaminationLabManagerApproveButton.Enabled = true;
LabExaminationLabManagerCancelButton.Enabled = true;
//other
//LabExaminationExamStateComboBox.Enabled = false;
//LabExaminationExamTypeComboBox.Enabled = false;
//LabExaminationExamOrderDateTimePicker.Enabled = false;
Laboratory_manager labM = CommonFacade.GetLabM(id_user);
LabExaminationLabManagerFirstNameTextBox.Text = labM.User.fname;
LabExaminationLabManagerLastNameTextBox.Text = labM.User.lname;
LabExaminationExamApprovalDateTimePicker.Format = DateTimePickerFormat.Long;
LabExaminationExamApprovalDateTimePicker.Value = DateTime.Now;
}
break;
default:
{ //read only
////patient
//LabExaminationPatientFirstNameTextBox.ReadOnly = true;
//LabExaminationPatientLastNameTextBox.ReadOnly = true;
//LabExaminationPatientPeselTextBox.ReadOnly = true;
LabExaminationPatientFirstNameTextBox.Enabled = false;
LabExaminationPatientLastNameTextBox.Enabled = false;
LabExaminationPatientPeselTextBox.Enabled = false;
////doctor
//LabExaminationDoctorFirstNameTextBox.ReadOnly = true;
//LabExaminationDoctorLastNameTextBox.ReadOnly = true;
//LabExaminationDoctorCommentsTextBox.ReadOnly = true;
LabExaminationDoctorFirstNameTextBox.Enabled = false;
LabExaminationDoctorLastNameTextBox.Enabled = false;
LabExaminationDoctorCommentsTextBox.Enabled = false;
////lab worker
//LabExaminationLabWorkerFirstNameTextBox.ReadOnly = true;
//LabExaminationLabWorkerLastNameTextBox.ReadOnly = true;
LabExaminationLabWorkerFirstNameTextBox.Enabled = false;
LabExaminationLabWorkerLastNameTextBox.Enabled = false;
LabExaminationExamResultTextBox.Enabled = false;
LabExaminationExamResultTextBox.ReadOnly = true;
LabExaminationLabWorkerSubmitButton.Enabled = false;
LabExaminationLabWorkerCancelButton.Enabled = false;
//lab manager
//LabExaminationLabManagerFirstNameTextBox.ReadOnly = true;
//LabExaminationLabManagerLastNameTextBox.ReadOnly = true;
LabExaminationLabManagerFirstNameTextBox.Enabled = false;
LabExaminationLabManagerLastNameTextBox.Enabled = false;
LabExaminationLabManagerCommentsTextBox.Enabled = false;
LabExaminationLabManagerCommentsTextBox.ReadOnly = true;
LabExaminationLabManagerApproveButton.Enabled = false;
LabExaminationLabManagerCancelButton.Enabled = false;
//other
//LabExaminationExamStateComboBox.Enabled = false;
//LabExaminationExamTypeComboBox.Enabled = false;
//LabExaminationExamOrderDateTimePicker.Enabled = false;
}
break;
}
}
