Пример #1
0
    public IQueryable<Appointment> getAppointmentByID(int _id)
    {
        appointmentsDataContext objAppointmentDC = new appointmentsDataContext();
        var allAppointments = objAppointmentDC.Appointments.Where(x => x.Id == _id).Select(x => x);
        return allAppointments;

    }
Пример #2
0
 public List<sp_getDoctorByIdResult> getDoctorById(Guid _id)
 {
     appointmentsDataContext objAppointmentDC = new appointmentsDataContext();
     using (objAppointmentDC)
     {
         var doctorById = objAppointmentDC.sp_getDoctorById(_id);
         return doctorById.ToList();
     }
 }
Пример #3
0
 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;
     }
 }
Пример #4
0
    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();
        }
    }
Пример #5
0
    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;
        }
    }
Пример #6
0
    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;
        }
    }
Пример #7
0
 public IQueryable<Appointment> getAppointments()
 {
     appointmentsDataContext objAppointmentDC = new appointmentsDataContext();
     var allAppointments = objAppointmentDC.Appointments.Select(x => x);
     return allAppointments;
 }