public static void updateLabolatoryExamination(int idExamination, string exam_code, string commentDoctor)
{
DataClassesDataContext db = new DataClassesDataContext();
Examination_Laboratory update = db.Examination_Laboratory.Single(row => row.Id_Examination == idExamination);
update.Exam_Code = exam_code;
update.Comments_Doctor = commentDoctor;
db.SubmitChanges();
}
public static void updateLabExam(int id, string state, string result, string comment_lab, int nic)
{ //napisać ifa czy są dane
DataClassesDataContext db = new DataClassesDataContext();
Examination_Laboratory update = db.Examination_Laboratory.Single(row => row.Id_Examination == id);
update.Result = result;
update.State = state;
update.Comments_Man_Lab = comment_lab;
db.SubmitChanges();
}
public static void insertLabolatoryExamination(int idAppointment, string exam_code, string commentDoctor)
{
DataClassesDataContext db = new DataClassesDataContext();
Examination_Laboratory addLabolatoryExamination = new Examination_Laboratory();
addLabolatoryExamination.Id_Appointment = idAppointment;
addLabolatoryExamination.Comments_Doctor = commentDoctor;
addLabolatoryExamination.Exam_Code = exam_code;
addLabolatoryExamination.Date_Of_Order = DateTime.Today;
addLabolatoryExamination.State = "ZLE";
db.Examination_Laboratory.InsertOnSubmit(addLabolatoryExamination);
db.SubmitChanges();
}