private void UserAddress(int memberid) { // แสดงที่อยู่บ้านของเด็กนักเรียน DataTable dt = new UserAddressDAO().GetUserAddressByMember(memberid); rptMarkers.DataSource = dt; rptMarkers.DataBind(); }
private void BindDataSchoolAddress() { DataSet ds = new UserAddressDAO().GetUserAddress(PagingControl1.CurrentPageIndex, PagingControl1.PageSize, this.SortColumn, this.SortOrder); PagingControl2.RecordCount = (int)ds.Tables[1].Rows[0][0]; gvschooladdress.DataSource = ds.Tables[0]; gvschooladdress.DataBind(); }
private void BindData() { int memberuserid = Int32.Parse(ViewState["member_user_id"].ToString()); DataTable dt = new UserDAO().GetUserByMember(memberuserid); DataTable dtAddress = new UserAddressDAO().GetUserAddressByMember(memberuserid); if (dt.Rows.Count > 0 && dtAddress.Rows.Count > 0) { labaddressfullname.Text = "แก้ไขที่อยู่ปัจจุบัน ( คุณ " + dt.Rows[0]["fullname"].ToString() + " )"; txtcomment.Text = dtAddress.Rows[0]["detailaddress"].ToString(); } }
protected void bthsave_Click(object sender, EventArgs e) { if (address.Text == "" || txtcomment.Text == "" || latitude.Text == "" || longitude.Text == "") { labaddress.Visible = true; labaddress.Text = "กรุณากรอกข้อมูลให้ครบถ้วย"; address.Text = ""; longitude.Text = ""; latitude.Text = ""; } else { if (this.DecryptQueryString("adminid") != null && this.DecryptQueryString("userid") != null) { int memberuserid = Int32.Parse(ViewState["member_user_id"].ToString()); int memberadminid = Int32.Parse(ViewState["member_admin_id"].ToString()); UserAddressDAO UserAddress = new UserAddressDAO(); UserAddress.UpdateUserAddressByMember(memberuserid, latitude.Text.Trim(), longitude.Text.Trim(), address.Text.Trim(), txtcomment.Text.Trim()); Response.Redirect("../Admin/AddUser.aspx" + this.EncryptQueryString("adminid=" + memberadminid)); } else if (this.DecryptQueryString("adminid") != null && this.DecryptQueryString("schoolid") != null) { int schoolid = Int32.Parse(ViewState["member_school_id"].ToString()); int memberadminid = Int32.Parse(ViewState["member_admin_id"].ToString()); SchoolAddressDAO SchoolAddress = new SchoolAddressDAO(); SchoolAddress.UpdateSchoolAddressByID(schoolid, latitude.Text.Trim(), longitude.Text.Trim(), address.Text.Trim(), txtcomment.Text.Trim()); Response.Redirect("../Admin/AddUser.aspx" + this.EncryptQueryString("adminid=" + memberadminid)); } else { Response.Redirect("../Login.aspx"); } } }
protected void bthsave_Click(object sender, EventArgs e) { if (address.Text == "" || txtcomment.Text == "" || latitude.Text == "" || longitude.Text == "") { labaddress.Visible = true; labaddress.Text = "กรุณากรอกข้อมูลให้ครบถ้วย"; address.Text = ""; longitude.Text = ""; latitude.Text = ""; } else { int memberid = Int32.Parse(ViewState["memberUser_id"].ToString()); UserAddressDAO User = new UserAddressDAO(); MemberDAO member = new MemberDAO(); member.UpdateMemberByRegister(memberid, 2); User.AddUserAddress(memberid, latitude.Text.Trim(), longitude.Text.Trim(), address.Text.Trim(), txtcomment.Text.Trim()); Response.Redirect("../User/RegisterFingerPrint.aspx" + this.EncryptQueryString("userid=" + memberid)); } }