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