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