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);
}
}
}
}
}
protected void bthOKSave_Click(object sender, EventArgs e)
{
int memberuserid = Convert.ToInt32(this.DecryptQueryString("userid").ToString());
UserDAO user = new UserDAO();
MemberDAO member = new MemberDAO();
UserScanDAO userscan = new UserScanDAO();
DataTable dt = new SchoolAddressDAO().GetSchoolAddressByDetailaddress(txtshcool.Text.Trim());
if (dt.Rows.Count > 0)
{
int schoolid = Convert.ToInt32(dt.Rows[0]["school_id"].ToString());
user.UpdateUserByMember(memberuserid, schoolid, txtid.Text.Trim(), txtfullname.Text.Trim(), txtfullnameparent.Text.Trim(),
txttel.Text.Trim(), txtemail.Text.Trim());
//if(chkactive.Checked==false)
//{
// member.UpdateMemberByIsactive(memberuserid, chkactive.Checked);
// userscan.UpdateUserScanByActivescan(memberuserid, false);
//}
//else
//{
// member.UpdateMemberByIsactive(memberuserid, chkactive.Checked);
// userscan.UpdateUserScanByActivescan(memberuserid, chkactivescan.Checked);
//}
userscan.UpdateUserScanByActivescan(memberuserid, chkactivescan.Checked);
BindDataUser();
}
}
private void Checkstatus(int memberid)
{
DataTable dt = new MemberDAO().GetMember(memberid);
if (dt.Rows.Count > 0)
{
string status = dt.Rows[0]["createdby"].ToString();
if (status == "Driver")
{
int memberUserid = Convert.ToInt32(ViewState["memberUser_id"].ToString());
UserScanDAO userscan = new UserScanDAO();
userscan.AddUserScanByIDMember(memberUserid, "ไม่ได้ลงทะบียนสแกน", "ไม่ได้ลงทะบียนสแกน", 0, 0, 0, datetime(), false, 0, "");
Response.Redirect("../Driver/FingerPrintscan.aspx" +
this.EncryptQueryString("userid=" + memberUserid + "&driverid=" + memberid));
//cookiesdatauseranddriver(memberUser, memberid);
}
else if (status == "User")
{
txtusername_password.Text = "Username and/or password is incorrect.";
}
}
}
private void userScan()
{
int memberuserid = Convert.ToInt32(ViewState["memberuser_id"].ToString());
DataTable dt = new UserScanDAO().GetUserScanByIDMember(memberuserid);
if (dt.Rows.Count > 0)
{
labstatusup.Text = dt.Rows[0]["datetime_up"].ToString();
string noteup = dt.Rows[0]["noteup"].ToString();
int roundscan = Convert.ToInt32(dt.Rows[0]["roundscan"].ToString());
if (roundscan == 1)
{
labroundscan.Text = " บ้าน >>> โรงเรียน";
}
else if (roundscan == 2)
{
labroundscan.Text = " โรงเรียน >>> บ้าน";
}
else
{
labroundscan.Text = "";
}
//............................................................................//
if (labstatusup.Text == "ยังไม่ได้สแกน")
{
labstatusup.BackColor = System.Drawing.ColorTranslator.FromHtml("#FF3333");// สีแดง
}
else if (noteup == "1")
{
labstatusup.BackColor = System.Drawing.ColorTranslator.FromHtml("#FF9900"); // สีส้ม
}
else
{
labstatusup.BackColor = System.Drawing.ColorTranslator.FromHtml("#009900"); // สีเขียว
}
labstatusdown.Text = dt.Rows[0]["datetime_down"].ToString();
string notedown = dt.Rows[0]["notedown"].ToString();
if (labstatusdown.Text == "ยังไม่ได้สแกน")
{
labstatusdown.BackColor = System.Drawing.ColorTranslator.FromHtml("#FF3333"); // สีแดง
}
else if (notedown == "1")
{
labstatusdown.BackColor = System.Drawing.ColorTranslator.FromHtml("#FF9900"); // สีส้ม
}
else
{
labstatusdown.BackColor = System.Drawing.ColorTranslator.FromHtml("#009900"); // สีเขียว
}
}
}
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();
}
}
}
protected void bthOKSave_Click(object sender, EventArgs e)
{
int memberUserid = Convert.ToInt32(ViewState["memberUser_id"].ToString());
MemberDAO Member = new MemberDAO();
UserScanDAO userscan = new UserScanDAO();
Member.UpdateMemberByIsactive(memberUserid, true);
userscan.AddUserScanByIDMember(memberUserid, "ไม่ได้ลงทะบียนสแกน", "ไม่ได้ลงทะบียนสแกน", 0, 0, 0, datetime(), false, 0, "");
Response.Redirect("../Login.aspx");
}
protected void bthreset_Click(object sender, EventArgs e)
{
Timer = true;
foreach (GridViewRow row in gvMember.Rows)
{
int rowIndex = row.RowIndex;
if (row.RowType == DataControlRowType.DataRow)
{
int Memberuserid = Convert.ToInt32(gvMember.DataKeys[rowIndex].Values[0].ToString());
UserScanDAO UserScan = new UserScanDAO();
UserScan.UpdateUserScanByIDMemberReset(Memberuserid, "ยังไม่ได้สแกน", "ยังไม่ได้สแกน");
}
}
}
protected void bthresetok_Click(object sender, EventArgs e)
{
UserScanDAO userscan = new UserScanDAO();
int memberuserid = Convert.ToInt32(this.DecryptQueryString("userid").ToString());
if (chkupreset.Checked == true)
{
userscan.UpdateUserScanByIDMemberReset_Up(memberuserid, "ยังไม่ได้สแกน");
}
if (chkdownreset.Checked == true)
{
userscan.UpdateUserScanByIDMemberReset_Down(memberuserid, "ยังไม่ได้สแกน");
}
}
private void CheckIsactive(int memberuserid)
{
// MemberDAO Member = new MemberDAO();
UserScanDAO userscan = new UserScanDAO();
DataTable dt = userscan.GetUserScanByIDMember(memberuserid);
if (dt.Rows.Count > 0)
{
bool isactive = (bool)dt.Rows[0]["activescan"];
if (isactive == true)
{
labscan.Text = "ทำการสแกนลายนิ้วมือเรียบร้อยแล้ว";
Imgfingerprint.ImageUrl = "~/Images/true.png";
bthSaveFinish.Visible = false;
}
}
}
public void client_MqttMsgPublishRecieved(object sender, MqttMsgPublishEventArgs e)
{
//string status_fingerprint = Encoding.UTF8.GetString(e.Message); // รับ message จากตัวสแกนลายนิ้วมือ ok กับ fail
// Debug.WriteLine("Received = " + Encoding.UTF8.GetString(e.Message) + "\ron topic = " + e.Topic);
string topiocmessage = ViewState["topicmessage"].ToString();
if (e.Topic == topiocmessage)
{
int memberuserid = Convert.ToInt32(ViewState["MemberUser_id"].ToString());
int memberdriverid = Convert.ToInt32(ViewState["MemberDriver_id"].ToString());
string status_fingerprint = Encoding.UTF8.GetString(e.Message); // รับ message จากตัวสแกนลายนิ้วมือ ok กับ fail
DataTable dt = new DriverDAO().GetDriverByIDMember(memberdriverid); // รับชื่อของคนขับรถที่เป็นร่วม
if (status_fingerprint == "ok")
{
if (dt.Rows.Count > 0)
{
Debug.WriteLine("Received = " + Encoding.UTF8.GetString(e.Message) + "\ron topic = " + e.Topic + "\rMemberuserid = " + memberuserid);
string fullnamedriver = dt.Rows[0]["fullname"].ToString();
status = status_fingerprint; // ส่ง ok กับ fail
//..................... ทำการเพิ่มลายนิ้วมือลงไป database .......................//
UserScanDAO Userscan = new UserScanDAO();
Userscan.UpdateUserScanByMember(memberuserid, "ยังไม่ได้สแกน", "ยังไม่ได้สแกน", fullnamedriver, true, 1, datetime());
//..................... เปิกการใช้งานของ user ................................//
MemberDAO Member = new MemberDAO();
Member.UpdateMemberByIsactive(memberuserid, true);
Member.UpdateMemberByRegister(memberuserid, 3);
client_Addscan.Disconnect(); // Disconnect mqtt
}
}
else if (status_fingerprint == "fail")
{
status = status_fingerprint; // ส่ง ok กับ fail
client_Addscan.Disconnect();
}
else if (status_fingerprint == "disconnect")
{
client_Addscan.Disconnect();
}
}
}
private void Binddata() // แสดงข้อมูลเด็กนักเรียนที่ให้สแกนกับคนขับรถที่ login เข้ามาบนตาราง
{
int Memberdriverid = Convert.ToInt32(ViewState["member_driver_id"].ToString());
int roundscan = Convert.ToInt32(ViewState["roundscan"].ToString());
DataTable dtdriverid = new DriverDAO().GetDriverByIDMember(Memberdriverid);
if (dtdriverid.Rows.Count > 0)
{
string fullnamedriver = dtdriverid.Rows[0]["fullname"].ToString();
DataTable dt = new UserScanDAO().GetUserScanJoin_tbUserBySuccess(fullnamedriver, true, roundscan); // เช็คชื่อคนขับรถรับส่งที่จะให้สแกน
gvMember.DataSource = dt;
gvMember.DataBind();
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
labcheckscan.Visible = false;
chkactivescan.Enabled = true;
imgcheckscan.Visible = false;
int memberuserid = Convert.ToInt32(this.DecryptQueryString("userid").ToString());
DataTable dt = new UserDAO().GetUserSelectJointbSchooladdress_ByIDMember(memberuserid);
DataTable dtmember = new MemberDAO().GetMember(memberuserid);
DataTable dtuserscan = new UserScanDAO().GetUserScanByIDMember(memberuserid);
if (dt.Rows.Count > 0 && dtmember.Rows.Count > 0 && dtuserscan.Rows.Count > 0)
{
txtid.Text = dt.Rows[0]["id"].ToString();
txtfullname.Text = dt.Rows[0]["fullname"].ToString();
txtshcool.Text = dt.Rows[0]["detailaddress"].ToString();
BindDataschool();
txtfullnameparent.Text = dt.Rows[0]["fullnameparent"].ToString();
txttel.Text = dt.Rows[0]["tel"].ToString();
txtemail.Text = dt.Rows[0]["email"].ToString();
string checkscan = dtuserscan.Rows[0]["checkscan"].ToString();
if (checkscan == "0")
{
labcheckscan.Visible = true;
// chkactive.Enabled = false;
chkactivescan.Enabled = false;
imgcheckscan.ImageUrl = "~/Images/ajax_loader_gray_48.gif";
imgcheckscan.Visible = true;
imgcheckscan.Width = 20;
imgcheckscan.Height = 20;
// chkactive.Checked = (bool)dtmember.Rows[0]["is_active"];
chkactivescan.Checked = (bool)dtuserscan.Rows[0]["activescan"];
}
else if (checkscan == "1")
{
//chkactive.Checked = (bool)dtmember.Rows[0]["is_active"];
chkactivescan.Checked = (bool)dtuserscan.Rows[0]["activescan"];
}
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModaledituser", "$('#myModaledituser').modal();", true);
}
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;
}
}
}
protected void bthcheck_Click(object sender, EventArgs e)
{
//Disable the default item.
DropDownList1.Items[0].Attributes["disabled"] = "disabled";
int Memberdriverid = Convert.ToInt32(ViewState["member_driver_id"].ToString());
DataTable dtdriverid = new DriverDAO().GetDriverByIDMember(Memberdriverid); // เช็คสถานะของคนขับรถ
if (dtdriverid.Rows.Count > 0)
{
//.......... เช็ดคนขับรถว่าสแกนเที่ยวไหนไปแล้ว.........................//
//roundscan = 0 ยังไม่ได้เริ่มสแกน
//roundscan = 1 สแกนเที่ยวบ้าน-โรงเรียน เรียบร้อยแล้ว
//roundscan = 2 สแกนเที่ยวโรงเรียน-บ้าน เรียบร้อยแล้ว
string roundscan = dtdriverid.Rows[0]["roundscan"].ToString();
if (DropDownList1.Items[0].Selected == true)
{
//........... "เลือกการสแกนลายเที่ยวรถรับส่ง และกดปุ่ม 'ตรวจสอบ'//................
}
else
{
if (DropDownList1.SelectedValue == roundscan) // ถ้าคนขับรถได้บันทึกเที่ยว
{
if (roundscan == "1")
{
imgchk.ImageUrl = "~/Images/success.png";
imgchk.Width = 50;
imgchk.Height = 50;
labchk.Text = "สแกนเที่ยวจากบ้าน-โรงเรียน เรียบร้อยแล้ว";
}
if (roundscan == "2")
{
imgchk.ImageUrl = "~/Images/Alert.png";
imgchk.Width = 50;
imgchk.Height = 50;
labchk.Text = "สแกนเที่ยวจากบ้าน-โรงเรียน ก่อน";
}
}
else // สแกนลานนิ้วมือเด็กนักเรียน
{
Timer = true;
//.......... update รอบเที่ยวไป-กลับของรถรับส่งที่คนขับรถเลือกมา...................//
string fullnamedriver = dtdriverid.Rows[0]["fullname"].ToString();
DataTable dt = new UserScanDAO().GetUserScanJoin_tbUserByfullnamedriver(fullnamedriver, true); // เช็คชื่อคนขับรถรับส่งที่จะให้สแกน
//เพิ่มสถานะเที่ยวรถรับส่งที่คนขับรถเลือกเข้ามา
foreach (DataRow row in dt.Rows)
{
int memberuserid = Convert.ToInt32(row["member_id"].ToString());
UserScanDAO UserScan = new UserScanDAO();
UserScan.UpdateUserScanByMember_Roundscan(memberuserid, Convert.ToInt32(DropDownList1.SelectedValue));
}
ViewState["roundscan"] = DropDownList1.SelectedValue;
DropDownList1.Visible = false;
bthcheck.Visible = false;
labround.Visible = false;
labchk.Visible = false;
imgchk.Visible = false;
UpdatePanel_DropDownList2.Update();
Binddatascan(DropDownList1.SelectedItem.Text.Trim());
}
}
}
}
