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 createService(service objService) { using (var dataContext = new FinalAppWebEntities()) { dataContext.services.Add(objService); dataContext.SaveChanges(); } }
public void CreateClinicDate(clinicDate obj) { using (var dataContext = new FinalAppWebEntities()) { dataContext.clinicDates.Add(obj); dataContext.SaveChanges(); } }
public void CreateClinicHistory(clinicHistory objClinicHistory) { using (var dataContext = new FinalAppWebEntities()) { dataContext.clinicHistories.Add(objClinicHistory); dataContext.SaveChanges(); } }
public void CreateSpeciality(speciality objSpeciality) { using (var dataContext = new FinalAppWebEntities()) { dataContext.specialities.Add(objSpeciality); dataContext.SaveChanges(); } }
public void CreateClinicHistory_Allergy(clinicHistory_Alergie objDoctor_Speciality) { using (var dataContext = new FinalAppWebEntities()) { dataContext.clinicHistory_Alergie.Add(objDoctor_Speciality); dataContext.SaveChanges(); } }
public void CreateUser(user objUser) { using (var dataContext = new FinalAppWebEntities()) { dataContext.users.Add(objUser); 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 void CreateDoctor(doctor objDoctor) { using (var dataContext = new FinalAppWebEntities()) { //LINQ //return dataContext.Customers.ToList(); dataContext.doctors.Add(objDoctor); dataContext.SaveChanges(); } }
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 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 void updateService(service objService) { using (var dataContext = new FinalAppWebEntities()) { var trs = from t in dataContext.services where t.ID == objService.ID select t; service transaction = trs.FirstOrDefault(); //Update field by field objService.status = true; dataContext.SaveChanges(); } }
public void DeletePatient(int id) { using (var dataContext = new FinalAppWebEntities()) { var cust = from c in dataContext.patients where c.id == id select c; patient objPatient = cust.FirstOrDefault(); dataContext.patients.Remove(objPatient); dataContext.SaveChanges(); } }
public void updateClinicDate(clinicDate obj) { using (var dataContext = new FinalAppWebEntities()) { var trs = from t in dataContext.clinicDates where t.id == obj.id select t; clinicDate transaction = trs.FirstOrDefault(); //Update field by field transaction.status = obj.status; dataContext.SaveChanges(); } }
public void DeleteNurse(int id) { using (var dataContext = new FinalAppWebEntities()) { var cust = from c in dataContext.nurses where c.id == id select c; nurse objNurse = cust.FirstOrDefault(); dataContext.nurses.Remove(objNurse); dataContext.SaveChanges(); } }
public void DeleteDoctor(int id) { using (var dataContext = new FinalAppWebEntities()) { var cust = from c in dataContext.doctors where c.id == id select c; doctor objDoctor = cust.FirstOrDefault(); dataContext.doctors.Remove(objDoctor); dataContext.SaveChanges(); } }
public void deleteCLnicDate(clinicDate obj) { using (var dataContext = new FinalAppWebEntities()) { //Load customer object var cust = from c in dataContext.clinicDates where c.id == obj.id select c; clinicDate objCustomer = cust.FirstOrDefault(); //Remove dataContext.clinicDates.Remove(objCustomer); //Save dataContext.SaveChanges(); } }
public void UpadteUser(user objUser) { using (var dataContext = new FinalAppWebEntities()) { var trs = from t in dataContext.users where t.id == objUser.id select t; user transaction = trs.FirstOrDefault(); //Update field by field transaction.username = objUser.username; transaction.password = objUser.password; transaction.email = objUser.email; dataContext.SaveChanges(); } }
public void deleteClinicHistoryAllergy(int id) { using (var dataContext = new FinalAppWebEntities()) { //Load customer object var cust = from c in dataContext.clinicHistory_Alergie where c.id == id select c; clinicHistory_Alergie objCustomer = cust.FirstOrDefault(); //Remove dataContext.clinicHistory_Alergie.Remove(objCustomer); //Save dataContext.SaveChanges(); } }
public void DeleteSpeciality(int specialityId) { using (var dataContext = new FinalAppWebEntities()) { //Load customer object var cust = from c in dataContext.specialities where c.ID == specialityId select c; speciality objCustomer = cust.FirstOrDefault(); //Remove dataContext.specialities.Remove(objCustomer); //Save dataContext.SaveChanges(); } }
public void UpdateClinicHistory(clinicHistory objClinicHistory) { using (var dataContext = new FinalAppWebEntities()) { var trs = from t in dataContext.clinicHistories where t.id == objClinicHistory.id select t; clinicHistory transaction = trs.FirstOrDefault(); //Update field by field transaction.date = objClinicHistory.date; transaction.weight = objClinicHistory.weight; transaction.height = objClinicHistory.height; transaction.description = objClinicHistory.description; dataContext.SaveChanges(); } }