public static bool goiLaiMatKhau(string Email)
{
ToolsDT tools = new ToolsDT();
int temp;
string password = tools.CreateLostPassword(8);
temp = tools.goiLaiMatKhau(Email, tools.EnCrypt(password, "bikha"));
if (temp > 0)
{
using (MailMessage mail = new MailMessage())
{
mail.From = new MailAddress("*****@*****.**");
mail.To.Add("" + Email + "");
mail.Subject = "Mật khẩu mới từ BiKha Mobile";
mail.Body = "<h1>Chào bạn,</h1> \n Mật khẩu mới của bạn là: " + password + "";
mail.IsBodyHtml = true;
using (SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587))
{
smtp.Credentials = new NetworkCredential("*****@*****.**", "nguoidien");
smtp.EnableSsl = true;
smtp.Send(mail);
}
}
return(true);
}
else
{
return(false);
}
}
public static bool xoaSanPham(string idsp, string idmau, string soluong)
{
ToolsDT tools = new ToolsDT();
bool check = false;
if (int.Parse(tools.getSLbyidSP(idmau, idsp).Rows[0]["SoLuongTonKho"].ToString()) >= int.Parse(soluong))
{
Carts cart = (Carts)HttpContext.Current.Session["cart"];
Items item = new Items();
if (cart != null)
{
item.soLuong = int.Parse(soluong);
item.idSP = idsp;
item.idMau = idmau;
cart.capnhatItem(item);
if (cart.vebang().Rows.Count == 0)
{
HttpContext.Current.Session["cart"] = null;
}
check = true;
}
}
else
{
check = false;
}
return(check);
}
public static bool kiemTraDangNhap(string username, string password, string checkremember)
{
bool check = false;
ToolsDT tools = new ToolsDT();
if (HttpContext.Current != null)
{
if (tools.checkLogin(username, tools.EnCrypt(password, "bikha")).Rows.Count > 0)
{
if (checkremember == "true")
{
HttpContext.Current.Response.Cookies["authcoolie"]["UserName"] = username;
HttpContext.Current.Response.Cookies["authcoolie"]["Password"] = password;
HttpContext.Current.Response.Cookies["authcoolie"].Expires = DateTime.Now.AddDays(+30);
}
else
{
HttpContext.Current.Response.Cookies["authcoolie"].Expires = DateTime.Now.AddDays(-1);
}
HttpContext.Current.Session["username"] = username;
check = true;
}
else
{
check = false;
}
}
return(check);
}
public static string getPhanTramGiamGia(string macode, string idsp, string idmau)
{
ToolsDT tools = new ToolsDT();
string phantramgiamgia;
phantramgiamgia = tools.getMaCode(macode, idsp, idmau).Rows[0]["giamGia"].ToString();
return(phantramgiamgia);
}
public static string hinhAnh(string idsp)
{
string urlHinh;
ToolsDT tools = new ToolsDT();
urlHinh = tools.getSanPhamByID(idsp).Rows[0]["urlHinh"].ToString();
return(urlHinh);
}
public static string tenSP(string idsp)
{
string tenSP;
ToolsDT tools = new ToolsDT();
tenSP = tools.getSanPhamByID(idsp).Rows[0]["tenSP"].ToString();
return(tenSP);
}
public static int tinhSoTienGiam(string macode, string tongtien, string idsp, string idmau)
{
int sotiengiagia;
ToolsDT tools = new ToolsDT();
sotiengiagia = ((int.Parse(tongtien) * int.Parse(tools.getMaCode(macode, idsp, idmau).Rows[0]["giamGia"].ToString())) / 100);
return(sotiengiagia);
}
private void loadDDL()
{
ToolsDT tools = new ToolsDT();
ddlMauSP.DataSource = tools.getMauByID(Request.QueryString.Get("Detailspr").ToString());
ddlMauSP.DataTextField = "tenmau";
ddlMauSP.DataValueField = "mamau";
ddlMauSP.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ToolsDT tools = new ToolsDT();
lblTenSanPham.Text = tools.getTenNSX(Request.QueryString.Get("idNSX").ToString()) + " " + tools.getTinhTrangSanPhamByidTT(Request.QueryString.Get("idTT").ToString()).Rows[0]["TinhTrang"].ToString();
}
idsp = int.Parse(Request.QueryString.Get("idNSX").ToString());
tinhtrang = int.Parse(Request.QueryString.Get("idTT").ToString());
}
public static bool khLienHe(string hoten, string email, string tieude, string ykien)
{
ToolsDT tools = new ToolsDT();
SqlCommand cmd = new SqlCommand();
String sDate = DateTime.Now.ToString("dd-MM-yyyy hh:mm");
bool check;
check = tools.lienHe(hoten, email, tieude, ykien, sDate);
return(check);
}
public static bool deleteSPofGH(string idsp, string idmau, string userName)
{
if (HttpContext.Current.Session["username"] != null)
{
userName = HttpContext.Current.Session["username"].ToString();
}
ToolsDT tools = new ToolsDT();
tools.xoaSPofGH(idsp, idmau, userName);
return(true);
}
public static string giaTienSP(string idsp, string idmau)
{
string giaTien = "";
ToolsDT tools = new ToolsDT();
if (tools.getSLbyidSP(idmau, idsp).Rows.Count > 0)
{
giaTien = tools.formatMoney(tools.getSLbyidSP(idmau, idsp).Rows[0]["Gia"].ToString(), ".");
}
return(giaTien);
}
public static string ulli(string tensp)
{
ToolsDT tools = new ToolsDT();
string li = "";
for (int i = 0; i < tools.timKiemSP(tensp).Rows.Count; i++)
{
li = li + "<li><a href='ProductDetails.aspx?Detailspr=" + tools.timKiemSP(tensp).Rows[i]["idSP"].ToString() + "'><img src='" + tools.timKiemSP(tensp).Rows[i]["urlHinh"].ToString() + "' /><h3>" + tools.timKiemSP(tensp).Rows[i]["tenSP"].ToString() + "</h3><span class='price'>" + tools.timKiemSP(tensp).Rows[i]["GiaHienTai"].ToString() + "</span></a></li>";
}
return(li);
}
public static bool checkEmail(string email)
{
ToolsDT tools = new ToolsDT();
if (tools.checkEmail(email).Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool checkUsername(string username)
{
ToolsDT tools = new ToolsDT();
if (tools.checkUsername(username).Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool dangKyThanhVien(string hoten, string username, string password, string diachi, string gioitinh, string dienthoai, string email, string ngaydangky, string tinh, string quan, string huyen)
{
ToolsDT tools = new ToolsDT();
if (tools.dangKyThanhVien(hoten, username, password, diachi, gioitinh, dienthoai, email, ngaydangky, tinh, quan, huyen) > 0)
{
HttpContext.Current.Session["username"] = username;
return(true);
}
else
{
return(false);
}
}
public static bool kiemtraDangNhap(string user, string pass)
{
ToolsDT tools = new ToolsDT();
bool check;
if (tools.kiemTraDangNhap(user, pass).Rows.Count > 0)
{
check = true;
}
else
{
check = false;
}
return(check);
}
public static List <ListItem> getPhuongXa(string districtid)
{
ToolsDT tools = new ToolsDT();
List <ListItem> items = new List <ListItem>();
for (int i = 0; i < tools.getPhuongXa(districtid).Rows.Count; i++)
{
items.Add(new ListItem
{
Value = tools.getPhuongXa(districtid).Rows[i]["wardid"].ToString(),
Text = tools.getPhuongXa(districtid).Rows[i]["name"].ToString()
});
}
return(items);
}
public static List <ListItem> getQuanHuyen(string provinceid)
{
ToolsDT tools = new ToolsDT();
List <ListItem> items = new List <ListItem>();
for (int i = 0; i < tools.getQuanHuyen(provinceid).Rows.Count; i++)
{
items.Add(new ListItem
{
Value = tools.getQuanHuyen(provinceid).Rows[i]["districtid"].ToString(),
Text = tools.getQuanHuyen(provinceid).Rows[i]["name"].ToString()
});
}
return(items);
}
public static List <ListItem> chungLoai()
{
ToolsDT tools = new ToolsDT();
List <ListItem> items = new List <ListItem>();
for (int i = 0; i < tools.getChungLoai().Rows.Count; i++)
{
items.Add(new ListItem
{
Value = tools.getChungLoai().Rows[i]["idCL"].ToString(),
Text = tools.getChungLoai().Rows[i]["TenCL"].ToString()
});
}
return(items);
}
public static List <ListItem> loaiSP(string idCL)
{
ToolsDT tools = new ToolsDT();
List <ListItem> items = new List <ListItem>();
for (int i = 0; i < tools.getLoai(idCL).Rows.Count; i++)
{
items.Add(new ListItem
{
Value = tools.getLoai(idCL).Rows[i]["idLoai"].ToString(),
Text = tools.getLoai(idCL).Rows[i]["TenLoai"].ToString()
});
}
return(items);
}
public static List <ListItem> PTTT()
{
ToolsDT tools = new ToolsDT();
List <ListItem> items = new List <ListItem>();
for (int i = 0; i < tools.getPTTTT().Rows.Count; i++)
{
items.Add(new ListItem
{
Value = tools.getPTTTT().Rows[i]["idPTTT"].ToString(),
Text = tools.getPTTTT().Rows[i]["TenPhuongThucTT"].ToString()
});
}
return(items);
}
public static List <ListItem> mauSP(string idsp)
{
ToolsDT tools = new ToolsDT();
List <ListItem> items = new List <ListItem>();
for (int i = 0; i < tools.getMauByID(idsp).Rows.Count; i++)
{
items.Add(new ListItem
{
Value = tools.getMauByID(idsp).Rows[i]["mamau"].ToString(),
Text = tools.getMauByID(idsp).Rows[i]["tenmau"].ToString()
});
}
return(items);
}
public static bool getMaCode(string macode, string idsp, string idmau)
{
ToolsDT tools = new ToolsDT();
bool check;
if (tools.getMaCode(macode, idsp, idmau).Rows.Count > 0)
{
check = true;
}
else
{
check = false;
}
return(check);
}
public static List <ListItem> getTinhThanhPho()
{
ToolsDT tools = new ToolsDT();
List <ListItem> items = new List <ListItem>();
for (int i = 0; i < tools.getTinhThanhPho().Rows.Count; i++)
{
items.Add(new ListItem
{
Value = tools.getTinhThanhPho().Rows[i]["provinceid"].ToString(),
Text = tools.getTinhThanhPho().Rows[i]["name"].ToString()
});
}
return(items);
}
public static string userName()
{
ToolsDT tools = new ToolsDT();
string tenuser = "";
if (HttpContext.Current.Session["username"] != null)
{
tenuser = tools.layThongTinUser(HttpContext.Current.Session["username"].ToString()).Rows[0]["UserName"].ToString();
}
else
{
tenuser = "";
}
return(tenuser);
}
public static string passWord()
{
ToolsDT tools = new ToolsDT();
string password = "";
if (HttpContext.Current.Session["username"] != null)
{
password = tools.layThongTinUser(HttpContext.Current.Session["username"].ToString()).Rows[0]["Password"].ToString();
}
else
{
password = "";
}
return(password);
}
public static string diaChiGiaoHang()
{
ToolsDT tools = new ToolsDT();
string diaChiGiaoHang = "";
if (HttpContext.Current.Session["username"] != null)
{
diaChiGiaoHang = tools.layThongTinUser(HttpContext.Current.Session["username"].ToString()).Rows[0]["DiaChiGiaoHang"].ToString();
}
else
{
diaChiGiaoHang = "";
}
return(diaChiGiaoHang);
}
public static string email()
{
ToolsDT tools = new ToolsDT();
string email = "";
if (HttpContext.Current.Session["username"] != null)
{
email = tools.layThongTinUser(HttpContext.Current.Session["username"].ToString()).Rows[0]["Email"].ToString();
}
else
{
email = "";
}
return(email);
}
public static string SoDienThoai()
{
ToolsDT tools = new ToolsDT();
string SoDienThoai = "";
if (HttpContext.Current.Session["username"] != null)
{
SoDienThoai = tools.layThongTinUser(HttpContext.Current.Session["username"].ToString()).Rows[0]["DienThoai"].ToString();
}
else
{
SoDienThoai = "";
}
return(SoDienThoai);
}
