public static void insert2patient(PATIENT newPatient)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
/*
* //Create new patent
* PATIENT newPatient = new PATIENT();
* newPatient.id = "001";
* newPatient.user_name = "John";
* newPatient.native_name = "Doc.John";
* newPatient.password = "******";
* newPatient.gender = "M";
* newPatient.age = 23;
* newPatient.weight = 2014;
* newPatient.country = "China";
* newPatient.city = "SH";
* newPatient.postal_code = "123456";
* newPatient.address = "Budapest";
*/
//Add new patient to database
db.PATIENT.InsertOnSubmit(newPatient);
//Save changes to Database.
db.SubmitChanges();
}
public static bool deleteDoc(string str_username)
{
bool result = false;
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
try {
//Get DOCTORS to Delete
DOCTORS deleteDoctor = db.DOCTORS.FirstOrDefault(e => e.user_name.Equals(str_username));
//Delete DOCTORS
db.DOCTORS.DeleteOnSubmit(deleteDoctor);
//Save changes to Database.
db.SubmitChanges();
result = true;
}
catch ()
{
result = false
}
return(result);
}
public static void insert2doctors(DOCTORS newDOCTORS)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
/*
* //Create new Doctor
* DOCTORS newDOCTORS = new DOCTORS();
* newDOCTORS.id = "001";
* newDOCTORS.user_name = "John";
* newDOCTORS.native_name = "Doc.John";
* newDOCTORS.password = "******";
* newDOCTORS.gender = "M";
* newDOCTORS.age = 23;
* newDOCTORS.start_year_of_work = 2014;
*/
//Add new DOCTORS to database
db.DOCTORS.InsertOnSubmit(newDOCTORS);
//Save changes to Database.
db.SubmitChanges();
//Get new Inserted Employee
//DOCTORS insertedEmployee = db.DOCTORS.FirstOrDefault(e => e.user_name.Equals("Michael"));
}
/// <summary>
/// PATIENTS
/// </summary>
public static PATIENT selectPatientById(string str_id)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get selected user
PATIENT selectPAT = db.PATIENT.FirstOrDefault(e => e.id.Equals(str_id));
return(selectPAT);
}
/// <summary>
/// SYSTEM_ADMINS
/// </summary>
public static SYSTEM_ADMINS selectByusername(string str_username)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get selected user
SYSTEM_ADMINS selectADM = db.SYSTEM_ADMINS.FirstOrDefault(e => e.username.Equals(str_username));
return(selectADM);
}
/// <summary>
/// DOCTORS
/// </summary>
///
public static DOCTORS selectDocByID(string str_id)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get selected user
DOCTORS selectDoc = db.DOCTORS.FirstOrDefault(e => e.id.Equals(id));
return(selectDoc);
}
///<summary>
///PHARMACIST
/// </summary>
///
public static PHARMACIST selectPHARMACISTByID(string strID)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get selected user
PHARMACIST selectPHA = db.PHARMACIST.FirstOrDefault(e => e.id.Equals(strID));
return(selectPHA);
}
///<summary>
///ORDERS
/// </summary>
public static void insert2Order(ORDERS newOrder)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Add new ORDERS to database
db.ORDERS.InsertOnSubmit(newOrder);
//Save changes to Database.
db.SubmitChanges();
}
///<summary>
///PHARMACIST_OPENTIMES
/// </summary>
public static void insert2PHARMACIST_OPENTIMES(PHARMACIST_OPENTIMES newPHARMACIST_OPENTIMES)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Add new PHARMACIST_OPENTIMES to database
db.PHARMACIST_OPENTIMES.InsertOnSubmit(newPHARMACIST_OPENTIMES);
//Save changes to Database.
db.SubmitChanges();
}
///<summary>
///EXAMINATIONS
/// </summary>
public static void insert2examination(EXAMINATIONS newExamination)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Add new EXAMINATIONS to database
db.EXAMINATIONS.InsertOnSubmit(newExamination);
//Save changes to Database.
db.SubmitChanges();
}
///<summary>
///APPLICATIONS
/// </summary>
public static void insert2applications(APPLICATIONS newAPPLICATIONS)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Add new APPLICATIONS to database
db.APPLICATIONS.InsertOnSubmit(newAPPLICATIONS);
//Save changes to Database.
db.SubmitChanges();
}
///<summary>
///PRESCRIPTIONS
/// </summary>
public static void insert2Precription(PRESCRIPTIONS newPrescription)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Add new PRESCRIPTIONS to database
db.PRESCRIPTIONS.InsertOnSubmit(newPrescription);
//Save changes to Database.
db.SubmitChanges();
}
///<summary>
///SPECIALIZATIONS_OF_DOCTORS
/// </summary>
public static void insert2Docspeci(SPECIALIZATIONS_OF_DOCTORS newDocSpeci)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Add new SPECIALIZATIONS_OF_DOCTORS to database
db.SPECIALIZATIONS_OF_DOCTORS.InsertOnSubmit(newDocSpeci);
//Save changes to Database.
db.SubmitChanges();
}
public static void updateDocspeci(string str_id, SPECIALIZATIONS_OF_DOCTORS updateDocSpeci)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get SPECIALIZATIONS_OF_DOCTORS for update
SPECIALIZATIONS_OF_DOCTORS oldDocSpeci = db.SPECIALIZATIONS_OF_DOCTORS.FirstOrDefault(e => e.id.Equals(str_id));
oldDocSpeci = updateDocSpeci;
//Save changes to Database.
db.SubmitChanges();
}
public static void updatedoctime(string str_id, DOCTOR_OPENTIMES updateDoctime)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get DOCTOR_OPENTIMES for update
DOCTOR_OPENTIMES oldDoctime = db.DOCTOR_OPENTIMES.FirstOrDefault(e => e.id.Equals(str_id));
oldDoctime = updateDoctime;
//Save changes to Database.
db.SubmitChanges();
}
public static void updateexamination(string str_id, EXAMINATIONS newExamination)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get EXAMINATIONS for update
EXAMINATIONS oldExamination = db.EXAMINATIONS.FirstOrDefault(e => e.id.Equals(str_id));
oldExamination = newExamination;
//Save changes to Database.
db.SubmitChanges();
}
public static void updatePrecription(string str_id, PRESCRIPTIONS updatePrescription)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get PRESCRIPTIONS for update
PRESCRIPTIONS oldPrescription = db.PRESCRIPTIONS.FirstOrDefault(e => e.id.Equals(str_id));
oldPrescription = updatePrescription;
//Save changes to Database.
db.SubmitChanges();
}
public static void updatePHARMACIST_OPENTIMES(string str_id, PHARMACIST_OPENTIMES updatePHARMACIST_OPENTIMES)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get PHARMACIST_OPENTIMES for update
PHARMACIST_OPENTIMES oldPHARMACIST_OPENTIMES = db.PHARMACIST_OPENTIMES.FirstOrDefault(e => e.id.Equals(str_id));
oldPHARMACIST_OPENTIMES = updatePHARMACIST_OPENTIMES;
//Save changes to Database.
db.SubmitChanges();
}
public static void updatePrecription(string str_id, ORDERS updateOrder)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get ORDERS for update
ORDERS oldOrder = db.ORDERS.FirstOrDefault(e => e.id.Equals(str_id));
oldOrder = updateOrder;
//Save changes to Database.
db.SubmitChanges();
}
public static void deleteDoctime(string str_id)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get DOCTOR_OPENTIMES to Delete
DOCTOR_OPENTIMES deleteDoctime = db.DOCTOR_OPENTIMES.FirstOrDefault(e => e.id.Equals(str_id));
//Delete DOCTOR_OPENTIMES
db.DOCTOR_OPENTIMES.DeleteOnSubmit(deleteDoctime);
//Save changes to Database.
db.SubmitChanges();
}
public static void deletePHARMACIST_HOLIDAYS(string str_id)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get PHARMACIST_HOLIDAYS to Delete
PHARMACIST_HOLIDAYS deletePHARMACIST_HOLIDAYS = db.PHARMACIST_HOLIDAYS.FirstOrDefault(e => e.id.Equals(str_id));
//Delete PHARMACIST_HOLIDAYS
db.PHARMACIST_HOLIDAYS.DeleteOnSubmit(deletePHARMACIST_HOLIDAYS);
//Save changes to Database.
db.SubmitChanges();
}
public static void deleteadmin(string str_username)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get ADM to Delete
SYSTEM_ADMINS deleteADM = db.SYSTEM_ADMINS.FirstOrDefault(e => e.username.Equals(str_username));
//Delete ADM
db.SYSTEM_ADMINS.DeleteOnSubmit(deleteADM);
//Save changes to Database.
db.SubmitChanges();
}
public static void deletePrecription(string str_id)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get PRESCRIPTIONS to Delete
PRESCRIPTIONS deletePrecription = db.PRESCRIPTIONS.FirstOrDefault(e => e.id.Equals(str_id));
//Delete PRESCRIPTIONS
db.PRESCRIPTIONS.DeleteOnSubmit(deletePrecription);
//Save changes to Database.
db.SubmitChanges();
}
public static void updateadmin(string str_username, SYSTEM_ADMINS newADM)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get Employee for update
SYSTEM_ADMINS oldADM = db.SYSTEM_ADMINS.FirstOrDefault(e => e.username.Equals(str_username));
oldADM = newADM;
//Save changes to Database.
db.SubmitChanges();
////Get Updated DOCTORS
//SYSTEM_ADMINS updatedADM = db.SYSTEM_ADMINS.FirstOrDefault(e => e.username.Equals("john"));
}
public static void insert2admin(SYSTEM_ADMINS newADM)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
/*
* //Create new user
* SYSTEM_ADMINS newADM = new SYSTEM_ADMINS();
* newADM.id = "001";
* newADM.username = "******";
* newADM.native_name = "Jo";
* newADM.password = "******";
*/
//add newADM to database
db.SYSTEM_ADMINS.InsertOnSubmit(newADM);
db.SubmitChanges();
}
public static bool updatePatientById(string str_id, PATIENT newPatient)
{
bool result = true;
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
try
{
//Get Patient for update
PATIENT oldPatient = db.PATIENT.FirstOrDefault(e => e.id.Equals(str_id));
oldPatient = newPatient;
//Save changes to Database.
db.SubmitChanges();
}
catch
{
result = false;
}
return(result);
}
public static bool deletePatient(string str_id)
{
bool result = true;
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
try {
//Get PATIENT to Delete
PATIENT deletePATIENT = db.PATIENT.FirstOrDefault(e => e.id.Equals(str_id));
//Delete PATIENT
db.PATIENT.DeleteOnSubmit(deletePATIENT);
//Save changes to Database.
db.SubmitChanges();
}
catch
{
result = false;
}
return(result);
}
public static bool updateDoc(string str_id, DOCTORS newDOCTORS)
{
bool result = true;
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
try
{
//Get DOCTORS for update
DOCTORS oldDOCTORS = db.DOCTORS.FirstOrDefault(e => e.id.Equals(str_id));
oldDOCTORS = newDOCTORS;
//Save changes to Database.
db.SubmitChanges();
}
catch
{
result = false;
}
return(result);
}
public static bool updatePHARMACIST(string str_id, PHARMACIST updatePHARMACIST)
{
bool result = false;
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
try{
//Get PHARMACIST for update
PHARMACIST oldPHARMACIST = db.PHARMACIST.FirstOrDefault(e => e.id.Equals(str_id));
oldPHARMACIST = updatePHARMACIST;
//Save changes to Database.
db.SubmitChanges();
result = true;
}
catch (Exception ex)
{
result = false;
}
return(result);
}
