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);
}
}
