public void bind_SanPham()
{
List <Entity.KhuyenMai> km = new List <Entity.KhuyenMai>();
km = KhuyenMaiService.KhuyenMai_GetByTop("", "", "");
List <Entity.SanPham> lst = new List <Entity.SanPham>();
List <Entity.SanPham> quandai = new List <Entity.SanPham>();
List <Entity.SanPham> quanshorts = new List <Entity.SanPham>();
List <Entity.SanPham> tonkho = new List <Entity.SanPham>();
lst = SanPhamService.SanPham_GetByTop("", " Active='True' AND id_Menu=2", " ID ASC");
dtlaokhoac.DataSource = lst;
dtlaokhoac.DataBind();
lst = SanPhamService.SanPham_GetByTop("", " Active='True' AND id_Menu=1", " ID ASC");
dtlvaydamvasetbo.DataSource = lst;
dtlvaydamvasetbo.DataBind();
lst = SanPhamService.SanPham_GetByTop("", " Active='True' AND id_Menu=3", " ID ASC");
dtldamkhuyenmai.DataSource = lst;
dtldamkhuyenmai.DataBind();
quandai = SanPhamService.SanPham_GetByTop("", " Active='True' AND id_Menu=4", " ID ASC");
dtlquandai.DataSource = quandai;
dtlquandai.DataBind();
quanshorts = SanPhamService.SanPham_GetByTop("", " Active='True' AND id_Menu=5 ", " ID ASC");
dtlquanshorts.DataSource = quanshorts;
dtlquanshorts.DataBind();
tonkho = SanPhamService.SanPham_GetByTop("", " Active='True' AND id_Menu=6", " ID ASC");
dtltonkho.DataSource = tonkho;
dtltonkho.DataBind();
}
public PartialViewResult _LoadDanhSachTheoSanPham(int?SanPhamId)
{
SanPhamService service = new SanPhamService();
ViewBag._LoadDanhSachSanPham = new SelectList(service.DSSanPham(), "SanPhamId", "TenSanPham", SanPhamId);
return(PartialView());
}
public ActionResult Form(int?Id)
{
HTMDb db = new HTMDb();
var YeuCauNguoiDung = db.YeuCauNguoiDungs.Where(x => x.DaPheDuyet == false && x.TrangThai == false).Count();
var YeuCauNguoiDungLenQuanTri = db.YeuCauNguoiDungs.Where(x => x.DaPheDuyet == false && x.TrangThai == true).Count();
var YeuCauDuyetLenPhongBan = db.YeuCauNguoiDungs.Where(x => x.DaPheDuyet == false && x.TrangThai == false).Count();
var SanPhamChoNhapKho = db.SanPhams.Where(x => x.DaXoa == false && x.DaNhapKho == true && x.DaPheDuyet == false && x.SoLuong >= 0).Count();
var SanPhamHetHang = db.SanPhams.Where(x => x.DaXoa == false && x.DaNhapKho == true && x.SoLuong <= 0).Count();
var YeuCauDaDuyet = db.YeuCauNguoiDungs.Where(x => x.DaPheDuyet == true && x.TrangThai == true).Count();
ViewBag.YeuCauNguoiDung = YeuCauNguoiDung.ToString();
ViewBag.YeuCauNguoiDungLenQuanTri = YeuCauNguoiDungLenQuanTri.ToString();
ViewBag.YeuCauDuyetLenPhongBan = YeuCauDuyetLenPhongBan.ToString();
ViewBag.SanPhamChoNhapKho = SanPhamChoNhapKho.ToString();
ViewBag.SanPhamHetHang = SanPhamHetHang.ToString();
ViewBag.YeuCauDaDuyet = YeuCauDaDuyet.ToString();
var sp = new Models.SanPham();
if (Id.HasValue && Id != null)
{
var sanPham = new SanPhamService();
sp = sanPham.FindByKeys(Id);
}
return(View(sp));
}
protected void Page_Load(object sender, EventArgs e)
{
List <Entity.SanPham> lst = new List <Entity.SanPham>();
string ID_Menu = Request.QueryString["IDMenu"];
if (String.Compare(ID_Menu, "1") == 0)
{
lst = SanPhamService.SanPham_GetByTop("", " id_Menu=1", "");
lblsanpham.Text = "ĐẦM LIỀN";
}
else if (String.Compare(ID_Menu, "2") == 0)
{
lst = SanPhamService.SanPham_GetByTop("", " id_Menu=2", "");
lblsanpham.Text = "ÁO KHOÁC ";
}
else if (String.Compare(ID_Menu, "3") == 0)
{
lst = SanPhamService.SanPham_GetByTop("", " id_Menu=3", "");
lblsanpham.Text = "ĐẦM KHUYẾN MÃI";
}
else
{
lst = SanPhamService.SanPham_GetByTop("", "", "");
lblsanpham.Text = "SẢN PHẨM";
}
dtlsanpham.DataSource = lst;
dtlsanpham.DataBind();
}
protected void btnEdit_Top_Command(object sender, CommandEventArgs e)
{
int i = 0;
string id;
foreach (GridViewRow gvrow in grvHang.Rows)
{
CheckBox chk = (CheckBox)gvrow.FindControl("CkDelete");
if (chk != null && chk.Checked)
{
id = grvHang.Rows[i].Cells[1].Text;
List <Entity.SanPham> lst = new List <Entity.SanPham>();
lst = SanPhamService.SanPham_GetByTop("", " id = " + id, "");
pnInfo.Visible = true;
pnData.Visible = false;
insert = false;
fileUpLoad_nho = lst[0].Image;
fileUpLoad_lon = lst[0].ImageLarge;
txtID.Text = lst[0].Id;
txttenhang.Text = lst[0].TenHang;
ddltennhomhang.SelectedValue = lst[0].Id_Menu;
txtchatlieu.Text = lst[0].ChatLieu;
txtgiamoi.Text = lst[0].GiaMoi;
txtgiacu.Text = lst[0].GiaCu;
txtsoluong.Text = lst[0].Soluong;
txttomtat.Text = lst[0].TomTat;
txtNoidung.Text = lst[0].Mota;
ckbActive.Checked = lst[0].Active == "True" ? true : false;
}
i++;
}
}
protected void lbDelete_Command(object sender, CommandEventArgs e)
{
int i = Int32.Parse(e.CommandArgument.ToString());
List <Entity.SanPham> lst = new List <Entity.SanPham>();
SanPhamService.SanPham_Delete(i.ToString());
getData();
}
protected void Page_Load(object sender, EventArgs e)
{
string TenspSearch = Request.QueryString["TenSanPham"];
List <Entity.SanPham> lst = new List <Entity.SanPham>();
lst = SanPhamService.SanPham_GetByTop("", " [dbo].[fuChuyenCoDauThanhKhongDau](TenHang) like N'%' +dbo.fuChuyenCoDauThanhKhongDau('" + TenspSearch + "')+'%' AND Active='True'", "");
dtltimkiem.DataSource = lst;
dtltimkiem.DataBind();
}
public PartialViewResult _PheDuyetYeuCau(int?Id)
{
var sp = new Models.SanPham();
if (Id.HasValue && Id != null)
{
var _sp = new SanPhamService();
sp = _sp.FindByKeys(Id);
}
return(PartialView(sp));
}
public PartialViewResult _SanPhamChiTiet(int?Id)
{
var sp = new Models.SanPham();
if (Id.HasValue && Id != null)
{
var sanPham = new SanPhamService();
sp = sanPham.FindByKeys(Id);
}
return(PartialView(sp));
}
public ActionResult Form(int?Id
, string TenSanPham
, string MaSanPham
, string TieuDe
, string MoTa
, double?Gia
, int?SoLuong
, int?TheLoadId
, string ChiTiet
, string[] thumbnails
)
{
var session = (UserLogin)Session[CommonConstants.USER_SESSION];
SanPhamService _sp = new SanPhamService();
Models.SanPham sp = _sp.FindByKeys(Id);
sp.TenSanPham = TenSanPham;
sp.MaSanPham = MaSanPham;
sp.TieuDe = TieuDe;
sp.MaSanPham = MoTa;
sp.Gia = Gia;
sp.NguoiTao = session.Name;
sp.SoLuong = SoLuong;
sp.TheLoaiId = TheLoadId;
sp.ChiTiet = ChiTiet;
sp.DaPheDuyet = true;
sp.TrangThai = false;
sp.DaNhapKho = false;
sp.DaXoa = false;
if (Id.HasValue)
{
if (thumbnails != null && thumbnails.Length > 0)
{
sp.Anh = string.Join(";", thumbnails);
}
sp.NguoiSua = session.Name;
sp.NgaySua = DateTime.Now;
_sp.Update(sp);
setAlert("Thông tin sản phẩm đã được cập nhập", "success");
}
else
{
if (thumbnails != null && thumbnails.Length > 0)
{
sp.Anh = string.Join(";", thumbnails);
}
sp.NgayTao = DateTime.Now;
_sp.Insert(sp);
setAlert("Thêm sản phẩm thành công", "success");
}
return(RedirectToAction("Index"));
}
void getData()
{
List <Entity.SanPham> lst = new List <Entity.SanPham>();
lst = SanPhamService.SanPham_GetByTop("", "", "");
for (int i = 0; i < lst.Count; i++)
{
lst[i].Image = "~/" + lst[i].Image;
}
grvHang.DataSource = lst;
grvHang.DataBind();
}
public PartialViewResult _LoadDanhSanPhamDaXoa(string MaSanPham, string TenSanPham, int?PageCurrent)
{
SanPhamService service = new SanPhamService();
int pageNumber = PageCurrent ?? 1;
IPagedList <Models.SanPham> sp = service.GetListSanPhamDaXoa(MaSanPham
, TenSanPham
, pageNumber
, 10
);
ViewBag.MaSanPham = MaSanPham;
ViewBag.TenSanPham = TenSanPham;
ViewBag.PageCurrent = PageCurrent;
return(PartialView(sp));
}
public JsonResult ChangeStatus(int?id)
{
if (id.HasValue)
{
SanPhamService service = new SanPhamService();
var sp = service.FindByKey(id.Value);
if (sp != null)
{
sp.TrangThai = sp.TrangThai.HasValue ? !sp.TrangThai : true;
service.Update(sp);
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { status = false, message = "Sinh viên không khả dung" }));
}
public JsonResult PheDuyetYeuCau(int?id)
{
if (id.HasValue)
{
SanPhamService service = new SanPhamService();
var sp = service.FindByKey(id.Value);
if (sp != null)
{
sp.DaPheDuyet = sp.DaPheDuyet.HasValue ? !sp.DaPheDuyet : true;
service.Update(sp);
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { status = false, message = "Sản phẩm không khả dụng" }));
}
public PartialViewResult LoadDanhSanPham(string MaSanPham, string TenSanPham, int?PageCurrent, int?TheLoaiId)
{
SanPhamService service = new SanPhamService();
int pageNumber = PageCurrent ?? 1;
IPagedList <Models.SanPham> sp = service.GetListSanPham(MaSanPham
, TenSanPham
, pageNumber
, 10
, TheLoaiId
);
ViewBag.MaSanPham = MaSanPham;
ViewBag.TenSanPham = TenSanPham;
ViewBag.PageCurrent = PageCurrent;
return(PartialView("_DanhSachSanPham", sp));
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int i = 0;
string id;
foreach (GridViewRow gvrow in grvHang.Rows)
{
CheckBox chk = (CheckBox)gvrow.FindControl("CkDelete");
if (chk != null && chk.Checked)
{
id = grvHang.Rows[i].Cells[1].Text;
SanPhamService.SanPham_Delete(id);
}
i++;
}
getData();
}
public void bind_SanPham()
{
List <Entity.KhuyenMai> km = new List <Entity.KhuyenMai>();
km = KhuyenMaiService.KhuyenMai_GetByTop("", "", "");
List <Entity.SanPham> lst = new List <Entity.SanPham>();
lst = SanPhamService.SanPham_GetByTop("", " Active='True' AND id_Menu=2 AND TinhTrang=N'Còn'", " ID ASC");
dtlaokhoac.DataSource = lst;
dtlaokhoac.DataBind();
lst = SanPhamService.SanPham_GetByTop("", " Active='True' AND id_Menu=1 AND TinhTrang=N'Còn' ", " ID ASC");
dtlvaydamvasetbo.DataSource = lst;
dtlvaydamvasetbo.DataBind();
lst = SanPhamService.SanPham_GetByTop("", " Active='True' AND id_Menu=3 AND TinhTrang=N'Còn' ", " ID ASC");
dtldamkhuyenmai.DataSource = lst;
dtldamkhuyenmai.DataBind();
}
public JsonResult Delete(int?id)
{
var session = (UserLogin)Session[CommonConstants.USER_SESSION];
if (id.HasValue)
{
SanPhamService service = new SanPhamService();
var sp = service.FindByKey(id.Value);
if (sp != null)
{
sp.NguoiXoa = session.Name;
sp.DaXoa = sp.DaXoa.HasValue ? !sp.DaXoa : true;
sp.NgayXoa = DateTime.Now;
service.Update(sp);
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { status = false, message = "Sinh viên không khả dung" }));
}
public ActionResult DanhSachSanPhamDaXoa(string MaSanPham, string TenSanPham, int?PageCurrent)
{
var SanPhamChoDuyet = db.SanPhams.Where(x => x.TrangThai == true && x.DaPheDuyet == false && x.DaXoa == false).Count();
var SanPhamChoDuyetTrongKho = db.SanPhams.Where(x => x.TrangThai == true && x.DaPheDuyet == false && x.DaXoa == false).Count();
ViewBag.SanPhamChoDuyet = SanPhamChoDuyet.ToString();
ViewBag.SanPhamChoDuyetTrongKho = SanPhamChoDuyetTrongKho.ToString();
SanPhamService service = new SanPhamService();
int pageNumber = PageCurrent ?? 1;
IPagedList <Models.SanPham> sp = service.GetListSanPhamDaXoa(MaSanPham
, TenSanPham
, pageNumber
, 10
);
ViewBag.MaSanPham = MaSanPham;
ViewBag.TenSanPham = MaSanPham;
ViewBag.PageCurrent = PageCurrent;
return(View(sp));
}
protected void Page_Load(object sender, EventArgs e)
{
remenu.DataSource = NhomHangService.NhomHang_GetByTop("", " Active='True'", "");
remenu.DataBind();
List <Entity.SanPham> lst = new List <Entity.SanPham>();
string ID_Menu = Request.QueryString["IDMenu"];
if (String.Compare(ID_Menu, "1") == 0)
{
lst = SanPhamService.SanPham_GetByTop("", " id_Menu=1", "");
lblsanpham.Text = "ÁO KHOÁC";
}
else if (String.Compare(ID_Menu, "2") == 0)
{
lst = SanPhamService.SanPham_GetByTop("", " id_Menu=2", "");
lblsanpham.Text = "ÁO SƠ MI";
}
else if (String.Compare(ID_Menu, "3") == 0)
{
lst = SanPhamService.SanPham_GetByTop("", " id_Menu=3", "");
lblsanpham.Text = "QUẦN JEANS";
}
else if (String.Compare(ID_Menu, "4") == 0)
{
lst = SanPhamService.SanPham_GetByTop("", " id_Menu=4", "");
lblsanpham.Text = "QUẦN DÀI";
}
else if (String.Compare(ID_Menu, "5") == 0)
{
lst = SanPhamService.SanPham_GetByTop("", " id_Menu=5", "");
lblsanpham.Text = "QUẦN SHORTS";
}
dtlsanpham.DataSource = lst;
dtlsanpham.DataBind();
}
protected void lbEdit_Command(object sender, CommandEventArgs e)
{
int i = Int32.Parse(e.CommandArgument.ToString());
List <Entity.SanPham> lst = new List <Entity.SanPham>();
lst = SanPhamService.SanPham_GetByTop("", " ID = " + i, "");
pnInfo.Visible = true;
pnData.Visible = false;
insert = false;
fileUpLoad_nho = lst[0].Image;
fileUpLoad_lon = lst[0].ImageLarge;
txtID.Text = lst[0].Id;
txttenhang.Text = lst[0].TenHang;
ddltennhomhang.SelectedValue = lst[0].Id_Menu;
txtchatlieu.Text = lst[0].ChatLieu;
txtgiamoi.Text = lst[0].GiaMoi;
txtgiacu.Text = lst[0].GiaCu;
txtsoluong.Text = lst[0].Soluong;
txttomtat.Text = lst[0].TomTat;
txtNoidung.Text = lst[0].Mota;
ckbActive.Checked = lst[0].Active == "True" ? true : false;
}
public TestController(SanPhamService sanPhamService, LoaiSanPhamService LSPService)
{
this.sanPhamService = sanPhamService;
this.LSPService = LSPService;
}
public CartController(SanPhamService SPService)
{
this.SPService = SPService;
}
public HoaDonController(HoaDonService HDservice, ChiTietHDService CTHDservice, SanPhamService SPService)
{
this.HDservice = HDservice;
this.CTHDservice = CTHDservice;
this.SPService = SPService;
}
protected void btndathang_Click(object sender, EventArgs e)
{
List <Entity.KhachHang> lstKh = new List <Entity.KhachHang>();
Entity.DatHang dh = new Entity.DatHang();
List <Entity.DatHang> lstdh = new List <Entity.DatHang>();
Entity.ChiTietDatHang lstctdh = new Entity.ChiTietDatHang();
string Id_SP;
if (txtdiachi.Text == "" || txtdienthoai.Text == "" || txtemail.Text == "" || txthovaten.Text == "") //|| ddlquan.SelectedIndex == 0 || ddlthanhpho.SelectedIndex == 0
{
Response.Write("<script>alert('" + ddlquan.SelectedValue + "')</script>");
Response.Write("<script>alert('Bạn phải nhập đầy đủ thông tin!!1')</script>");
return;
}
else
{
if (Session["TenDangNhap"] == null)
{
Entity.KhachHang obj = new Entity.KhachHang();
//Response.Write("<script>alert('Vào đây')</script>");
obj.TenKH = txthovaten.Text;
obj.TaiKhoan = "";
obj.MatKhau = "";
obj.NgaySinh = "";
obj.GioiTinh = "True";
obj.Email = txtemail.Text;
obj.SDT = txtdienthoai.Text;
obj.DiaChi = txtdiachi.Text;
obj.Tinh = ddlthanhpho.SelectedItem.ToString();
obj.Quan = ddlquan.SelectedItem.ToString();
obj.Link_Fb = "false";
KhachHangService.KhachHang_Insert(obj);
lstKh = KhachHangService.KhachHang_GetByTop("", " id=(SELECT MAX(id) from tbl_KhachHang) ", "");
tbl_DatHang dhs = new tbl_DatHang();
dhs.id_KhachHang = int.Parse(lstKh[0].Id);
dhs.NgaylapHD = DateTime.Now;
dhs.IdPay = int.Parse(ddlhinhthucthanhtoan.SelectedValue);
///////////////////////////////////////////////////////////////////
dbs.tbl_DatHangs.InsertOnSubmit(dhs);
dbs.SubmitChanges();
lstdh = DatHangService.DatHang_GetByTop("", " id=(SELECT MAX(id) from tbl_DatHang)", "");
lstctdh.Id_hoadon = lstdh[0].Id;
for (int i = 0; i < tbGioHang.Rows.Count; i++)
{
string tenSP = tbGioHang.Rows[i]["TenSP"].ToString();
Id_SP = SanPhamService.SanPham_GetByTop("", " TenHang=N'" + tenSP + "'", "")[0].Id;
lstctdh.Id_hang = Id_SP;
lstctdh.Size = tbGioHang.Rows[i]["Size"].ToString();
lstctdh.SoLuongMua = tbGioHang.Rows[i]["SoLuong"].ToString();
lstctdh.ThanhTien = tbGioHang.Rows[i]["TongGia"].ToString();
lstctdh.Gia = tbGioHang.Rows[i]["Gia"].ToString();
ChiTietDatHangService.ChiTietDatHang_Insert(lstctdh);
}
}
else
{
string TenDangNhap = Session["TenDangNhap"].ToString();
lstKh = KhachHangService.KhachHang_GetByTop("", " TaiKhoan='" + TenDangNhap + "'", "");
Entity.KhachHang kh = new Entity.KhachHang();
kh.Id = lstKh[0].Id;
kh.TenKH = txthovaten.Text;
kh.Email = txtemail.Text;
kh.DiaChi = txtdiachi.Text;
kh.SDT = txtdienthoai.Text;
kh.Tinh = ddlthanhpho.SelectedItem.ToString();
kh.Quan = ddlquan.SelectedItem.ToString();
KhachHangService.KhachHang_UpdateDatHang(kh);
tbl_DatHang dhs = new tbl_DatHang();
dhs.id_KhachHang = int.Parse(kh.Id);
dhs.NgaylapHD = DateTime.Now;
dhs.IdPay = int.Parse(ddlhinhthucthanhtoan.SelectedValue);
///////////////////////////////////////////////////////////////////
dbs.tbl_DatHangs.InsertOnSubmit(dhs);
dbs.SubmitChanges();
lstdh = DatHangService.DatHang_GetByTop("", " id=(SELECT MAX(id) from tbl_DatHang where id_KhachHang=" + kh.Id + ")", "");
lstctdh.Id_hoadon = lstdh[0].Id;
for (int i = 0; i < tbGioHang.Rows.Count; i++)
{
string tenSP = tbGioHang.Rows[i]["TenSP"].ToString();
Id_SP = SanPhamService.SanPham_GetByTop("", " TenHang=N'" + tenSP + "'", "")[0].Id;
lstctdh.Id_hang = Id_SP;
lstctdh.Size = tbGioHang.Rows[i]["Size"].ToString();
lstctdh.SoLuongMua = tbGioHang.Rows[i]["SoLuong"].ToString();
lstctdh.ThanhTien = tbGioHang.Rows[i]["TongGia"].ToString();
lstctdh.Gia = tbGioHang.Rows[i]["Gia"].ToString();
ChiTietDatHangService.ChiTietDatHang_Insert(lstctdh);
}
}
}
Response.Write("<script>alert('Đặt hàng thành công!! Cảm ơn bạn nhiều nhé!! ')</script>");
// MailMessage message = new MailMessage("*****@*****.**",txtemail.Text, "Shop Fashion(Clothing Store) ",grvsanpham.Rows[0].Cells[0].Text);
// message.IsBodyHtml = true;
// SmtpClient client = new SmtpClient("smtp.gmail.com", 587);
//client.EnableSsl = true;
//client.UseDefaultCredentials = false;
//client.DeliveryMethod = SmtpDeliveryMethod.Network;
//client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Baonguyen741999@!");
//client.Send(message);
for (int i = 0; i < tbGioHang.Rows.Count; i++)
{
var from = "*****@*****.**";
var to = txtemail.Text;
const string Password = "******";
string mail_subject = "Clothing Store";
string mail_message = "From : Clothing Store" + "\n";
mail_message += "From : [email protected] " + "\n";
mail_message += "Thông tin mua hàng của quý khách" + "\n";
string tenSP = tbGioHang.Rows[i]["TenSP"].ToString();
Id_SP = SanPhamService.SanPham_GetByTop("", " TenHang=N'" + tenSP + "'", "")[0].Id;
mail_message += "ID sản phẩm : " + Id_SP + "\n";
mail_message += "Tên sản phẩm :" + tbGioHang.Rows[i]["TenSP"].ToString() + "\n";
mail_message += "Size: " + tbGioHang.Rows[i]["Size"].ToString() + "\n";
mail_message += "Số lượng: " + tbGioHang.Rows[i]["SoLuong"].ToString() + "\n";
mail_message += "Tổng giá: " + tbGioHang.Rows[i]["TongGia"].ToString() + "\n";
mail_message += "Giá: " + tbGioHang.Rows[i]["Gia"].ToString() + "\n";
var smtp = new SmtpClient();
{
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.EnableSsl = true;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.Credentials = new NetworkCredential(from, Password);
smtp.Timeout = 10000;
}
smtp.Send(from, to, mail_subject, mail_message);
}
Session["GioHang"] = null;
Session["slspgiohang"] = null;
lblsl = (Label)Master.FindControl("lblslgiohang");
lblsl.Text = "0";
lbltongtien.Text = "0 VNĐ";
tbGioHang = null;
grvsanpham.DataSource = tbGioHang;
grvsanpham.DataBind();
Response.AddHeader("REFRESH", "1;URL=TrangChu.aspx");
}
protected void btndathang_Click(object sender, EventArgs e)
{
List <Entity.KhachHang> lstKh = new List <Entity.KhachHang>();
Entity.DatHang dh = new Entity.DatHang();
List <Entity.DatHang> lstdh = new List <Entity.DatHang>();
Entity.ChiTietDatHang lstctdh = new Entity.ChiTietDatHang();
string Id_SP;
if (txtdiachi.Text == "" || txtdienthoai.Text == "" || txtemail.Text == "" || txthovaten.Text == "" || ddlquan.SelectedIndex == 0 || ddlthanhpho.SelectedIndex == 0)
{
Response.Write("<script>alert('Bạn phải nhập đầy đủ thông tin!!1')</script>");
return;
}
else if (Session["Link_Fb"] == null)
{
if (Session["TenDangNhap"] == null)
{
Entity.KhachHang obj = new Entity.KhachHang();
obj.TenKH = txthovaten.Text;
obj.TaiKhoan = "";
obj.MatKhau = "";
obj.NgaySinh = "";
obj.GioiTinh = "True";
obj.Email = txtemail.Text;
obj.SDT = txtdienthoai.Text;
obj.DiaChi = txtdiachi.Text;
obj.Tinh = ddlthanhpho.SelectedItem.ToString();
obj.Quan = ddlquan.SelectedItem.ToString();
obj.Link_Fb = "false";
KhachHangService.KhachHang_Insert(obj);
lstKh = KhachHangService.KhachHang_GetByTop("", " id=(SELECT MAX(id) from tbl_KhachHang) ", "");
dh.Id_KhachHang = lstKh[0].Id;
dh.NgaylapHD = DateTime.Now.ToString();
dh.IdPay = ddlhinhthucthanhtoan.SelectedValue.ToString();
DatHangService.DatHang_Insert(dh);
lstdh = DatHangService.DatHang_GetByTop("", " id=(SELECT MAX(id) from tbl_DatHang)", "");
lstctdh.Id_hoadon = lstdh[0].Id;
for (int i = 0; i < tbGioHang.Rows.Count; i++)
{
string tenSP = tbGioHang.Rows[i]["TenSP"].ToString();
Id_SP = SanPhamService.SanPham_GetByTop("", " TenHang=N'" + tenSP + "'", "")[0].Id;
lstctdh.Id_hang = Id_SP;
lstctdh.Size = tbGioHang.Rows[i]["Size"].ToString();
lstctdh.SoLuongMua = tbGioHang.Rows[i]["SoLuong"].ToString();
lstctdh.ThanhTien = tbGioHang.Rows[i]["TongGia"].ToString();
lstctdh.Gia = tbGioHang.Rows[i]["Gia"].ToString();
ChiTietDatHangService.ChiTietDatHang_Insert(lstctdh);
}
}
else
{
string TenDangNhap = Session["TenDangNhap"].ToString();
lstKh = KhachHangService.KhachHang_GetByTop("", " TaiKhoan='" + TenDangNhap + "'", "");
Entity.KhachHang kh = new Entity.KhachHang();
kh.Id = lstKh[0].Id;
kh.TenKH = txthovaten.Text;
kh.Email = txtemail.Text;
kh.DiaChi = txtdiachi.Text;
kh.SDT = txtdienthoai.Text;
kh.Tinh = ddlthanhpho.SelectedItem.ToString();
kh.Quan = ddlquan.SelectedItem.ToString();
KhachHangService.KhachHang_UpdateDatHang(kh);
dh.NgaylapHD = DateTime.Now.ToString();
dh.IdPay = ddlhinhthucthanhtoan.SelectedValue.ToString();
dh.Id_KhachHang = kh.Id;
DatHangService.DatHang_Insert(dh);
lstdh = DatHangService.DatHang_GetByTop("", " id=(SELECT MAX(id) from tbl_DatHang where id_KhachHang=" + kh.Id + ")", "");
lstctdh.Id_hoadon = lstdh[0].Id;
for (int i = 0; i < tbGioHang.Rows.Count; i++)
{
string tenSP = tbGioHang.Rows[i]["TenSP"].ToString();
Id_SP = SanPhamService.SanPham_GetByTop("", " TenHang=N'" + tenSP + "'", "")[0].Id;
lstctdh.Id_hang = Id_SP;
lstctdh.Size = tbGioHang.Rows[i]["Size"].ToString();
lstctdh.SoLuongMua = tbGioHang.Rows[i]["SoLuong"].ToString();
lstctdh.ThanhTien = tbGioHang.Rows[i]["TongGia"].ToString();
lstctdh.Gia = tbGioHang.Rows[i]["Gia"].ToString();
ChiTietDatHangService.ChiTietDatHang_Insert(lstctdh);
}
}
}
else
{
string Link_Fb = Session["Link_Fb"].ToString();
lstKh = KhachHangService.KhachHang_GetByTop("", " Link_Fb='" + Link_Fb + "' ", "");
Entity.KhachHang kh = new Entity.KhachHang();
kh.Id = lstKh[0].Id;
kh.TenKH = txthovaten.Text;
kh.Email = txtemail.Text;
kh.DiaChi = txtdiachi.Text;
kh.SDT = txtdienthoai.Text;
kh.Tinh = ddlthanhpho.SelectedItem.ToString();
kh.Quan = ddlquan.SelectedItem.ToString();
KhachHangService.KhachHang_UpdateDatHang(kh);
dh.NgaylapHD = DateTime.Now.ToString();
dh.IdPay = ddlhinhthucthanhtoan.SelectedValue.ToString();
dh.Id_KhachHang = kh.Id;
DatHangService.DatHang_Insert(dh);
lstdh = DatHangService.DatHang_GetByTop("", " id=(SELECT MAX(id) from tbl_DatHang where id_KhachHang=" + kh.Id + ")", "");
lstctdh.Id_hoadon = lstdh[0].Id;
for (int i = 0; i < tbGioHang.Rows.Count; i++)
{
string tenSP = tbGioHang.Rows[i]["TenSP"].ToString();
Id_SP = SanPhamService.SanPham_GetByTop("", " TenHang=N'" + tenSP + "'", "")[0].Id;
lstctdh.Id_hang = Id_SP;
lstctdh.Size = tbGioHang.Rows[i]["Size"].ToString();
lstctdh.SoLuongMua = tbGioHang.Rows[i]["SoLuong"].ToString();
lstctdh.ThanhTien = tbGioHang.Rows[i]["TongGia"].ToString();
lstctdh.Gia = tbGioHang.Rows[i]["Gia"].ToString();
ChiTietDatHangService.ChiTietDatHang_Insert(lstctdh);
}
}
Response.Write("<script>alert('Đặt hàng thành công!!')</script>");
Session["GioHang"] = null;
lblsl = (Label)Master.FindControl("lblslgiohang");
lblsl.Text = "0";
lbltongtien.Text = "0 VNĐ";
tbGioHang = null;
grvsanpham.DataSource = tbGioHang;
grvsanpham.DataBind();
}
public SanPhamController(IWebHostEnvironment _env, SanPhamService sanPhamService, LoaiSanPhamService LSPService)
{
this._env = _env;
this.sanPhamService = sanPhamService;
this.LSPService = LSPService;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//Khoi tao gio hang
if (Session["GioHang"] != null)
{
tbGioHang = Session["GioHang"] as DataTable;
}
else
{
tbGioHang.Rows.Clear();
tbGioHang.Columns.Clear();
tbGioHang.Columns.Add("TenSP", typeof(string));
tbGioHang.Columns.Add("Size", typeof(string));
tbGioHang.Columns.Add("UrlImage", typeof(string));
tbGioHang.Columns.Add("Gia", typeof(double));
tbGioHang.Columns.Add("SoLuong", typeof(int));
tbGioHang.Columns.Add("TongGia", typeof(double), "SoLuong*Gia");
Session["GioHang"] = tbGioHang;
}
string Id = Request.QueryString["Id"];
SanPhamService.SanPhamView_Update(Id);
lst = SanPhamService.SanPham_GetByTop("", " id=N'" + Id + "'", "");
rptlarge.DataSource = lst;
rptlarge.DataBind();
imganhsp.ImageUrl = lst[0].Image;
string s;
s = "<div>";
s += "<h1>" + lst[0].TenHang + "</h1>";
s += "<p>";
s += " <strong style='font-weight:bold;'> Giá bán:</strong>";
s += "</p>";
s += "<div class='giamoi'>";
s += " <span>" + string.Format("{0:#,0.#}", float.Parse(lst[0].GiaMoi)) + "</span>";
s += "</div>";
s += " <div class='giacu'>";
s += " <span >Giá cũ:";
s += " <span style='color:#F00;text-decoration:line-through;font-size:16px; font-weight:normal;'> " + string.Format("{0:#,0.#}", float.Parse(lst[0].GiaCu)) + "</span>";
s += "</span>";
s += "</div>";
s += "<div>";
s += "<span>Chất liệu:";
s += "<span style='font-weight:normal;'>" + lst[0].ChatLieu + "</span>";
s += " </span>";
s += " </div>";
s += "<div>";
s += "<span>";
s += "<span style='font-weight:normal;'>" + lst[0].TomTat + "</span>";
s += "</div>";
s += "</div>";
ltrctsp.Text = s;
frmviewChitiet.DataSource = lst;
frmviewChitiet.DataBind();
lblluotxem.Text = lst[0].LuotXem;
ltr_ChiTiet.Text = lst[0].Mota;
List <Entity.SanPham> lst_CungLoai = new List <Entity.SanPham>();
lst_CungLoai = SanPhamService.SanPham_GetByTop("", "id_Menu=" + lst[0].Id_Menu + " and Active='True' and id !=" + lst[0].Id + "", "");
rptSanPhamCungloai.DataSource = lst_CungLoai;
rptSanPhamCungloai.DataBind();
}
}
protected void btnSave_Top_Click(object sender, EventArgs e)
{
Entity.SanPham dts = new Entity.SanPham();
tbl_Hang dt = new tbl_Hang();
if (insert == true)
{
dt.TenHang = txttenhang.Text;
dt.id_Menu = int.Parse(ddltennhomhang.SelectedValue);
dt.ChatLieu = txtchatlieu.Text;
dt.giaMoi = decimal.Parse(txtgiamoi.Text);
dt.giaCu = decimal.Parse(txtgiacu.Text);
dt.Soluong = int.Parse(txtsoluong.Text);
dt.TomTat = txttomtat.Text;
if (int.Parse(txtsoluong.Text) > 0)
{
dt.TinhTrang = "Còn";
}
dt.Mota = txtNoidung.Text;
if (ful_hinhanhlon.HasFile)
{
try
{
string Duoi_filename = Path.GetExtension(ful_hinhanhlon.FileName);
string filename = ful_hinhanhlon.FileName.ToString();;
if (Duoi_filename == ".jpeg" || Duoi_filename == ".jpg" || Duoi_filename == ".png" || Duoi_filename == ".PNG" || Duoi_filename == ".JPG" || filename == ".JPEG")
{
ful_hinhanhlon.SaveAs(Server.MapPath("~/images/") + filename);
dt.image_large = "images/" + filename;
}
else
{
Response.Write("<script>alert('Bạn chỉ được upload jpg,png,jpeg')</script>");
return;
}
}
catch (Exception ex)
{
}
}
if (ful_hinhanhnho.HasFile)
{
try
{
string Duoi_filename = Path.GetExtension(ful_hinhanhnho.FileName);
string filename = ful_hinhanhnho.FileName.ToString();;
if (Duoi_filename == ".jpeg" || Duoi_filename == ".jpg" || Duoi_filename == ".png" || Duoi_filename == ".PNG" || Duoi_filename == ".JPG" || filename == ".JPEG")
{
ful_hinhanhnho.SaveAs(Server.MapPath("~/images/") + filename);
dt.image = "images/" + filename;
}
else
{
Response.Write("<script>alert('Bạn chỉ được upload jpg,png,jpeg')</script>");
return;
}
}
catch (Exception ex)
{
}
}
dt.Active = bool.Parse(ckbActive.Checked == true ? "True" : "False");
//SanPhamService.SanPham_Insert(dts);
db.tbl_Hangs.InsertOnSubmit(dt);
db.SubmitChanges();
Response.Write("<script>alert('Thêm mới thành công!!!')</script>");
getData();
}
else
{
dts.Id = txtID.Text;
dts.TenHang = txttenhang.Text;
dts.Id_Menu = ddltennhomhang.SelectedValue;
dts.ChatLieu = txtchatlieu.Text;
dts.GiaMoi = txtgiamoi.Text;
dts.GiaCu = txtgiacu.Text;
dts.Soluong = txtsoluong.Text;
dts.TomTat = txttomtat.Text;
if (int.Parse(txtsoluong.Text) > 0)
{
dts.TinhTrang = "Còn";
}
dts.Mota = txtNoidung.Text;
if (ful_hinhanhlon.HasFile)
{
try
{
string Duoi_filename = Path.GetExtension(ful_hinhanhlon.FileName);
string filename = ful_hinhanhlon.FileName.ToString();;
if (Duoi_filename == ".jpeg" || Duoi_filename == ".jpg" || Duoi_filename == ".png" || Duoi_filename == ".PNG" || Duoi_filename == ".JPG" || filename == ".JPEG")
{
ful_hinhanhlon.SaveAs(Server.MapPath("~/images/") + filename);
dts.ImageLarge = "images/" + filename;
}
else
{
Response.Write("<script>alert('Bạn chỉ được upload jpg,png,jpeg')</script>");
return;
}
}
catch (Exception ex)
{
}
}
else
{
dts.Image = fileUpLoad_nho;
}
if (ful_hinhanhnho.HasFile)
{
try
{
string Duoi_filename = Path.GetExtension(ful_hinhanhnho.FileName);
string filename = ful_hinhanhnho.FileName.ToString();;
if (Duoi_filename == ".jpeg" || Duoi_filename == ".jpg" || Duoi_filename == ".png" || Duoi_filename == ".PNG" || Duoi_filename == ".JPG" || filename == ".JPEG")
{
ful_hinhanhnho.SaveAs(Server.MapPath("~/images/") + filename);
dts.Image = "images/" + filename;
}
else
{
Response.Write("<script>alert('Bạn chỉ được upload jpg,png,jpeg')</script>");
return;
}
}
catch (Exception ex)
{
}
}
else
{
dts.ImageLarge = fileUpLoad_lon;
}
dts.Active = ckbActive.Checked == true ? "True" : "False";
SanPhamService.SanPham_Update(dts);
Response.Write("<script>alert('Update thành công!!!')</script>");
getData();
}
insert = true;
pnData.Visible = true;
pnInfo.Visible = false;
ClearText();
}
public ChiTietHDController(ChiTietHDService CTHDservice, SanPhamService SPService)
{
this.CTHDservice = CTHDservice;
this.SPService = SPService;
}