protected void btCapNhat_Click(object sender, EventArgs e) { KHACH_HANG_DTO kh = new KHACH_HANG_DTO(); /*lấy thông tin từ giao diện*/ kh.UserName= txtUserName.Text; kh.TenDoanhNghiep=txtTenDN.Text; kh.DiaChi=txtDiaChi.Text; kh.SoDienThoai=txtSDT.Text; kh.NguoiDaiDien=txtTenDaiDien.Text; kh.WebSite=txtWebsite.Text; try { int result = UserBUS.CapNhatTaiKhoanKhachHang(kh); if (result == 1) { lbResult.ForeColor = Color.Green; lbResult.Text = "Đã cập nhật thành công"; } else { lbResult.ForeColor = Color.Red; lbResult.Text = "Đã có lỗi , xin vui lòng thử lại sau"; } } catch (Exception ex) { lbResult.ForeColor = Color.Red; lbResult.Text = "Đã có lỗi , xin vui lòng thử lại sau"; } }
public static int InsertConsumer(USERS_DTO user,KHACH_HANG_DTO consumer) { provider.connect(); string sqlCommand = "sp_InsertConsumer"; List<SqlParameter> list = new List<SqlParameter>(); list.Add(new SqlParameter("@username", user.UserName)); list.Add(new SqlParameter("@password",user.PassWord)); list.Add(new SqlParameter("@email",user.EMail)); list.Add(new SqlParameter("@tendn",consumer.TenDoanhNghiep)); list.Add(new SqlParameter("@diachi",consumer.DiaChi)); list.Add(new SqlParameter("@sdt",consumer.SoDienThoai)); list.Add(new SqlParameter("@tendaidien",consumer.NguoiDaiDien)); list.Add(new SqlParameter("@website",consumer.WebSite)); SqlParameter result=new SqlParameter("@result",SqlDbType.Int); result.Direction = ParameterDirection.ReturnValue; list.Add(result); try { provider.executeNonQueryProcedure(sqlCommand, list); } catch (Exception e) { //throw new Exception(e.ToString()); return -1; } finally { provider.disconnect(); } return (int)result.Value; }
public static int CapNhatTaiKhoanKhachHang(KHACH_HANG_DTO kh) { provider.connect(); string sqlCommand = "sp_UpdateTaiKhoanKhachHang"; List<SqlParameter> list = new List<SqlParameter>(); list.Add(new SqlParameter("@username",kh.UserName)); list.Add(new SqlParameter("@tendn",kh.TenDoanhNghiep)); list.Add(new SqlParameter("@diachi",kh.DiaChi)); list.Add(new SqlParameter("@sdt",kh.SoDienThoai)); list.Add(new SqlParameter("@tendaidien",kh.NguoiDaiDien)); list.Add(new SqlParameter("@website",kh.WebSite)); SqlParameter result = new SqlParameter("@result", SqlDbType.Int); result.Direction = ParameterDirection.ReturnValue; list.Add(result); try { provider.executeNonQueryProcedure(sqlCommand, list); return (int)result.Value; } catch (Exception e) { throw e; } finally { provider.disconnect(); } }
public static int CapNhatTaiKhoanKhachHang(KHACH_HANG_DTO kh) { try { return ConsumerDAO.CapNhatTaiKhoanKhachHang(kh); } catch (Exception e) { throw e; } }
public static int InsertConsumer(USERS_DTO user, KHACH_HANG_DTO consumer) { try { user.PassWord = MD5.encryptPassword(user.PassWord); return UserDAO.InsertConsumer(user,consumer); } catch (Exception e) { throw e; } }
protected void btnRegister_Click(object sender, EventArgs e) { /* showMessage("cureenExFilPath" + Request.CurrentExecutionFilePath.ToString()); //GUI/Register.aspx // showMessage("Filepa " + Request.FilePath); // showMessage("path " + Request.Path); //showMessage("pathinf " + Request.PathInfo); hong co // showMessage("physicapp " + Request.PhysicalApplicationPath); // showMessage("phsicpath " + Request.PhysicalPath);//dia chi day du //showMessage("rawurl " + Request.RawUrl);*/ // showMessage("absolutepath " + Request.Url.AbsolutePath);//BUI/Consumer // showMessage("absoluteuri " + Request.Url.AbsoluteUri);// http://localhost:1155/GUI/Consumers/Register.aspx // showMessage("hostname " + Request.UserHostName);//127.1.1 // showMessage(Request.UserHostAddress); captcha.ValidateCaptcha(txtCaptcha.Text); if (captcha.UserValidated) { USERS_DTO user = new USERS_DTO(); KHACH_HANG_DTO consumer = new KHACH_HANG_DTO(); user.UserName = txtusername.Value; user.PassWord = txtPass.Text; user.MaLoaiUser = 3; user.EMail = txtEmail.Text; user.TrangThai = 0; consumer.DiaChi = txtAddress.Text; consumer.TenDoanhNghiep = txtBusinessName.Text; consumer.SoDienThoai = txtPhone.Text; consumer.WebSite = txtWebAdress.Text; consumer.NguoiDaiDien = txtPersonName.Text; try { int result= UserBUS.InsertConsumer(user, consumer); if (result == 1) { string body = "<h4>Hi,"+user.UserName+"</h4><b>Doanh nghiệp bạn đã đăng ký thành công tại beatifulHouseGroup</b><br/>"; body += "<b style='color:red'>Hãy click link bên dưới để hoàn tất việc đăng ký </b><br/>"; string fullpath = Request.Url.AbsoluteUri; int index = fullpath.LastIndexOf("/"); fullpath = fullpath.Remove(index); body += "<a href='" + fullpath + "/Active.aspx?username="******"&id="+MD5.encryptPassword(user.UserName)+"'><b>" + fullpath + "/Active.aspx</b></a>";//chỗ này khi code sẽ kèm tham số là username+ băm gì đó string subject = "Kich hoat tai khoan"; bool test = Email.sendMail(user.EMail, body, subject); lbCaptcha.Visible = false; showMessage(message); } } catch (Exception ex) { //Chưa xử lý } } else { lbCaptcha.Text = "Mã an toàn không đúng !"; lbCaptcha.Visible = true; return; } }
public static KHACH_HANG_DTO XemThongTinTaiKhoan(string username) { provider.connect(); string sqlCommand = "sp_XemThongTinTaiKhoan"; List<SqlParameter> list = new List<SqlParameter>(); list.Add(new SqlParameter("@username", username)); try { KHACH_HANG_DTO kh = new KHACH_HANG_DTO(); DataTable table = provider.executeQueryDataTableProcedure(sqlCommand, list); if (table != null && table.Rows.Count > 0) { DataRow row = table.Rows[0]; kh.UserName = row["USERNAME"].ToString(); kh.TenDoanhNghiep = row["TENDN"].ToString(); kh.DiaChi = row["DIACHI"].ToString(); kh.SoDienThoai = row["SDT"].ToString(); kh.NguoiDaiDien = row["TENNDAIDIEN"].ToString(); kh.WebSite = row["WEBSITE"].ToString(); } return kh; } catch (Exception e) { throw e; } finally { provider.disconnect(); } }