private void combostatus_SelectedIndexChanged(object sender, EventArgs e)
{
string query = ("Update schedule_work_doctor set swd_note = '" + combostatus.SelectedItem.ToString() + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
clinic_timeschedule doc1 = new clinic_timeschedule();
doc1.Show();
clinic_timeschedule clnlog = new clinic_timeschedule();
clnlog.Close();
Visible = false;
MessageBox.Show("เปลี่ยนสถานะ " + combostatus.SelectedItem.ToString() + " เรียบร้อย");
}
private void button2_Click(object sender, EventArgs e)
{
string query = ("Update schedule_work_doctor set swd_start_time = '" + txtstarttime.Text + "' ,swd_end_time = '" + txtendtime.Text + "',swd_note = '" + txtremark.Text + "' where room_id = '" + txtroom.Text + "' AND swd_timezone = '" + txttimezone.Text + "' AND swd_day_work = '" + txtday.Text + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
clinic_timeschedule doc1 = new clinic_timeschedule();
doc1.Show();
clinic_timeschedule clnlog = new clinic_timeschedule();
clnlog.Close();
Visible = false;
MessageBox.Show("เปลี่ยนแปลงตารางเรียบร้อย");
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string query = ("Update schedule_work_doctor set swd_month_work = '" + comboBox1.SelectedItem.ToString() + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
clinic_timeschedule doc1 = new clinic_timeschedule();
doc1.Show();
clinic_timeschedule clnlog = new clinic_timeschedule();
clnlog.Close();
Visible = false;
MessageBox.Show("จัดตารางปฏิบัติงานแพทย์ประจำเดือน " + comboBox1.SelectedItem.ToString());
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
string com = comboBox2.SelectedItem.ToString();
int open = DateTime.Now.Day;
int next = open + 20;
// MessageBox.Show("เปลี่ยนเป็นสถานะ ปิด ");
string query = ("Update schedule_work_doctor set swd_status_room = 0 ,emp_doc_id = 0 ,swd_work_place = '',swd_emp_work_place = '',swd_note = '',swd_status = '" + comboBox2.SelectedItem.ToString() + "',swd_end_date = '' ");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
conn.Close();
clinic_timeschedule doc1 = new clinic_timeschedule();
doc1.Show();
clinic_timeschedule clnlog = new clinic_timeschedule();
clnlog.Close();
Visible = false;
MessageBox.Show("เปลี่ยนเป็นสถานะ " + comboBox2.SelectedItem.ToString());
// string today = DateTime.Now.ToString("dd-MM-yyyy", new CultureInfo("th-TH"));
// string end_date = dateTimePicker1.Text;
// groupBox4.Visible = true;
/*
* string query = ("Update schedule_work_doctor set swd_status_room = 0 ,emp_doc_id = 0 ,swd_status = '" + comboBox2.SelectedItem.ToString() + "'");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
*
* sda.Fill(dt);
* conn.Close();
* clinic_timeschedule doc1 = new clinic_timeschedule();
* doc1.Show();
* clinic_timeschedule clnlog = new clinic_timeschedule();
* clnlog.Close();
* Visible = false;
* MessageBox.Show("เปลี่ยนเป็นสถานะ " + comboBox2.SelectedItem.ToString());
*/
}
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
/* string date = dateTimePicker1.Text;
* lbldate.Text = date;
*/
string query = ("Update schedule_work_doctor set swd_end_date = '" + dateTimePicker1.Text + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
clinic_timeschedule doc1 = new clinic_timeschedule();
doc1.Show();
clinic_timeschedule clnlog = new clinic_timeschedule();
clnlog.Close();
Visible = false;
// groupBox4.Visible = true;
// lbldate.Text = ""+ dateTimePicker1.Text;
}
private void timeToolStripMenuItem_Click(object sender, EventArgs e)
{
clinic_timeschedule sc = new clinic_timeschedule();
sc.Show();
}
