public static void DeleteItem(int pid) { using (var db = new AutoDataContext()) { Receptions reception = new Receptions(); var items_query = from item in db.Reception where item.id == pid select item; if (items_query.Count() == 0) { MessageBox.Show("Delete not completed (error: no correct id Reception table). Please contact service center."); return; } foreach (var item in items_query) { reception = item; } db.Reception.Remove(reception); try { db.SaveChanges();// delete employee } catch (Exception exc) { MessageBox.Show("Delete reception complete with error: " + exc.Message); } } }
public static void DeleteItem(int pid) { using (var db = new AutoDataContext()) { Patients patient = new Patients(); var items_query_employee = from item in db.Patient where item.id == pid select item; if (items_query_employee.Count() == 0) { MessageBox.Show("Delete not completed (error: no correct id Employees table). Please contact service center."); return; } foreach (var item in items_query_employee) { patient = item; } db.Patient.Remove(patient); try { db.SaveChanges();// delete employee } catch (Exception exc) { MessageBox.Show("Delete patient complete with error: " + exc.Message); } } }
/* * Update new row in table * Return * true if added sucsessfull * false if don' added (have error message) */ public static bool UpdateItem(int pid, string pFirstName, string pMiddleName, string pLastName, string pGender, string pPhoneNumber) { if (pFirstName.Trim() == "") { MessageBox.Show("Enter first name"); return(false); } if (pLastName.Trim() == "") { MessageBox.Show("Enter last name"); return(false); } using (var db = new AutoDataContext()) { Patients patient = db.Patient.Find(pid); patient.firstName = pFirstName; patient.middleName = pMiddleName; patient.lastName = pLastName; patient.gender = pGender; patient.phoneNumber = pPhoneNumber; db.SaveChanges();// update row return(true); } }
/* * Update new row in table Doctor * Return * true if added sucsessfull * false if don' added (have error message) */ public static bool UpdateItem(int pid, string pFirstName, string pMiddleName, string pLastName, double pRate) { if (pFirstName.Trim() == "") { MessageBox.Show("Enter first name"); return(false); } if (pLastName.Trim() == "") { MessageBox.Show("Enter last name"); return(false); } using (var db = new AutoDataContext()) { Doctors doc = db.Doctor.Find(pid); doc.firstName = pFirstName; doc.middleName = pMiddleName; doc.lastName = pLastName; doc.hourRate = pRate; db.SaveChanges();// update row return(true); } }
/* * Update new row in table * Return * true if added sucsessfull * false if don' added (have error message) */ public static bool UpdateItem(int pid, Patients patient, double cost, DateTime dateNext, string completedWork) { if (patient.id == 0) { MessageBox.Show("Patient not select"); return(false); } using (var db = new AutoDataContext()) { Receptions reception = db.Reception.Find(pid); reception.patientid = patient.id; reception.cost = cost; reception.dateNext = dateNext; reception.completedWork = completedWork; db.SaveChanges();// update row return(true); } }
/* * Add new row in table * Returnpost * true if added sucsessfull * false if don' added (have error message) */ public static bool NewItem(string pFirstName, string pMiddleName, string pLastName, string pGender, string pPhoneNumber) { if (pFirstName.Trim() == "") { MessageBox.Show("Enter first name"); return(false); } if (pLastName.Trim() == "") { MessageBox.Show("Enter last name"); return(false); } using (var db = new AutoDataContext()) { var items_query_employee = from item in db.Patient where item.firstName == pFirstName.Trim() & item.middleName == pMiddleName.Trim() & item.lastName == pLastName.Trim() select item; if (items_query_employee.Count() != 0) { MessageBox.Show("Patient '" + pFirstName + pMiddleName + pLastName + "' already entered." + Environment.NewLine + "Saving cancelled!"); return(false); } Patients patient = new Patients(); patient.firstName = pFirstName; patient.middleName = pMiddleName; patient.lastName = pLastName; patient.gender = pGender; patient.phoneNumber = pPhoneNumber; db.Patient.Add(patient); db.SaveChanges();// add new patient return(true); } }
/* * Add new row in table Doctor * Returnpost * true if added sucsessfull * false if don' added (have error message) */ public static bool NewItem(string pFirstName, string pMiddleName, string pLastName, double pRate) { if (pFirstName.Trim() == "") { MessageBox.Show("Enter first name"); return(false); } if (pLastName.Trim() == "") { MessageBox.Show("Enter last name"); return(false); } using (var db = new AutoDataContext()) { var items_query_employee = from item in db.Doctor where item.firstName == pFirstName.Trim() & item.middleName == pMiddleName.Trim() & item.lastName == pLastName.Trim() select item; if (items_query_employee.Count() != 0) { MessageBox.Show("Doctor '" + pFirstName + pMiddleName + pLastName + "' already entered." + Environment.NewLine + "Saving cancelled!"); return(false); } Doctors doc = new Doctors(); doc.firstName = pFirstName; doc.middleName = pMiddleName; doc.lastName = pLastName; doc.hourRate = pRate; db.Doctor.Add(doc); db.SaveChanges();// add new employee return(true); } }
/* * Add new row in table * Returnpost * true if added sucsessfull * false if don' added (have error message) */ public static bool NewItem(Patients patient, double cost, DateTime dateNext, string completedWork) { if (patient.id == 0) { MessageBox.Show("Patient not select"); return(false); } using (var db = new AutoDataContext()) { Receptions reception = new Receptions(); reception.patientid = patient.id; reception.cost = cost; reception.dateNext = dateNext; reception.completedWork = completedWork; db.Reception.Add(reception); db.SaveChanges();// add new return(true); } }