示例#1
0
        private void button5_Click(object sender, EventArgs e)
        {
            int          resvID = 0;
            DialogResult dd     = MessageBox.Show("결제 하시겠습니까?", "트와이스 나연 호텔", MessageBoxButtons.YesNo);

            if (dd == DialogResult.Yes)
            {
                frmPayment   frm_pay = new frmPayment();
                DialogResult rr      = frm_pay.ShowDialog(this);
                if (rr == DialogResult.OK)
                {
                    String Query;
                    sql_con             = new SQLiteConnection("Data Source=" + dbPath);
                    sql_cmd.CommandText = "select * from reservation";
                    sql_cmd.Connection  = sql_con;
                    sql_cmd.Connection.Open();
                    DB = sql_cmd.ExecuteReader();
                    while (DB.Read())
                    {
                        resvID = Convert.ToInt16(DB["id"]);
                    }
                    resvID++;
                    DB.Close();
                    Query = "Insert into reservation (id, roomID, sdate, edate, userID) VALUES (" + resvID.ToString() + ",1,'" + dateTimePicker1.Value.Date.ToString() + "','" + dateTimePicker2.Value.Date.ToString() + "','" + Passvalue + "');";
                    sql_cmd.CommandText = Query;
                    sql_cmd.ExecuteNonQuery();
                    sql_cmd.Connection.Close();
                    button5.Enabled = false;
                    button5.Text    = "예약불가";
                    pictureBox6.Select();
                }
            }
        }
示例#2
0
        private void button4_Click(object sender, EventArgs e)
        {
            int          resvID = 0;
            DialogResult dd     = MessageBox.Show("결제 하시겠습니까?", "트와이스 나연 호텔", MessageBoxButtons.YesNo);

            if (dd == DialogResult.Yes)
            {
                frmPayment   frm_pay = new frmPayment();
                DialogResult rr      = frm_pay.ShowDialog(this);
                if (rr == DialogResult.OK)
                {
                    String Query;
                    sql_con             = new SQLiteConnection("Data Source=" + dbPath);
                    sql_cmd.CommandText = "select * from reservation";
                    sql_cmd.Connection  = sql_con;
                    sql_cmd.Connection.Open();
                    DB = sql_cmd.ExecuteReader();
                    while (DB.Read())
                    {
                        resvID = Convert.ToInt16(DB["id"]);
                    }
                    resvID++;
                    DB.Close();
                    Query = "Insert into reservation (id, roomID, sdate, edate, userID) VALUES (" + resvID.ToString() + ",0,'" + dateTimePicker1.Value.Date.ToString() + "','" + dateTimePicker2.Value.Date.ToString() + "','" + Passvalue + "');";
                    sql_cmd.CommandText = Query;
                    sql_cmd.ExecuteNonQuery();
                    sql_cmd.Connection.Close();
                    button4.Enabled = false;
                    button4.Text    = "예약불가";

                    //MailMessage mail = new MailMessage("*****@*****.**", "*****@*****.**");
                    //SmtpClient client = new SmtpClient();
                    //client.Port = 25;
                    //client.DeliveryMethod = SmtpDeliveryMethod.Network;
                    //client.UseDefaultCredentials = false;
                    //client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "a1s2d3f4f");
                    //client.Host = "mail.google.com";
                    //mail.Subject = "this is a test email.";
                    //mail.Body = "this is my test email body";
                    //client.Send(mail);

                    pictureBox6.Select();
                }
            }
        }