//update new Pharmacy
public Boolean UpdatePharmacy(Pharmacy pharmacy) {
var result = false;
var l = new LoginRequest();
PHARMACIST updatePHARMACIST = new PHARMACIST();
string strID = pharmacy.id;
LinqToSQL.updatePHARMACIST(strID, updatePHARMACIST);
listp.ForEach(c =>
{
if (c.userName == pharmacy.userName)
{
listp.Insert(listp.IndexOf(c), pharmacy);
result = true;
}
});
login.ForEach(c =>
{
if (c.userName == pharmacy.userName)
{
l.userName = c.userName;
l.password = c.password;
login.Insert(login.IndexOf(c), l);
}
});
return result;
}
///<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);
}
public static void insert2PHARMACIST(PHARMACIST newPHARMACIST)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Add new PHARMACIST to database
db.PHARMACIST.InsertOnSubmit(newPHARMACIST);
//Save changes to Database.
db.SubmitChanges();
}
//creat new Pharmacy
public Boolean CreatPharmacy(Pharmacy pharmacy) {
PHARMACIST newPHARMACIST = new PHARMACIST();
newPHARMACIST.support_delivery = pharmacy.supportDelivery;
var result = true;
if (login.Exists(t => t.userName == pharmacy.userName))
{
result = false;
}
else {
LinqToSQL.insert2PHARMACIST(newPHARMACIST);
listp.Add(pharmacy);
login.Add(new LoginRequest { userName = pharmacy.userName, password = pharmacy.password });
}
return result;
}
// get a pharmacy by id
public Pharmacy GetPharmacy(string id) {
Pharmacy p = new Pharmacy();
PHARMACIST selectPHA = LinqToSQL.selectPHARMACISTByID(id);
p.id = selectPHA.id;
p.nativeName= selectPHA.native_name
//listp.ForEach(c => {
// if (c.id == id) {
// p = c;
// }
//});
return p;
}
public static bool deletePHARMACIST(string str_id)
{
bool result = false;
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get PHARMACIST to Delete
PHARMACIST deletePHARMACIST = db.PHARMACIST.FirstOrDefault(e => e.id.Equals(str_id));
try
{
//Delete PHARMACIST
db.PHARMACIST.DeleteOnSubmit(deletePHARMACIST);
//Save changes to Database.
db.SubmitChanges();
result = true;
}
catch (Exception ex)
{
result = false;
}
return(result);
}
