protected void bthnoteok_Click(object sender, EventArgs e)
{
UserScanDAO userscan = new UserScanDAO();
int memberuserid = Convert.ToInt32(this.DecryptQueryString("userid").ToString());
DataTable dt = userscan.GetUserScanByIDMember(memberuserid);
if (dt.Rows.Count > 0)
{
if (txtcomment.Text.Trim() != "")
{
string datetimeup = dt.Rows[0]["datetime_up"].ToString();
string datetimedown = dt.Rows[0]["datetime_down"].ToString();
if (datetimeup == "ยังไม่ได้สแกน")
{
if (chkup.Checked == true)
{
userscan.UpdateUserScanByIDMember_Up(memberuserid, txtcomment.Text.Trim());
userscan.UpdateUserScanByIDMember_Noteup(memberuserid, 1);
}
}
if (datetimedown == "ยังไม่ได้สแกน")
{
if (chkdown.Checked == true)
{
userscan.UpdateUserScanByIDMember_Down(memberuserid, txtcomment.Text.Trim());
userscan.UpdateUserScanByIDMember_Notedown(memberuserid, 1);
}
}
}
}
}
public void UpdateUserScanByMemberid(string trunscan, string topicsearch) // สถานะการสแกน
{
client.ProtocolVersion = MqttProtocolVersion.Version_3_1;
try
{
client.Connect(Guid.NewGuid().ToString(),
"fjhgvxul",
"cT9BYUzB5yCR",
true, // will retain flag
MqttMsgBase.QOS_LEVEL_EXACTLY_ONCE, // will QoS
true, // will flag
"/test", // will topic
"default", // will message
true,
60);
}
catch
{
Debug.WriteLine("Error Connect");
}
client.MqttMsgPublishReceived += client_MqttMsgPublishRecieved_GetSubscribe;
// client.Subscribe(new string[] { topicup,topicdown }, new byte[] { MqttMsgBase.QOS_LEVEL_EXACTLY_ONCE , MqttMsgBase.QOS_LEVEL_AT_LEAST_ONCE});
client.Subscribe(new string[] { topicsearch }, new byte[] { MqttMsgBase.QOS_LEVEL_EXACTLY_ONCE });
Debug.WriteLine("OnGetSubscribeUp");
void client_MqttMsgPublishRecieved_GetSubscribe(object sender, MqttMsgPublishEventArgs e)
{
UserScanDAO userscan = new UserScanDAO();
if (trunscan == "ขึ้นรถรับส่งเด็กนักเรียน")
{
string fingerprintid = Encoding.UTF8.GetString(e.Message);
int memberuserid = Convert.ToInt32(fingerprintid);
Debug.WriteLine("Received = " + fingerprintid + "\ron topic = " + e.Topic + "\rtrunscan = " + trunscan + DateTime.Now.ToString("dd-MM-yyyy เวลา HH:mm:ss\r"));
userscan.UpdateUserScanByIDMember_Up(memberuserid, DateTime.Now.ToString("dd-MM-yyyy เวลา HH:mm:ss"));
//userscan.UpdateUserScanByFingerprintid_Up(fingerprintid, DateTime.Now.ToString("dd-MM-yyyy เวลา HH:mm:ss"));
Debug.WriteLine("OKScanup");
client.Disconnect();
}
if (trunscan == "ลงรถรับส่งเด็กนักเรียน")
{
string fingerprintid = Encoding.UTF8.GetString(e.Message);
int memberuserid = Convert.ToInt32(fingerprintid);
Debug.WriteLine("Received = " + fingerprintid + "\ron topic = " + e.Topic + "\rtrunscan = " + trunscan + DateTime.Now.ToString("dd-MM-yyyy เวลา HH:mm:ss\n"));
userscan.UpdateUserScanByIDMember_Down(memberuserid, DateTime.Now.ToString("dd-MM-yyyy เวลา HH:mm:ss"));
//userscan.UpdateUserScanByFingerprintid_Down(fingerprintid, DateTime.Now.ToString("dd-MM-yyyy เวลา HH:mm:ss"));
Debug.WriteLine("OKScanDown");
client.Disconnect();
}
}
}
public void client_MqttMsgPublishRecieved_GetSubscribe(object sender, MqttMsgPublishEventArgs e)
{
UserScanDAO userscan = new UserScanDAO();
string trunscan = ViewState["trunscan"].ToString();
if (trunscan == "ขึ้นรถรับส่งเด็กนักเรียน")
{
string fingerprintid = Encoding.UTF8.GetString(e.Message);
if (fingerprintid == "disconnect")
{
Debug.WriteLine("Received = " + fingerprintid + "\ron topic = " + e.Topic + "\rtrunscan = " + trunscan + datetime());
client_scan.Disconnect();
}
else if (fingerprintid == "fail")
{
Debug.WriteLine("Disconnect");
client_scan.Disconnect();
Timer = true;
}
else
{
int memberuserid = Convert.ToInt32(fingerprintid);
Debug.WriteLine("Received = " + fingerprintid + "\ron topic = " + e.Topic + "\rtrunscan = " + trunscan + datetime());
userscan.UpdateUserScanByIDMember_Noteup(memberuserid, 0);
userscan.UpdateUserScanByIDMember_Up(memberuserid, datetime());
//userscan.UpdateUserScanByFingerprintid_Up(fingerprintid, DateTime.Now.ToString("dd-MM-yyyy เวลา HH:mm:ss"));
Debug.WriteLine("OKScanup");
client_scan.Disconnect();
Timer = true;
}
}
if (trunscan == "ลงรถรับส่งเด็กนักเรียน")
{
string fingerprintid = Encoding.UTF8.GetString(e.Message);
if (fingerprintid == "disconnect")
{
Debug.WriteLine("Received = " + fingerprintid + "\ron topic = " + e.Topic + "\rtrunscan = " + trunscan + datetime());
client_scan.Disconnect();
Timer = true;
}
else if (fingerprintid == "fail")
{
Debug.WriteLine("Disconnect");
client_scan.Disconnect();
Timer = true;
}
else
{
int memberuserid = Convert.ToInt32(fingerprintid);
Debug.WriteLine("Received = " + fingerprintid + "\ron topic = " + e.Topic + "\rtrunscan = " + trunscan + datetime());
userscan.UpdateUserScanByIDMember_Notedown(memberuserid, 0);
userscan.UpdateUserScanByIDMember_Down(memberuserid, datetime());
//userscan.UpdateUserScanByFingerprintid_Down(fingerprintid, DateTime.Now.ToString("dd-MM-yyyy เวลา HH:mm:ss"));
Debug.WriteLine("OKScanDown");
client_scan.Disconnect();
Timer = true;
}
}
}