Ejemplo n.º 1
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        AppointmentDBEntities1 dbcon = new AppointmentDBEntities1();


        int hour = Convert.ToInt32(HourBox.Text);
        int min  = Convert.ToInt32(MinuteBox.Text);

        AppointmentTable myAppointment = new AppointmentTable();
        DoctorTable      doctorTable   = new DoctorTable();

        // add data to the myAppointment

        myAppointment.Reason  = ReasonBox.Text;
        myAppointment.AppDate = Convert.ToDateTime(DateBox.Text);
        myAppointment.AppTime = new TimeSpan(hour, min, 0);


        // add myAppointment to the table

        dbcon.AppointmentTables.Add(myAppointment);

        dbcon.SaveChanges();

        // clear
        UsernameBox.Text = "";
        DoctorBox.Text   = "";
        DateBox.Text     = "";
        HourBox.Text     = "";
        MinuteBox.Text   = "";
        ReasonBox.Text   = "";
    }
        public void NewBDcon()
        {
            dbcon.StudentTables.Load();

            if (dbcon != null)
            {
                dbcon.Dispose();
                dbcon = new AppointmentDBEntities1();
            }
        }
        protected string check_role()
        {
            string userName = User.Identity.Name;
            AppointmentDBEntities1 dbconTemp = new AppointmentDBEntities1();
            UserTable credentials            = dbconTemp.UserTables.Find(userName);

            /*if(credentials.UserRole != "student")
             *  Response.Redirect(ResolveUrl("default.aspx"));*/
            return(credentials.UserRole);
        }
Ejemplo n.º 4
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        AppointmentDBEntities1 dbcon = new AppointmentDBEntities1();

        dbcon.AppointmentTables.Load();

        // select item to delete
        AppointmentTable abc = (from x in dbcon.AppointmentTables.Local
                                where x.AppointmentId ==
                                Convert.ToInt32(RemoveBox.Text)
                                select x).First();

        // delete obj
        dbcon.AppointmentTables.Remove(abc);
        dbcon.SaveChanges();
    }
Ejemplo n.º 5
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        AppointmentDBEntities1 dbcon = new AppointmentDBEntities1();

        EmailTable email = new EmailTable();

        email.EmailText = messageTextBox.Text;
        email.TO        = toTextBox.Text;
        email.FROM      = "username";

        dbcon.EmailTables.Add(email);
        dbcon.SaveChanges();

        messageTextBox.Text = "";
        toTextBox.Text      = "";

        sentLabel.Text    = "Message Sent Successfully";
        sentLabel.Visible = true;
    }