private void Load() { ListBoxView.Items.Clear(); //clear listbox using (var db = new AutoDataContext()) //load values into listbox { var query = from item in db.Patient orderby item.lastName, item.firstName, item.middleName select new { id = item.id, firstName = item.firstName, lastName = item.lastName, middleName = item.middleName, gender = item.gender, phoneNumber = item.phoneNumber } ; var arr = query.ToArray(); foreach (var record in arr) { Patient lst = new Patient(record.id , record.lastName + " " + record.firstName + " " + record.middleName , record.gender , record.phoneNumber ); ListBoxView.Items.Add(lst); } } }
public void Load() { listReception.Clear(); using (var db = new AutoDataContext())//load values into listbox { var query = from item in db.Reception join patient in db.Patient on item.patientid equals patient.id orderby item.dateNext select new { id = item.id, patient = patient, fio = patient.lastName + " " + patient.firstName + " " + patient.middleName, cost = item.cost, dateNext = item.dateNext, completedWork = item.completedWork } ; var arr = query.ToArray(); foreach (var record in arr) { Reception lst = new Reception(record.id , record.fio , record.cost , record.dateNext , record.completedWork ); listReception.Add(lst); } } }
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); } } }
/* * 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); } }
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); } } }
public ActionResult ISBNNumber() { string term = Session["value"].ToString(); var db = new AutoDataContext(); var result1 = from c in db.InfoBooks where c.BookName.ToUpper().Contains(term.ToUpper()) select c.ISBN.Trim(); return Json(result1, JsonRequestBehavior.AllowGet); }
/* * 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); } }
public ActionResult Books() { var db = new AutoDataContext(); //var result = db.InfoBooks.Select(p => p.BookName).ToList(); var result1 = from c in db.InfoBooks join p in db.BookImages on c.Book_ID equals p.BookID select new { c.AuthorName, c.BookName, c.Category, p.Description1 }; return Json(result1, JsonRequestBehavior.AllowGet); }
public ActionResult Autocomplete(string term) { var db = new AutoDataContext(); Session["value"] = term; var result = from c in db.InfoBooks.Select(p => p.BookName).Where(p => p.ToUpper().Contains(term.ToUpper())) select c.TrimStart().TrimEnd(); return Json(result, JsonRequestBehavior.AllowGet); }
public static Receptions GetItem(int pid) { Receptions reception = new Receptions(); using (var db = new AutoDataContext()) { reception = db.Reception.Find(pid); } return(reception); }
public static Patients GetItem(int pid) { Patients patient = new Patients(); using (var db = new AutoDataContext()) { patient = db.Patient.Find(pid); } return(patient); }
/* * 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); } }
private void Load() { if (Param.lastWindow != null) { if (Param.lastWindow.Equals("ListReception")) { ButtonAdd.Content = "Обновить"; //change name button using (var db = new AutoDataContext()) { var query = from item in db.Reception join patient in db.Patient on item.patientid equals patient.id orderby item.dateNext where item.id == Param.id select new { id = item.id, patient = patient, fio = patient.lastName + " " + patient.firstName + " " + patient.middleName, cost = item.cost, dateNext = item.dateNext, completedWork = item.completedWork } ; var arr = query.ToArray(); foreach (var record in arr) { RichEditCompletedWork.Document = new FlowDocument(); TextBoxPatient.Text = record.fio; TextBoxCost.Text = record.cost.ToString(); DatePicker.SelectedDate = record.dateNext; RichEditCompletedWork.AppendText(record.completedWork); patient = record.patient; } } } } }
/* * 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); } }
private void Load() { if (Param.lastWindow != null) { if (Param.lastWindow.Equals("ListPatient")) { ButtonAdd.Content = "Обновить"; //change name button using (var db = new AutoDataContext()) { var query = from item in db.Patient orderby item.lastName, item.firstName, item.middleName where item.id == Param.id select new { id = item.id, firstName = item.firstName, lastName = item.lastName, middleName = item.middleName, gender = item.gender, phoneNumber = item.phoneNumber } ; var arr = query.ToArray(); foreach (var record in arr) { TextBoxFirstName.Text = record.firstName; TextBoxLastName.Text = record.lastName; TextBoxMiddleName.Text = record.middleName; ComboBoxGender.Text = record.gender; TextBoxPhoneNumber.Text = record.phoneNumber; } } } } }
public ActionResult Decription(string tags) { var db = new AutoDataContext(); var result = (from c in db.BookImages select c.Description1.Contains(tags)).Take(1); return Json(result, JsonRequestBehavior.AllowGet); }