//update a patient
public Boolean UpdatePatient(Patient patient)
{
var result = false;
var l = new LoginRequest();
PATIENT updatePATIENT = new PATIENT();
updatePATIENT.user_name = patient.userName;
updatePATIENT.age = patient.age;
if (LinqToSQL.updatePatientById(patient.id, updatePATIENT))
result = true;
//listpa.ForEach(c =>
//{
// if (c.userName == patient.userName)
// {
// listpa.Insert(listpa.IndexOf(c), patient);
// result = true;
// }
//});
login.ForEach(c =>
{
if (c.userName == patient.userName)
{
l.userName = c.userName;
l.password = c.password;
login.Insert(login.IndexOf(c), l);
}
});
return result;
}
//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;
}
//update a doctor
public Boolean UpdateDoctor(Doctor doctor)
{
var result = false;
var l = new LoginRequest();
DOCTORS updateDOC = new DOCTORS();
updateDOC.id = doctor.id;
updateDOC.native_name = doctor.nativeName;
if (LinqToSQL.updateDoc(doctor.id, updateDOC))
result = true;
//listd.ForEach(c =>
//{
// if (c.userName == doctor.userName)
// {
// listd.Insert(listd.IndexOf(c),doctor);
// result = true;
// }
//});
login.ForEach(c =>
{
if (c.userName == doctor.userName)
{
l.userName = c.userName;
l.password = c.password;
login.Insert(login.IndexOf(c), l);
}
});
return result;
}
//create a appoinment
public Boolean createAppointments(Appoinment appoinment)
{
//lista.Add(appoinment);
APPLICATIONS newAPPLICATIONS = new APPLICATIONS();
//newAPPLICATIONS.doctor_id= appoinment.
LinqToSQL.insert2applications(newAPPLICATIONS);
return true;
}
//delete pharmacy by id
public Boolean deletePharmacy(string id) {
var result = false;
if(LinqToSQL.deletePHARMACIST(id))
result = true;
//listp.ForEach(c => {
// if (c.id == id) {
// listp.Remove(c);
// result = true;
// }
//});
return result;
}
//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;
}
//delete a patient by id
public Boolean deletePatient(string id)
{
var result = false;
if (LinqToSQL.deletePatient(id))
result = true;
//listpa.ForEach(c => {
// if (c.id == id)
// {
// listpa.Remove(c);
// result = true;
// }
//});
return result;
}
//get a patient by id
public Patient getPatient(string id)
{
Patient p = new Patient();
PATIENT selectPatient = LinqToSQL.selectPatientById(id);
p.userName = selectPatient.user_name;
p.weight = selectPatient.weight;
//listpa.ForEach(c => {
// if (c.id == id)
// {
// p = c;
// }
//});
return p;
}
//get a doctor by id
public Doctor getDoctor(string id) {
Doctor p = new Doctor();
DOCTORS selectDoc = LinqToSQL.selectDocByID(id);
p.nativeName = selectDoc.native_name;
p.userName = selectDoc.user_name;
//listd.ForEach(c => {
// if (c.id == id)
// {
// p = c;
// return;
// }
//});
return p;
}
//delete a doctor by id
public Boolean deleteDoctor(string id)
{
var result = false;
//listd.ForEach(c => {
// if (c.id == id)
// {
// result = true;
// listd.Remove(c);
// return;
// }
//});
if (LinqToSQL.deleteDoc(id))
result = true;
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;
}
//create a doctor
public Boolean CreatDoctor(Doctor doctor)
{
var result = true;
if (login.Exists(t => t.userName == doctor.userName))
{
result = false;
}
else
{
//listd.Add(doctor);
DOCTORS newDOC = new DOCTORS();
newDOC.id = doctor.id;
newDOC.native_name = doctor.nativeName;
LinqToSQL.insert2doctors(newDOC);
login.Add(new LoginRequest { userName = doctor.userName, password = doctor.password });
}
return result;
}
private void btnTestOne_Click(object sender, EventArgs e)
{
LinqToSQL linq = new LinqToSQL();
var linqTime = linq.RunTestOne();
lblLinq.Text = linqTime.TotalMilliseconds.ToString("###.00ms");
ADO ado = new ADO();
var adoTime = ado.RunTestOne();
lblADO.Text = adoTime.TotalMilliseconds.ToString("###.00ms");
DapperTest dapper = new DapperTest();
var dapperTime = dapper.RunTestOne();
lblDapper.Text = dapperTime.TotalMilliseconds.ToString("###.00ms");
if (linqTime > dapperTime && linqTime > adoTime)
{
progressADO.Maximum = (int)linqTime.TotalMilliseconds;
progressLinq.Maximum = (int)linqTime.TotalMilliseconds;
progressDapper.Maximum = (int)linqTime.TotalMilliseconds;
}
else if (dapperTime > linqTime && dapperTime > adoTime)
{
progressADO.Maximum = (int)dapperTime.TotalMilliseconds;
progressLinq.Maximum = (int)dapperTime.TotalMilliseconds;
progressDapper.Maximum = (int)dapperTime.TotalMilliseconds;
}
else if (adoTime > linqTime && adoTime > dapperTime)
{
progressADO.Maximum = (int)adoTime.TotalMilliseconds;
progressLinq.Maximum = (int)adoTime.TotalMilliseconds;
progressDapper.Maximum = (int)adoTime.TotalMilliseconds;
}
progressADO.Value = (int)adoTime.TotalMilliseconds;
progressLinq.Value = (int)linqTime.TotalMilliseconds;
progressDapper.Value = (int)dapperTime.TotalMilliseconds;
}
//create a patient
public Boolean CreatPatient(Patient patient)
{
var result = true;
if (login.Exists(t => t.userName == patient.userName))
{
result = false;
}
else
{
//listpa.Add(patient);
PATIENT newPatient = new PATIENT();
newPatient.id = patient.id;
newPatient.user_name = patient.userName;
newPatient.native_name = patient.nativeName;
newPatient.password = patient.password";
newPatient.gender = patient.gender;
LinqToSQL.insert2patient(newPatient)
login.Add(new LoginRequest { userName = patient.userName, password = patient.password });
}
return result;
}
