public static string sent_queueservice(Queue_Service Q)
{
string query = String.Format("SELECT COUNT(*) FROM queue WHERE status_queue = '{0}'", Q.Queue_ID);
try
{
conn.Open();
command.CommandText = query;
int amountOfPatient = (int)command.ExecuteScalar();
if (amountOfPatient < 1)
{
query = String.Format("INSERT INTO queue (status_queue, sequence_queue ," +
"date_queue,time_queue , Patient_id)" +
" VALUES('{0}', '{1}','{2}', '{3}', '{4}')",
Q.status_Queue,
Q.sequence_queue,
Q.date_queue,
Q.time_queue,
Q.Patient_id
);
command.CommandText = query;
command.ExecuteNonQuery();
return("ส่งข้อมูลสมบูรณ์");
}
else
{
return("ส่งข้อมูลไม่สำเร็จ");
}
}
finally
{
conn.Close();
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
GridViewRow row = GridView1.SelectedRow;
Queue <int> sequence_queue = (Queue <int>)Session["TokenQueue"];
string name = row.Cells[0].Text;
int tokennumber = sequence_queue.Dequeue();
// textbox.Text = tokennumber.ToString();
// txtdisplay.Text = "Token Number " + tokennumber.ToString() + "Please go to couter " + coutercustomer.ToString();
Addtokenlast(sequence_queue);
int idPatient = Convert.ToInt32(name);
// if (Session["LastTokenNumberIssued"] == null)
// {
// Session["LastTokenNumberIssued"] = 0;
// }
// int nextTokenNumbertobeIssued = (int)Session["LastTokenNumberIssued"] + 1;
// Session["LastTokenNumberIssued"] = nextTokenNumbertobeIssued;
// sequence_queue.Enqueue(nextTokenNumbertobeIssued);
// sequence_queue.Enqueue(idPatient);
/* sequence_queue.Enqueue(idPatient);
* sequence_queue.Enqueue(idPatient);
* sequence_queue.Enqueue(idPatient);
* sequence_queue.Enqueue(idPatient);
* sequence_queue.Enqueue(idPatient);
* sequence_queue.Enqueue(idPatient);
* sequence_queue.Enqueue(idPatient);
* sequence_queue.Enqueue(idPatient);
* sequence_queue.Enqueue(idPatient);
* sequence_queue.Enqueue(idPatient);*/
// int count_queue = sequence_queue.Count;
// foreach (var i in sequence_queue.ToArray())
// {
string status_queue = "1";
string date = DateTime.Today.ToLongDateString();
string time_queue = DateTime.Now.ToString("h:mm:ss tt");
ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ส่งข้อมูลเสร็จสิ้น');", true);
String Name = "" + Session["staff_name"];
// sequence_queue.Dequeue();
// foreach (int token in sequence_queue)
// {
// lbltoken.Items.Add(token.ToString());
// string se =token.ToString();
// int num_queue = Convert.ToInt32(se);
Queue_Service ser = new Queue_Service(status_queue, tokennumber, date, time_queue, idPatient);
Queue_Service.sent_queueservice(ser);
// }
// }
/* while (sequence_queue.Count > 6)
* {
* }
*
*
*/
// ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('Call " + idPatient + "');", true);
// string index = GridView1.SelectedRow.Cells[1].Text;
// ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('คุณเลือกค" + index + "');", true);
/* foreach (GridViewRow row in GridView1.Rows)
* {
* if (row.RowIndex == GridView1.SelectedIndex)
* {
* row.BackColor = ColorTranslator.FromHtml("#A1DCF2");
* }
* else
* {
* row.BackColor = ColorTranslator.FromHtml("#FFFFFF");
* }
* }*/
}
catch (Exception w)
{
lblstatus.Text = "คิวว่าง " + w.Message;
// ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('คิวว่าง' "+w.Message+");", true);
}
}
