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); } }