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