public Adddoctormodel Getupdatedoc(int SID)
{
using (hms2Entities mm = new hms2Entities())
{
var request = mm.doctors.Where(x => x.ID == SID).FirstOrDefault();
Adddoctormodel dcctr = null;
if (request != null)
{
dcctr = new Adddoctormodel()
{
SID = request.ID,
firstName = request.FirstName,
lastName = request.LastName,
qualification = request.qualification,
cellnum = request.Cellnum,
cnic = request.CNIC,
gender = request.Gender,
nationality = request.Nationality
};
return(dcctr);
}
else
{
return(dcctr);
}
}
}
public List <AddpatientModel> readstudents()
{
using (hms2Entities he = new hms2Entities())
{
var request = he.patients.ToList();
List <AddpatientModel> List = request.Select(x => new AddpatientModel {
pID = x.ID, firstName = x.FirstName, lastName = x.LastName, Disease = x.Disease, cellnum = x.Cellnum, cnic = x.CNIC, gender = x.Gender, nationality = x.Nationality
}).ToList();
return(List);
}
}
public List <Adddoctormodel> readstudents()
{
using (hms2Entities mm = new hms2Entities())
{
var request = mm.doctors.ToList();
List <Adddoctormodel> List = request.Select(x => new Adddoctormodel {
SID = x.ID, firstName = x.FirstName, lastName = x.LastName, qualification = x.qualification, cellnum = x.Cellnum, cnic = x.CNIC, gender = x.Gender, nationality = x.Nationality
}).ToList();
return(List);
}
}
public bool Deletedctr(int id)
{
using (hms2Entities mm = new hms2Entities())
{
var data = mm.doctors.Where(x => x.ID == id).FirstOrDefault();
if (data != null)
{
mm.Entry(data).State = EntityState.Deleted;
mm.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool DeleteStd(int id)
{
using (hms2Entities db = new hms2Entities())
{
var data = db.patients.Where(x => x.ID == id).FirstOrDefault();
if (data != null)
{
db.Entry(data).State = EntityState.Deleted;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public int adddoctor(Adddoctormodel dd)
{
int ddID;
using (hms2Entities mm = new hms2Entities())
{
doctor tbldoctor = new doctor();
tbldoctor.FirstName = dd.firstName;
tbldoctor.LastName = dd.lastName;
tbldoctor.qualification = dd.qualification;
tbldoctor.Cellnum = dd.cellnum;
tbldoctor.CNIC = dd.cnic;
tbldoctor.Gender = dd.gender;
tbldoctor.Nationality = dd.nationality;
mm.doctors.Add(tbldoctor);
mm.SaveChanges();
ddID = tbldoctor.ID;
}
return(ddID);
}
public int addpatient(AddpatientModel ad)
{
int adID;
using (hms2Entities hm = new hms2Entities())
{
patient tblpatient = new patient();
tblpatient.FirstName = ad.firstName;
tblpatient.LastName = ad.lastName;
tblpatient.Disease = ad.Disease;
tblpatient.Cellnum = ad.cellnum;
tblpatient.CNIC = ad.cnic;
tblpatient.Gender = ad.gender;
tblpatient.Nationality = ad.nationality;
hm.patients.Add(tblpatient);
hm.SaveChanges();
adID = tblpatient.ID;
}
return(adID);
}
public bool updatedoc(Adddoctormodel std)
{
using (hms2Entities mm = new hms2Entities())
{
var data = mm.doctors.Where(x => x.ID == std.SID).FirstOrDefault();
if (data != null)
{
data.FirstName = std.firstName;
data.LastName = std.lastName;
data.qualification = std.qualification;
data.Cellnum = std.cellnum;
data.CNIC = std.cnic;
data.Gender = std.gender;
data.Nationality = std.nationality;
mm.Entry(data).State = EntityState.Modified;
mm.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool updatepat(AddpatientModel std)
{
using (hms2Entities db = new hms2Entities())
{
var data = db.patients.Where(x => x.ID == std.pID).FirstOrDefault();
if (data != null)
{
data.FirstName = std.firstName;
data.LastName = std.lastName;
data.Disease = std.Disease;
data.CNIC = std.cnic;
data.Cellnum = std.cellnum;
data.Gender = std.gender;
data.Nationality = std.nationality;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}