//Get Sent Newsletter Info public IQueryable <mic_sendletter> getSendNewsletter() { hospitalDataContext objNews = new hospitalDataContext(); var allNews = objNews.mic_sendletters.Select(x => x); return(allNews); }
public IQueryable <mic_services_lady_minto> getServiceLadyMintoById(int _id) // GET a single Lady Minto service { hospitalDataContext objHospital = new hospitalDataContext(); var serviceLadyMinto = objHospital.mic_services_lady_mintos.Where(x => x.id == _id).Select(x => x); return(serviceLadyMinto); }
public IQueryable <mic_advice> getAdviceByLevel(int _level) { hospitalDataContext objHospital = new hospitalDataContext(); var allAdvice = objHospital.mic_advices.Where(x => x.level == _level).Select(x => x); return(allAdvice); }
public IQueryable <mic_services_anson> getServicesAnson() // GET all Anson services { hospitalDataContext objHospital = new hospitalDataContext(); var allServicesAnson = objHospital.mic_services_ansons.Select(x => x); return(allServicesAnson); }
public IQueryable <mic_services_bingham> getServiceBinghamById(int _id) // GET a single Bingham service { hospitalDataContext objHospital = new hospitalDataContext(); var serviceBingham = objHospital.mic_services_binghams.Where(x => x.id == _id).Select(x => x); return(serviceBingham); }
//Get All Careers public IQueryable <mic_career_application> getCareer() { hospitalDataContext objCareer = new hospitalDataContext(); var allCareer = objCareer.mic_career_applications.Select(x => x); return(allCareer); }
public IQueryable <mic_job_posting> getJobPostingById(int _id) // GET a single job posting by Id { hospitalDataContext objHospital = new hospitalDataContext(); var allJobPostings = objHospital.mic_job_postings.Where(x => x.Id == _id).Select(x => x); return(allJobPostings); }
public IQueryable <mic_book_appointment> getAppointmentsByDateNotBooked(DateTime _date_only) { hospitalDataContext objHospital = new hospitalDataContext(); var appointments = objHospital.mic_book_appointments.Where(x => x.date_only == _date_only && x.booked == false).OrderBy(x => x.date).Select(x => x); return(appointments); }
public IQueryable <mic_specialization> getSpecialization() { hospitalDataContext objSpecialization = new hospitalDataContext(); var allSpecialization = objSpecialization.mic_specializations.Select(x => x); return(allSpecialization); }
//****** QUERY CLAUDIA ******// //******** INSERT *******// public bool commitInsert(string _title, string _content, string _img, string _category, string _short_cont) { // to ensure all data will be disposed when finished hospitalDataContext objHospitalDC = new hospitalDataContext(); using (objHospitalDC) { //create an instance of the table mic_news_event objNewEvent = new mic_news_event(); //set table columns to new values being pass from *.aspx page DateTime dateEvent = DateTime.Now; objNewEvent.date = dateEvent; objNewEvent.title = _title; objNewEvent.content = _content; objNewEvent.img = _img; objNewEvent.category = _category; objNewEvent.short_cont = _short_cont; //insert comand objHospitalDC.mic_news_events.InsertOnSubmit(objNewEvent); //commit insert against database objHospitalDC.SubmitChanges(); return(true); } }
public IQueryable <mic_book_appointment> getAppointmentsByID(int _id) { hospitalDataContext objHospital = new hospitalDataContext(); var appointment = objHospital.mic_book_appointments.Where(x => x.Id == _id).Select(x => x); return(appointment); }
//******** Query showing the rows by category... CLAUDIA ******// public IQueryable <mic_news_event> getEventByCategory(string _category) { hospitalDataContext objHospitalDC = new hospitalDataContext(); var allrow = objHospitalDC.mic_news_events.Where(x => x.category == _category).Select(x => x); return(allrow); }
public IQueryable <mic_pay_bill> getTransactiobByID(int _id) { hospitalDataContext objTransaction = new hospitalDataContext(); var Transaction = objTransaction.mic_pay_bills.Where(x => x.Id == _id).Select(x => x); return(Transaction); }
public IQueryable <mic_pay_bill> getTransactions() { hospitalDataContext objTransaction = new hospitalDataContext(); var allTransactions = objTransaction.mic_pay_bills.Select(x => x); return(allTransactions); }
//Get Specific Career public IQueryable <mic_career_application> getCareerByID(int _id) { hospitalDataContext objCareer = new hospitalDataContext(); var allCareer = objCareer.mic_career_applications.Where(x => x.career_id == _id).Select(x => x); return(allCareer); }
public IQueryable <mic_emergency_time> getDetails(int _id) { hospitalDataContext objemergency = new hospitalDataContext(); var allDetails = objemergency.mic_emergency_times.Where(x => x.Id == _id).Select(x => x); return(allDetails); }
//Update Career public bool commitUpdate(int _id, string _fname, string _lname, string _email, string _address, int _country, int _province, string _city, string _zip, string _phone, int _ques_status, int _ques_crime, int _ques_certificate, int _skill_proficiency, int _skill_experience, string _resume, string _coverletter, string _reason, string _comment, int _consent) { hospitalDataContext objCareer = new hospitalDataContext(); using (objCareer) { var objUpCareer = objCareer.mic_career_applications.Single(x => x.career_id == _id); objUpCareer.fname = _fname; objUpCareer.lname = _lname; objUpCareer.email = _email; objUpCareer.address = _address; objUpCareer.country = _country; objUpCareer.province = _province; objUpCareer.city = _city; objUpCareer.zip = _zip; objUpCareer.phone = _phone; objUpCareer.ques_status = _ques_status; objUpCareer.ques_crime = _ques_crime; objUpCareer.ques_certificate = _ques_certificate; objUpCareer.skill_proficiency = _skill_proficiency; objUpCareer.skill_experience = _skill_experience; objUpCareer.resume = _resume; objUpCareer.coverletter = _coverletter; objUpCareer.reason = _reason; objUpCareer.comment = _comment; objUpCareer.consent = _consent; objCareer.SubmitChanges(); return(true); } }
public IQueryable <mic_volunteer> getApplications() { hospitalDataContext objVolunteer = new hospitalDataContext(); var allApplications = objVolunteer.mic_volunteers.Select(x => x); return(allApplications); }
//******** INSERT *******// public bool commitInsert(string _img, string _name, string _link) { // to ensure all data will be disposed when finished hospitalDataContext objHospitalDC = new hospitalDataContext(); using (objHospitalDC) { //create an instance of the table mic_slider objNewImages = new mic_slider(); //set table columns to new values being pass from *.aspx page objNewImages.img = _img; objNewImages.name = _name; objNewImages.name = _link; //insert comand objHospitalDC.mic_sliders.InsertOnSubmit(objNewImages); //commit insert against database objHospitalDC.SubmitChanges(); return(true); } }
public IQueryable <mic_volunteer> getApplicationByID(int _id) { hospitalDataContext objVolunteer = new hospitalDataContext(); var application = objVolunteer.mic_volunteers.Where(x => x.Id == _id).Select(x => x); return(application); }
public IQueryable <mic_job_posting> getJobPostings() // GET all job postings { hospitalDataContext objHospital = new hospitalDataContext(); var allJobPostings = objHospital.mic_job_postings.Select(x => x); return(allJobPostings); }
public bool commitInsert(string _fname, string _lname, string _title, string _dob, string _city, string _province, string _postalCode, string _home_phone, string _work_phone, string _personal_phone, string _email, string _emergency_contactName, string _emergency_contact, string _education_level, string _skills, string _experience, string _location, string _reason, string _resume) { hospitalDataContext objVolunteer = new hospitalDataContext(); mic_volunteer objNewVolunteer = new mic_volunteer(); objNewVolunteer.fname = _fname; objNewVolunteer.lname = _lname; objNewVolunteer.title = _title; objNewVolunteer.dob = _dob; objNewVolunteer.city = _city; objNewVolunteer.province = _province; objNewVolunteer.postalCode = _postalCode; objNewVolunteer.home_phone = _home_phone; objNewVolunteer.work_phone = _work_phone; objNewVolunteer.personal_phone = _personal_phone; objNewVolunteer.email = _email; objNewVolunteer.emergency_contactName = _emergency_contactName; objNewVolunteer.emergency_contact = _emergency_contact; objNewVolunteer.education_level = _education_level; objNewVolunteer.skills = _skills; objNewVolunteer.experience = _experience; objNewVolunteer.location = _location; objNewVolunteer.reason = _reason; objNewVolunteer.resume = _resume; objVolunteer.mic_volunteers.InsertOnSubmit(objNewVolunteer); objVolunteer.SubmitChanges(); return(true); }
public IQueryable <mic_services_lady_minto> getServicesLadyMinto() // GET all Lady Minto services { hospitalDataContext objHospital = new hospitalDataContext(); var allServicesLadyMinto = objHospital.mic_services_lady_mintos.Select(x => x); return(allServicesLadyMinto); }
public IQueryable <mic_location> getLocation() { hospitalDataContext objLocation = new hospitalDataContext(); var allLocations = objLocation.mic_locations.Select(x => x); return(allLocations); }
public IQueryable <mic_services_anson> getServiceAnsonById(int _id) // GET a single Anson service { hospitalDataContext objHospital = new hospitalDataContext(); var serviceAnson = objHospital.mic_services_ansons.Where(x => x.id == _id).Select(x => x); return(serviceAnson); }
//Get Specific Newsletter Info public IQueryable <mic_mailing_list> getNewsletterByID(int _id) { hospitalDataContext objNews = new hospitalDataContext(); var allNews = objNews.mic_mailing_lists.Where(x => x.mailing_id == _id).Select(x => x); return(allNews); }
public IQueryable <mic_services_bingham> getServicesBingham() // GET all Bingham services { hospitalDataContext objHospital = new hospitalDataContext(); var allServicesBingham = objHospital.mic_services_binghams.Select(x => x); return(allServicesBingham); }
//Get All Newsletter Info public IQueryable <mic_mailing_list> getNewsletter() { hospitalDataContext objNews = new hospitalDataContext(); var allNews = objNews.mic_mailing_lists.Select(x => x); return(allNews); }
public IQueryable <mic_advice> getAdvice() // GET all advice { hospitalDataContext objHospital = new hospitalDataContext(); var allAdvice = objHospital.mic_advices.Select(x => x); return(allAdvice); }
//Get Specific Sent Newsletter Info public IQueryable <mic_sendletter> getSentNewsletterByID(int _id) { hospitalDataContext objNews = new hospitalDataContext(); var allNews = objNews.mic_sendletters.Where(x => x.sendletter_id == _id).Select(x => x); return(allNews); }