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()); } } } }