public int changeMedicData(string username, string password, string cnp, string email, string lastname, string firstname, string address, string dateofbirth, string specializare)
{
datamedic medic = new datamedic();
MedicDetail detail = new MedicDetail();
using (MedicDBEntities3 db = new MedicDBEntities3())
{
try
{
medic = db.datamedics.Where(x => x.cnp == cnp).FirstOrDefault();
medic.password = password;
//changing cnp is prohibited, because this is key information (for identifying)
medic.email = email;
medic.username = username;
db.Entry(medic).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
detail = db.MedicDetails.Where(x => x.cnp == medic.cnp).FirstOrDefault();
detail.lastname = lastname;
detail.firstname = firstname;
detail.address = address;
detail.dateofbirth = dateofbirth;
detail.specializare = specializare;
db.Entry(detail).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
catch
{
return(-1);
}
return(1);
} //using
} //changeMedicData()
public int deletePacient(string pUser, string pCNP)
{
Pacienti pacient = new Pacienti();
PacientDetail detail = new PacientDetail();
using (MedicDBEntities3 md = new MedicDBEntities3())
{
try
{
pacient = md.Pacientis.Where(x => x.username == pUser).FirstOrDefault();
if (pacient.pacient_cnp != pCNP)
{
return(-1);
}
detail = md.PacientDetails.Where(x => x.pacient_cnp == pacient.pacient_cnp).FirstOrDefault();
var entry = md.Entry(detail);
if (entry.State == System.Data.Entity.EntityState.Detached)
{
md.PacientDetails.Attach(detail);
}
md.PacientDetails.Remove(detail);
md.SaveChanges();
var entry1 = md.Entry(pacient);
if (entry1.State == System.Data.Entity.EntityState.Detached)
{
md.Pacientis.Attach(pacient);
}
md.Pacientis.Remove(pacient);
md.SaveChanges();
}
catch
{
return(-2);
}
return(1);
}
}
public int deleteMedicAccount(string username, string cnp)
{
datamedic medic = new datamedic();
MedicDetail detail = new MedicDetail();
try
{
using (MedicDBEntities3 db = new MedicDBEntities3())
{
medic = db.datamedics.Where(x => x.username == username).FirstOrDefault();
if (medic.cnp != cnp)
{
return(-1);
}
detail = db.MedicDetails.Where(x => x.cnp == medic.cnp).FirstOrDefault();
var entry = db.Entry(detail);
if (entry.State == System.Data.Entity.EntityState.Detached)
{
db.MedicDetails.Attach(detail);
}
db.MedicDetails.Remove(detail);
db.SaveChanges();
var entry1 = db.Entry(medic);
if (entry1.State == System.Data.Entity.EntityState.Detached)
{
db.datamedics.Attach(medic);
}
db.datamedics.Remove(medic);
db.SaveChanges();
} //using
} //try
catch
{
return(-2);
} //catch
return(1);
} //function
public int updatePacientData(string pUser, string pPass, string pCNP, string pEmail, string pLName, string pFName, string pBirth, string pAddress)
{
Pacienti pacient = new Pacienti();
PacientDetail detail = new PacientDetail();
using (MedicDBEntities3 md = new MedicDBEntities3())
{
try
{
pacient = md.Pacientis.Where(x => x.pacient_cnp == pCNP).FirstOrDefault();
pacient.username = pUser;
pacient.password = pPass;
pacient.email = pEmail;
//nu vom schimba cnp-ul pentru ca este o informatia esentiala pt cautare
md.Entry(pacient).State = System.Data.Entity.EntityState.Modified;
md.SaveChanges();
detail = md.PacientDetails.Where(x => x.pacient_cnp == pacient.pacient_cnp).FirstOrDefault();
detail.lastname = pLName;
detail.firstname = pFName;
detail.address = pAddress;
detail.dateofbirth = pBirth;
md.Entry(detail).State = System.Data.Entity.EntityState.Modified;
md.SaveChanges();
}
catch
{
return(-1);
}
return(1);
}
}