public void UpdatePerson(person objPerson)
{
using (var dataContext = new FinalAppWebEntities())
{
//Get object from database
var trs = from t in dataContext.people
where t.ID == objPerson.ID
select t;
person transaction = new person();
transaction = trs.FirstOrDefault();
try
{
//Update field by field
transaction.name = objPerson.name;
transaction.lastName = objPerson.lastName;
transaction.gender = objPerson.gender;
transaction.age = objPerson.age;
transaction.phone = objPerson.phone;
transaction.email = objPerson.email;
transaction.dateOfBith = objPerson.dateOfBith;
transaction.address = objPerson.address;
transaction.nationality = objPerson.nationality;
dataContext.SaveChanges();
}
catch (Exception) {
Console.WriteLine("enviado == " + objPerson.name + " id " + objPerson.ID);
}
}
}
public void CreateClinicDate(clinicDate obj)
{
using (var dataContext = new FinalAppWebEntities())
{
dataContext.clinicDates.Add(obj);
dataContext.SaveChanges();
}
}
public void createService(service objService)
{
using (var dataContext = new FinalAppWebEntities())
{
dataContext.services.Add(objService);
dataContext.SaveChanges();
}
}
public void CreateUser(user objUser)
{
using (var dataContext = new FinalAppWebEntities())
{
dataContext.users.Add(objUser);
dataContext.SaveChanges();
}
}
public void CreateSpeciality(speciality objSpeciality)
{
using (var dataContext = new FinalAppWebEntities())
{
dataContext.specialities.Add(objSpeciality);
dataContext.SaveChanges();
}
}
public void CreateClinicHistory(clinicHistory objClinicHistory)
{
using (var dataContext = new FinalAppWebEntities())
{
dataContext.clinicHistories.Add(objClinicHistory);
dataContext.SaveChanges();
}
}
public void CreateClinicHistory_Allergy(clinicHistory_Alergie objDoctor_Speciality)
{
using (var dataContext = new FinalAppWebEntities())
{
dataContext.clinicHistory_Alergie.Add(objDoctor_Speciality);
dataContext.SaveChanges();
}
}
public List <alergy> getAlergies()
{
using (var dataContext = new FinalAppWebEntities())
{
var tnts = from t in dataContext.alergies
select t;
return(tnts.ToList());
}
}
public List <service> getServices()
{
using (var dataContext = new FinalAppWebEntities())
{
var tnts = from t in dataContext.services
select t;
return(tnts.ToList());
}
}
public List <clinicDate> GetClinicDates()
{
using (var dataContext = new FinalAppWebEntities())
{
var tnts = from t in dataContext.clinicDates
select t;
return(tnts.ToList());
}
}
public void CreateDoctor(doctor objDoctor)
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
dataContext.doctors.Add(objDoctor);
dataContext.SaveChanges();
}
}
public void CreateNurse(nurse objNurse)
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
dataContext.nurses.Add(objNurse);
dataContext.SaveChanges();
}
}
public void CreatePerson(person objPerson)
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
dataContext.people.Add(objPerson);
dataContext.SaveChanges();
}
}
public List <clinicDate> GetClinicDatesByClinicHistory(int id)
{
using (var dataContext = new FinalAppWebEntities())
{
var tnts = from t in dataContext.clinicDates
where t.clinicHistorytId == id
select t;
return(tnts.ToList());
}
}
public void CreateDoctorSpeciality(doctor_speciality objDoctor_Speciality)
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
dataContext.doctor_speciality.Add(objDoctor_Speciality);
dataContext.SaveChanges();
}
}
public void CreateAdmin(admin objAdmin)
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
dataContext.admins.Add(objAdmin);
dataContext.SaveChanges();
}
}
public void CreatePatient(patient objPatient)
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
dataContext.patients.Add(objPatient);
dataContext.SaveChanges();
}
}
public List <clinicDate> GetClinicDatesNotAprove()
{
using (var dataContext = new FinalAppWebEntities())
{
var tnts = from t in dataContext.clinicDates
where t.status == false
select t;
return(tnts.ToList());
}
}
public List <clinicDate> GetClinicDatesByDoctorAndStatus(int id, bool status)
{
using (var dataContext = new FinalAppWebEntities())
{
var tnts = from t in dataContext.clinicDates
where t.status == status && t.doctorId == id
select t;
return(tnts.ToList());
}
}
clinicHistory_Alergie IClinicHistory_AlergieRepository.GetClinicHistory_Allergy(int id)
{
using (var dataContext = new FinalAppWebEntities())
{
var custs = from c in dataContext.clinicHistory_Alergie
where c.id == id
select c;
clinicHistory_Alergie objDoctor_Speciality = custs.FirstOrDefault();
return(objDoctor_Speciality);
}
}
List <clinicHistory_Alergie> IClinicHistory_AlergieRepository.GetClinicHistory_Allergies(int doctorid)
{
using (var dataContext = new FinalAppWebEntities())
{
var custs = from c in dataContext.clinicHistory_Alergie.Include("alergy")
where c.clinicHistoryId == doctorid
select c;
List <clinicHistory_Alergie> objDoctor_Speciality = custs.ToList();
return(objDoctor_Speciality);
}
}
public clinicHistory GetClinicHistoryByPatientId(int patientid)
{
using (var dataContext = new FinalAppWebEntities())
{
var custs = from c in dataContext.clinicHistories
where c.patientId == patientid
select c;
clinicHistory objCH = custs.FirstOrDefault();
return(objCH);
}
}
public void deleteService(service objService)
{
using (var dataContext = new FinalAppWebEntities())
{
var cust = from c in dataContext.services
where c.ID == objService.ID
select c;
service objCustomer = cust.FirstOrDefault();
dataContext.services.Remove(objCustomer);
dataContext.SaveChanges();
}
}
public List <speciality> GetSpecialities()
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
var custs = from c in dataContext.specialities
select c;
List <speciality> objPerson = custs.ToList();
return(objPerson);
}
}
public List <doctor> GetDoctors()
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
var custs = from c in dataContext.doctors.Include("person")
select c;
List <doctor> objDoctor = custs.ToList();
return(objDoctor);
}
}
public List <patient> GetPatients()
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
var custs = from c in dataContext.patients
select c;
List <patient> objPerson = custs.ToList();
return(objPerson);
}
}
public List <user> GetUsers()
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
var custs = from c in dataContext.users
select c;
List <user> objsUser = custs.ToList();
return(objsUser);
}
}
public speciality GetSpecialityByDescription(string description)
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
var custs = from c in dataContext.specialities
where c.description == description
select c;
speciality objSpeciality = custs.FirstOrDefault();
return(objSpeciality);
}
}
public admin GetAdminByUserId(int userid)
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
var custs = from c in dataContext.admins
where c.userId == userid
select c;
admin objAdmin = custs.FirstOrDefault();
return(objAdmin);
}
}
public patient GetPatientByPersonId(int personid)
{
using (var dataContext = new FinalAppWebEntities())
{
//LINQ
//return dataContext.Customers.ToList();
var custs = from c in dataContext.patients
where c.personId == personid
select c;
patient objPerson = custs.FirstOrDefault();
return(objPerson);
}
}
