public IQueryable<Appointment> getAppointmentByID(int _id) { appointmentsDataContext objAppointmentDC = new appointmentsDataContext(); var allAppointments = objAppointmentDC.Appointments.Where(x => x.Id == _id).Select(x => x); return allAppointments; }
public List<sp_getDoctorByIdResult> getDoctorById(Guid _id) { appointmentsDataContext objAppointmentDC = new appointmentsDataContext(); using (objAppointmentDC) { var doctorById = objAppointmentDC.sp_getDoctorById(_id); return doctorById.ToList(); } }
public bool commitDelete(int _id) { appointmentsDataContext objAppointmentDC = new appointmentsDataContext(); using (objAppointmentDC) { var objDelAppointment = objAppointmentDC.Appointments.Single(x => x.Id == _id); objAppointmentDC.Appointments.DeleteOnSubmit(objDelAppointment); objAppointmentDC.SubmitChanges(); return true; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { appointmentsDataContext dataContext = new appointmentsDataContext(); Guid _id = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()); rpt_all.DataSource = objAppointment.getPatientById(_id); rpt_all.DataBind(); } }
public bool commitUpdate(int _id, DateTime _date, string _title) { appointmentsDataContext objAppointmentDC = new appointmentsDataContext(); using (objAppointmentDC) { var objUpAppointment = objAppointmentDC.Appointments.Single(x => x.Id == _id); //objUpAppointment.patientName = _pname; objUpAppointment.date_time = _date; objUpAppointment.appointment_title = _title; objAppointmentDC.SubmitChanges(); return true; } }
public bool commitInsert(DateTime _date, string _title) { appointmentsDataContext objAppointmentDC = new appointmentsDataContext(); using (objAppointmentDC) { Appointment objNewAppointment = new Appointment(); //objNewAppointment.patientName = _pname; objNewAppointment.date_time = _date; objNewAppointment.appointment_title = _title; objAppointmentDC.Appointments.InsertOnSubmit(objNewAppointment); objAppointmentDC.SubmitChanges(); return true; } }
public IQueryable<Appointment> getAppointments() { appointmentsDataContext objAppointmentDC = new appointmentsDataContext(); var allAppointments = objAppointmentDC.Appointments.Select(x => x); return allAppointments; }