public bool AddDoctorNewSpecialization(int did, int sp)
{
doctor_to_specialization dts = db.doctor_to_specialization.Where(e => (e.docID == did) && (e.specID == sp)).FirstOrDefault();
if (dts != null)
{
return(false);
}
else
{
dts = new doctor_to_specialization();
dts.docID = did;
dts.specID = sp;
try
{
db.doctor_to_specialization.Add(dts);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool AddDoctorSpecialization(int did, int sp1, int sp2, bool notNull)
{
if (notNull)
{
doctor_to_specialization dts1 = db.doctor_to_specialization.Where(e => (e.docID == did) && (e.specID == sp1)).FirstOrDefault();
doctor_to_specialization dts2 = db.doctor_to_specialization.Where(e => (e.docID == did) && (e.specID == sp2)).FirstOrDefault();
if ((dts1 != null) || (dts2 != null))
{
return(false);
}
else
{
dts1 = new doctor_to_specialization();
dts2 = new doctor_to_specialization();
dts1.docID = did;
dts1.specID = sp1;
dts2.docID = did;
dts2.specID = sp2;
try
{
db.doctor_to_specialization.Add(dts1);
db.doctor_to_specialization.Add(dts2);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
else
{
doctor_to_specialization dts1 = db.doctor_to_specialization.Where(e => (e.docID == did) && (e.specID == sp1)).FirstOrDefault();
if (dts1 != null)
{
return(false);
}
else
{
dts1 = new doctor_to_specialization();
dts1.docID = did;
dts1.specID = sp1;
try
{
db.doctor_to_specialization.Add(dts1);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
}
