public static string centel_chenge_swd_doc_work(schedule_work_doctor swd)
    {
        // string query = String.Format("SELECT COUNT(*) from schedule_work_doctor swd inner join room on room.room_id = swd.room_id where swd_day_work = '{0}' AND swd_start_time = '{1}'  AND swd_status_room = 1 ", swd.swd_day_work,swd.swd_start_time);
        try
        {
            //    conn.Open();
            //  command.CommandText = query;
            //  int amountOfUsers = (int)command.ExecuteScalar();
            //  if (amountOfUsers < 1)
            //  {
            string query = String.Format("Update schedule_work_doctor set swd_note = '',swd_status_room = 1 where swd_id = {0}", swd.swd_id);
            conn.Open();
            command.CommandText = query;
            command.ExecuteNonQuery();


            return("ยกเลิกการทำงานแทนเรียบร้อย");
            //  }
            // else
            //  {
            // return "ห้องตรวจซ้ำ กรุณาเลือกใหม่";
            //  }
        }
        finally
        {
            conn.Close();
        }
    }
Exemplo n.º 2
0
    /*
     * protected void btnsubmit_Click(object sender, EventArgs e)
     * {
     *  string name = "" + Session["doc_name"];
     *  //  int s = 1;
     *  doctor doc = doctor.doc_idshow(name);
     *  if (doc != null)
     *  {
     *      schedule_work_doctor swd = new schedule_work_doctor(DropDownList2.SelectedIndex.ToString(), DropDownList3.SelectedIndex.ToString(), Convert.ToInt32(DropDownList1.SelectedIndex.ToString()), doc.emp_doc_id);
     *
     *      ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true);
     *  }
     * }
     */
    protected void btnsummit_Click(object sender, EventArgs e)
    {
        try
        {
            schedule_work_doctor swd = new schedule_work_doctor(Convert.ToInt32(txtswd.Text));

            schedule_work_doctor.update_chenge_note(swd);



            //ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.update_chenge_note(swd) + "');", true);



            Response.Redirect("../page/next_swd.aspx");


            // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + doc.emp_doc_id + "');", true);

            //     schedule_work_doctor swd = new schedule_work_doctor(DropDownList1.SelectedValue.ToString(), DropDownList2.SelectedValue.ToString(), Convert.ToInt32(txtroom.Text), doc.emp_doc_id);

            //   ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.update_next_swd(swd) + "');", true);



            //  int s = 1;


            // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + DropDownList1.SelectedValue.ToString()+ "');", true);
        }
        catch (Exception)
        {
        }
    }
    public static schedule_work_doctor swd_show(string name)
    {
        string query = String.Format("select schedule_work_doctor.swd_day_work, schedule_work_doctor.swd_start_time, schedule_work_doctor.room_id, schedule_work_doctor.swd_note from schedule_work_doctor inner join employee_doctor on employee_doctor.emp_doc_id = schedule_work_doctor.emp_doc_id where emp_doc_name = '{0}'", name);

        try
        {
            conn.Open();
            command.CommandText = query;
            SqlDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                string swd_day_work   = reader.GetString(0);
                string swd_start_time = reader.GetString(1);
                int    room_id        = reader.GetInt32(2);



                schedule_work_doctor swd = new schedule_work_doctor(swd_day_work, swd_start_time, room_id, name);
                return(swd);
            }
        }
        finally
        {
            conn.Close();
        }

        return(null);
    }
    public static string updateswd2(schedule_work_doctor swd)
    {
        string query = String.Format("SELECT COUNT(*) from schedule_work_doctor where swd_status_room = 1 AND emp_doc_id = {0}  AND swd_start_time = '{1}' AND swd_day_work = '{2}' AND swd_date_work = '{3}'", swd.emp_doc_id, swd.swd_start_time, swd.swd_day_work, swd.swd_date_work);

        try
        {
            conn.Open();
            command.CommandText = query;
            int amountOfUsers = (int)command.ExecuteScalar();
            if (amountOfUsers < 1)
            {
                query = String.Format("Update schedule_work_doctor set swd_status_room = 3,swd_note = 'รอการอนุมัติการเลื่อนปฏิบัติงาน',emp_doc_id = {0} where room_id = {1} AND swd_start_time = '{2}' AND swd_day_work = '{3}' AND swd_date_work = '{4}'", swd.emp_doc_id, swd.room_id, swd.swd_start_time, swd.swd_day_work, swd.swd_date_work);
                //  conn.Open();
                command.CommandText = query;
                command.ExecuteNonQuery();
                return("รอการอนุมัติการเลื่อนปฏิบัติงาน");
            }
            else
            {
                return("ห้องตรวจซ้ำ กรุณาเลือกใหม่");
            }
        }
        finally
        {
            conn.Close();
        }
    }
    public static string updateswd(schedule_work_doctor swd)
    {
        string query = String.Format("SELECT COUNT(*) from schedule_work_doctor where swd_status_room = 1 AND emp_doc_id = {0}  AND swd_start_time = '{1}' AND swd_day_work = '{2}' AND swd_date_work = '{3}'", swd.emp_doc_id, swd.swd_start_time, swd.swd_day_work, swd.swd_date_work);

        try
        {
            conn.Open();
            command.CommandText = query;

            /*     query = String.Format("SELECT COUNT(swd_status_room) from schedule_work_doctor where swd_status_room = 1  AND swd_start_time = '{0}' AND swd_day_work = '{1}' AND swd_date_work = '{2}'", swd.swd_start_time, swd.swd_day_work, swd.swd_date_work);
             *    command.CommandText = query;
             *    int count_enp_id = (int)command.ExecuteScalar();*/
            int amountOfUsers = (int)command.ExecuteScalar();
            if (amountOfUsers < 1)
            {
                query = String.Format("Update schedule_work_doctor set swd_status_room = 1,emp_doc_id = {0} where room_id = {1} AND swd_start_time = '{2}' AND swd_day_work = '{3}' AND swd_date_work = '{4}'", swd.emp_doc_id, swd.room_id, swd.swd_start_time, swd.swd_day_work, swd.swd_date_work);
                // conn.Open();
                command.CommandText = query;
                command.ExecuteNonQuery();
                return("ลงเวลาเรียบร้อย");
            }
            else
            {
                return("ห้องตรวจซ้ำ กรุณาเลือกใหม่");
            }
        }
        finally
        {
            conn.Close();
        }
    }
    public static schedule_work_doctor swd_work(int ID)
    {
        string query = String.Format("select schedule_work_doctor.swd_status_room,employee_doctor.emp_doc_name from employee_doctor inner join schedule_work_doctor on schedule_work_doctor.emp_doc_id = employee_doctor.emp_doc_id where employee_doctor.emp_doc_id = '{0}' AND swd_status_room = 4", ID);

        try
        {
            conn.Open();
            command.CommandText = query;
            SqlDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                int    swd_status_room1 = reader.GetInt32(0);
                string emp_name         = reader.GetString(1);



                schedule_work_doctor swd = new schedule_work_doctor(swd_status_room1, emp_name);
                return(swd);
            }
        }
        finally
        {
            conn.Close();
        }

        return(null);
    }
    public static schedule_work_doctor check_room_5(DateTime day, int empdoctorid)
    {
        string query = string.Format("select swd_start_time,swd_status_room, room_id ,emp_doc_id from schedule_work_doctor where swd_status_room = 1  AND  swd_date_work = '{0}' AND emp_doc_id = {1}", day, empdoctorid);

        try
        {
            conn.Open();
            command.CommandText = query;
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                string swd_start_time    = reader.GetString(0);
                int    swd_status_room   = reader.GetInt32(1);
                int    room_id           = reader.GetInt32(2);
                int    emp_doc_id1       = reader.GetInt32(3);
                schedule_work_doctor swd = new schedule_work_doctor(swd_start_time, swd_status_room, room_id, emp_doc_id1);
                return(swd);
            }
        }
        finally
        {
            conn.Close();
        }
        return(null);
    }
Exemplo n.º 8
0
 protected void btncencel_Click(object sender, EventArgs e)
 {
     try
     {
         int    id_swd_work_doctor = Convert.ToInt32(lblswdid.Text);
         doctor doc_id             = doctor.doc_idshow(lbldoctorre.Text);
         if (doc_id != null)
         {
             schedule_work_doctor swd_cencel = new schedule_work_doctor(doc_id.emp_doc_id, id_swd_work_doctor, doc_id.emp_doc_id);
             //   schedule_work_doctor swd_doc_cencel = new schedule_work_doctor(doc_id.emp_doc_id);
             //  schedule_work_doctor.centel_chenge_swd_doc_work(swd_doc_cencel);
             //  ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.centel_chenge_swd_doc_work(swd_cencel) + "');", true);
             ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.centel_chenge_note_work(swd_cencel) + "');", true);
         }
     }
     catch (Exception)
     {
     }
 }
Exemplo n.º 9
0
    protected void btnsubmit_Click(object sender, EventArgs e)
    {
        try
        {
            string name = "" + Session["doc_name"];

            int    id_swd_work_doctor = Convert.ToInt32(lblswdid.Text);
            doctor doc = doctor.doc_idshow(name);
            if (doc != null)
            {
                schedule_work_doctor swd = new schedule_work_doctor(id_swd_work_doctor);
                ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.update_chenge_note_work(swd) + "');", true);
                Response.Redirect("../Page/index_doctor.aspx");
            }
        }
        catch (Exception)
        {
        }
    }
Exemplo n.º 10
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //    GetData();

        lbldoctor.Text = "" + Session["doc_name"];

        int id = Convert.ToInt32(Session["doc_id"]);

        btnworkswd.Visible = false;
        schedule_work_doctor sc = schedule_work_doctor.swd_work(id);

        if (sc != null)
        {
            if (sc.swd_status_room == 4)
            {
                btnworkswd.Visible = true;
                //  Response.Redirect("../page/schedule_work.aspx");
            }
        }
    }
Exemplo n.º 11
0
    public static schedule_work_doctor check_swdid_doctor(string name, string date_swd)
    {
        string query = string.Format("select swd_id from schedule_work_doctor inner join employee_doctor on employee_doctor.emp_doc_id = schedule_work_doctor.emp_doc_id where employee_doctor.emp_doc_name = '{0}' AND swd_date_work = '{1}'", name, date_swd);

        try
        {
            conn.Open();
            command.CommandText = query;
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                int swd_id = reader.GetInt32(0);
                schedule_work_doctor swd = new schedule_work_doctor(swd_id);
                return(swd);
            }
        }
        finally
        {
            conn.Close();
        }
        return(null);
    }
    protected void btnsubmit_Click(object sender, EventArgs e)
    {
        try
        {
            CultureInfo culture  = new CultureInfo("th-TH");
            string      date     = txtdate.Text;
            string      time     = txttimeapp.Text;
            string      name     = "" + Session["opd_name_app"];
            string      remark   = "" + Session["remark_app"];
            string      name_doc = "" + Session["doctor_app"];
            doctor      doc_name = doctor.doc_idshow(name_doc);

            DateTime day = Convert.ToDateTime(date, culture);

            string date_app  = day.ToString("yyyy-MM-dd", culture);
            string app_day   = txtday.Text;
            double time_zone = Convert.ToDouble(time);
            string date_work = day.ToString("yyyy-MM-dd", culture);

            DateTime today_th = DateTime.Today;
            string   today    = today_th.ToString("yyyy-MM-dd", new CultureInfo("th-TH"));

            int today_day  = today_th.Day;
            int day_select = day.Day;
            if (time_zone <= 12.00)
            {
                if (day.Date >= today_th.Date)
                {
                    if (doc_name != null)
                    {
                        int doc_id = doc_name.emp_doc_id;
                        schedule_work_doctor ss = schedule_work_doctor.check_swdid_doctor(name_doc, date_app);
                        if (ss != null)
                        {
                            int         swd_id_app = ss.swd_id;
                            appointment app        = new appointment(doc_id, "เช้า", app_day, date_app, time, remark, name, date_work);

                            ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + appointment.update_app_doctor(app) + "');", true);

                            Response.Redirect("../page/nurse_index_opd.aspx");
                        }
                        else
                        {
                            //   ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('"+name_doc+"     "+date_app+"');", true);
                        }

                        //    ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + name_doc + "     " + date_app + "');", true);
                    }
                    else
                    {
                        //    ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ไม่อ่าน');", true);
                    }
                }
                else
                {
                    ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ไม่สามารถเลื่อนนัดได้');", true);
                }
            }
            else if (time_zone >= 12.01)
            {
                if (day.Date >= today_th.Date)
                {
                    if (doc_name != null)
                    {
                        int doc_id = doc_name.emp_doc_id;

                        schedule_work_doctor ss = schedule_work_doctor.check_swdid_doctor(name_doc, date_app);
                        if (ss != null)
                        {
                            int         swd_id_app = ss.swd_id;
                            appointment app        = new appointment(doc_id, "บ่าย", app_day, date_app, time, remark, name, date_work);

                            ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + appointment.update_app_doctor(app) + "');", true);

                            Response.Redirect("../page/nurse_index_opd.aspx");
                        }
                        else
                        {
                            //      ClientScript.RegisterStartupScript(GetType(), "hwa", "alert(' " + name + "  +   " + date_app + "');", true);
                        }
                    }
                }
                else
                {
                    ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ไม่สามารถเลื่อนนัดได้');", true);
                }
            }
        }
        catch (Exception)
        {
            ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ไม่สามารถเลื่อนนัดได้');", true);
        }
    }
    protected void btnsubmit_Click(object sender, EventArgs e)
    {
        string name = "" + Session["doc_name"];
        //  int s = 1;
        DateTime             day   = Convert.ToDateTime(TextBox2.Text);
        DateTime             today = DateTime.Today;
        string               time1 = DropDownList3.SelectedValue.ToString();
        schedule_work_doctor swd1  = schedule_work_doctor.check_room(day, time1);

        doctor doc       = doctor.doc_idshow(name);
        int    today_num = today.Day;

        if (today_num == 20)
        {
            ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('หมดเวลาในการลงทะเบียน');", true);
        }
        else
        {
            if (swd1 != null)
            {
                int    room_id     = swd1.room_id;
                int    status_room = swd1.swd_status_room;
                string time        = swd1.swd_start_time;



                if (doc != null)

                {
                    int doc_id = doc.emp_doc_id;

                    /*        schedule_work_doctor swd2 = schedule_work_doctor.check_room_1(day,room_id);
                     *      schedule_work_doctor swd3 = schedule_work_doctor.check_room_2(day, room_id,doc_id);
                     *      if(swd3 != null)
                     *      {
                     *          if (swd2 != null)
                     *          {
                     *              int room_id1 = swd2.room_id;
                     *              int status_room1 = swd2.swd_status_room;
                     *              string time2 = swd2.swd_start_time;
                     *              int emp_id = swd2.emp_doc_id;
                     *              int emp_doc_id = swd3.emp_doc_id;
                     *              if (emp_id == emp_doc_id)
                     *              {
                     *                  ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('มีแพทย์มาปฏิบัติงานแล้ว');", true);
                     *              }
                     *              else
                     *              {
                     *      ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ไม่เวลา111111111 " +emp_doc_id+" , "+emp_id+"');", true);
                     *        //     schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, TextBox2.Text, DropDownList3.SelectedValue.ToString(), room_id, doc.emp_doc_id);
                     *
                     *        //     ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true);
                     *
                     *              }
                     *
                     *
                     *          }
                     *
                     *
                     *
                     *
                     *      }*/

                    schedule_work_doctor swd2 = schedule_work_doctor.check_room_3(day, time, room_id);



                    schedule_work_doctor swd4 = schedule_work_doctor.check_room_5(day, doc_id);

                    if (swd2 != null)
                    {
                        int emp_doctor_id = swd2.emp_doc_id;

                        if (swd4 != null)
                        {
                            int roomiddoc = swd4.room_id;
                            int docid     = swd4.emp_doc_id;
                            int swd3      = schedule_work_doctor.check_room_4(roomiddoc, day);
                            if (swd3 == 0)
                            {
                                ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('มีแพทย์ทำงานห้องตรวจแล้ว');", true);
                            }
                            else
                            {
                                schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, TextBox2.Text, DropDownList3.SelectedValue.ToString(), roomiddoc, doc.emp_doc_id);
                                ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true);
                            }

                            /*
                             * if (room_id == 1 && time1 == time)
                             * {
                             *
                             *      ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + room_id + "   " + time1 + "     " + time + "');", true);
                             *
                             *
                             * }
                             * else if (room_id == 2 && time1 == time)
                             * {
                             *
                             *
                             *      ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + room_id + "   " + time1 + "     " + time + "');", true);
                             *
                             * }
                             * else if (room_id == 3 && time1 == time)
                             * {
                             *
                             *
                             *      ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + room_id + "   " + time1 + "     " + time + "');", true);
                             *
                             * }
                             *
                             */
                        }
                        else
                        {
                            schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, TextBox2.Text, DropDownList3.SelectedValue.ToString(), room_id, doc.emp_doc_id);
                            ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true);
                        }
                    }



                    //     if (room_id == 1 || time1 == time)
                    //   {

                    //              schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, TextBox2.Text, DropDownList3.SelectedValue.ToString(), room_id, doc.emp_doc_id);

                    //           ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true);
                    //      ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('มีแพทย์อยู่ห้องตรวจแล้ว12');", true);



                    //}
                    //else
                    // {


                    //   schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, TextBox2.Text, DropDownList3.SelectedValue.ToString(), room_id, doc.emp_doc_id);

                    //          ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true);

                    //   ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('มีแพทย์อยู่ห้องตรวจแล้ว12');", true);



                    // }

                    /*
                     * if (room_id == 1 && status_room == 0)
                     * {
                     *  schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, DropDownList3.SelectedValue.ToString(),1, doc.emp_doc_id);
                     *
                     *  ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true);
                     * }else if (room_id == 2 && status_room == 0)
                     * {
                     *  schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, DropDownList3.SelectedValue.ToString(), 2, doc.emp_doc_id);
                     *
                     *  ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true);
                     * }
                     * else if (room_id == 3 && status_room == 0)
                     * {
                     *  schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, DropDownList3.SelectedValue.ToString(), 3, doc.emp_doc_id);
                     *
                     *  ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true);
                     * }
                     *
                     */
                }
            }
            else
            {
                ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ห้องตรวจซ้ำกรุณาลงใหม่');", true);
            }
        }
    }
Exemplo n.º 14
0
    protected void btnsummit_Click(object sender, EventArgs e)
    {
        string name = "" + Session["doc_name"];
        //  int s = 1;
        DateTime             day   = Convert.ToDateTime(txtswdwork.Text);
        string               time1 = DropDownList1.SelectedValue.ToString();
        schedule_work_doctor swd1  = schedule_work_doctor.check_room(day, time1);

        if (swd1 != null)
        {
            int    room_id     = swd1.room_id;
            int    status_room = swd1.swd_status_room;
            string time        = swd1.swd_start_time;
            doctor doc         = doctor.doc_idshow(name);
            if (doc != null)

            {
                int doc_id = doc.emp_doc_id;
                schedule_work_doctor swd2 = schedule_work_doctor.check_room_3(day, time, room_id);

                schedule_work_doctor swd4 = schedule_work_doctor.check_room_5(day, doc_id);
                int swd5 = schedule_work_doctor.check_room_6(day, doc_id);
                if (swd5 == 1)
                {
                    ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('มีแพทย์ทำงานในห้องตรวจแล้ว');", true);
                }
                else
                {
                    if (swd2 != null)
                    {
                        if (swd4 != null)
                        {
                            int roomiddoc = swd4.room_id;
                            int docid     = swd4.emp_doc_id;
                            int swd3      = schedule_work_doctor.check_room_4(roomiddoc, day);
                            if (swd3 == 0)
                            {
                                ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('มีแพทย์ทำงานห้องตรวจแล้ว');", true);
                            }
                            else
                            {
                                schedule_work_doctor swd = new schedule_work_doctor(txtday.Text, txtswdwork.Text, time1, roomiddoc, doc.emp_doc_id);
                                ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd2(swd) + "');", true);
                                Response.Redirect("../Page/index_doctor.aspx");
                            }
                        }
                        else
                        {
                            schedule_work_doctor swd = new schedule_work_doctor(txtday.Text, txtswdwork.Text, time1, room_id, doc.emp_doc_id);
                            ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd2(swd) + "');", true);
                            Response.Redirect("../Page/index_doctor.aspx");
                        }
                    }
                }



                //  ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + room_id + "');", true);

                /*        schedule_work_doctor swd = new schedule_work_doctor(txtday.Text, txtswdwork.Text, time1, room_id, doc.emp_doc_id);
                 *  if (room_id == 1 || time1 == time)
                 *    {
                 *
                 *        string update = schedule_work_doctor.updateswd2(swd);
                 *        if (update == "ห้องตรวจซ้ำ กรุณาเลือกใหม่")
                 *        {
                 *            ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ห้องตรวจซ้ำ กรุณาเลือกใหม่');", true);
                 *        }
                 *        else
                 *        {
                 *            ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd2(swd) + "');", true);
                 *            Response.Redirect("../Page/index_doctor.aspx");
                 *        }
                 *
                 *
                 *   //   Response.Redirect("../Page/index_doctor.aspx");
                 *        //   ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + room_id + "');", true);
                 *
                 *
                 *    }
                 *    else
                 *    {
                 *        string update = schedule_work_doctor.updateswd2(swd);
                 *        if (update == "ห้องตรวจซ้ำ กรุณาเลือกใหม่")
                 *        {
                 *            ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ห้องตรวจซ้ำ กรุณาเลือกใหม่');", true);
                 *        }
                 *        else
                 *        {
                 *            ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd2(swd) + "');", true);
                 *            Response.Redirect("../Page/index_doctor.aspx");
                 *        }
                 *
                 *
                 *        //     ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd2(swd) + "');", true);
                 *        //    Response.Redirect("../Page/index_doctor.aspx");
                 *    }
                 */
                /*
                 * if (room_id == 1 && status_room == 0)
                 * {
                 *  schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, DropDownList3.SelectedValue.ToString(),1, doc.emp_doc_id);
                 *
                 *  ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true);
                 * }else if (room_id == 2 && status_room == 0)
                 * {
                 *  schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, DropDownList3.SelectedValue.ToString(), 2, doc.emp_doc_id);
                 *
                 *  ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true);
                 * }
                 * else if (room_id == 3 && status_room == 0)
                 * {
                 *  schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, DropDownList3.SelectedValue.ToString(), 3, doc.emp_doc_id);
                 *
                 *  ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true);
                 * }
                 *
                 */
            }
        }
    }