public ActionResult Sua(int masp)
{
ChiTietSanPham sp = new ChiTietSanPham();
sp = db.ChiTietSanPhams.FirstOrDefault(dep => dep.MaSP == masp);
return(View(sp));
}
private void btnThem_Click(object sender, EventArgs e)
{
CHI_TIET_SAN_PHAM ctsp = ChiTietSanPham.LayChiTietSanPham((int)cbbHangSanXuat.SelectedValue,
txtDongSanPham.Text, txtSoHieuSanPham.Text, txtTenSanPham.Text);
if (ctsp != null)
{
MessageBox.Show("Thông tin thêm bị trùng!");
return;
}
ctsp = new CHI_TIET_SAN_PHAM();
ctsp.MA_HANG = (int)cbbHangSanXuat.SelectedValue;
ctsp.DONG_SAN_PHAM = txtDongSanPham.Text;
ctsp.SO_HIEU_SAN_PHAM = txtSoHieuSanPham.Text;
ctsp.TEN_SAN_PHAM = txtTenSanPham.Text;
ctsp.THONG_TIN_KY_THUAT = txtThongTinKyThuat.Text;
ctsp.THONG_TIN_SAN_PHAM = txtThongTinSanPham.Text;
ctsp.THOI_GIAN_BAO_HANH = Convert.ToInt32(nudThoiGianBaoHanh.Value);
ctsp.GIA_BAN = Convert.ToInt32(txtGiaBan.Text);
if (ChiTietSanPham.ThemChiTietSanPham(ctsp))
{
MessageBox.Show("Thêm Thành Công!");
}
else
{
MessageBox.Show("Thêm Thất Bại!");
}
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
string s = txtIMEI.Text;
SAN_PHAM sp = SanPham.TimSanPham(s);
if (sp == null)
{
//InitializeComponent();
lbThongBao.Text = "!!!Không Tìm Thấy!!!";
txtMaKho.Text = "";
txtChiTietSanPham.Text = "";
dtpNgayBatDauBaoHanh.Value = DateTime.Now;
dtpNgayKetThucBaoHanh.Value = DateTime.Now;
txtGiaBan.Text = "0";
txtGiaMua.Text = "0";
btnNhanBaoHanh.Enabled = false;
return;
}
else
{
lbThongBao.Text = "!!!Đã Tìm Thấy!!!";
txtMaKho.Text = sp.MA_KHO.ToString();
txtChiTietSanPham.Text = ChiTietSanPham.LayChiTietSanPham(sp.MA_CHI_TIET_SAN_PHAM).DINH_DANH;
dtpNgayBatDauBaoHanh.Value = Convert.ToDateTime(sp.NGAY_BAT_DAU_BAO_HANH);
dtpNgayKetThucBaoHanh.Value = Convert.ToDateTime(sp.NGAY_KET_THUC_BAO_HANH);
txtGiaBan.Text = sp.GIA_BAN.ToString();
txtGiaMua.Text = sp.GIA_MUA.ToString();
cbbTrangThai.SelectedValue = sp.TRANG_THAI;
if ((int)cbbTrangThai.SelectedValue == 1)
{
btnNhanBaoHanh.Enabled = true;
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
CHI_TIET_SAN_PHAM tmp;
try
{
tmp = (CHI_TIET_SAN_PHAM)dgvChiTietSanPham.SelectedRows[0].DataBoundItem;
}
catch (Exception)
{
tmp = null;
return;
}
if (tmp == null)
{
return;
}
if (ChiTietSanPham.XoaChiTietSanPham(tmp.MA_CHI_TIET_SAN_PHAM))
{
MessageBox.Show("Xóa Thành Công!");
}
else
{
MessageBox.Show("Xóa Thất Bại!");
}
FormThayDoiChiTietSanPham_Load(sender, e);
}
public ActionResult DatHang(FormCollection collection)
{
//Them Don hang
DonHang ddh = new DonHang();
KhachHang kh = (KhachHang)Session["MaKH"];
//List<GioHang> gh = LayGioHang();
ShoppingCart gh = (ShoppingCart)Session["GioHang"];
ddh.MaKH = kh.MaKH;
ddh.NgayDat = DateTime.Now;
var ngaygiao = String.Format("{0:MM/dd/yyyy}", collection["Ngaygiao"]);
ddh.NgayGiao = DateTime.Parse(ngaygiao);
ddh.TinhTrangGH = false;
ddh.DaThanhToan = false;
db.DonHangs.Add(ddh);
db.SaveChanges();
//Them chi tiet don hang
foreach (var item in gh.Items)
{
ChiTietSanPham ctdh = new ChiTietSanPham();
ctdh.MaDonHang = ddh.MaDonHang;
ctdh.MaSP = item.MaSP;
ctdh.SoLuong = item.SoLuongTon;
ctdh.DonGia = (decimal)item.GiaBan;
db.ChiTietSanPhams.Add(ctdh);
}
db.SaveChanges();
Session["GioHang"] = null;
return(RedirectToAction("Xacnhandonhang", "Cart"));
}
public FormKiemTraHangTon()
{
InitializeComponent();
cbbChiTietSanPham.DataSource = ChiTietSanPham.LayChiTietSanPham();
cbbChiTietSanPham.DisplayMember = "DINH_DANH";
cbbChiTietSanPham.ValueMember = "MA_CHI_TIET_SAN_PHAM";
}
public int getGia()
{
if (gia == 0)
{
gia = ChiTietSanPham.LayChiTietSanPham(sp.MA_CHI_TIET_SAN_PHAM).GIA_BAN;
}
return(gia);
}
public long Update(ChiTietSanPham chitietsp)
{
var ctsp = db.ChiTietSanPhams.Find(chitietsp.MaCTSP);
ctsp.SoLuong = chitietsp.SoLuong;
db.SaveChanges();
return(ctsp.MaCTSP);
}
public ActionResult DeleteConfirmed(long id)
{
ChiTietSanPham chiTietSanPham = db.ChiTietSanPhams.Find(id);
db.ChiTietSanPhams.Remove(chiTietSanPham);
db.SaveChanges();
return(RedirectToAction("Index"));
}
void Select(string lsp = "")
{
dataSP.ItemsSource = null;
CTSP.Clear();
if (keywordTextBox.Text == "")
{
var select = from s in db.SANPHAMs
from t in db.LOAISANPHAMs
where s.KichHoat == true && t.MaLoaiSP == s.MaLoaiSP &&
s.MaLoaiSP.ToString().Contains(lsp)
select new { s.MaSP, s.TenSP, s.GiaBanRa, s.KhuyenMai, s.SoLuong, s.KichHoat, s.MaLoaiSP, t.TenLoaiSP };
foreach (var data in select)
{
var ctsp = new ChiTietSanPham()
{
TenLoaiSP = data.TenLoaiSP,
TenSP = data.TenSP,
MaLoaiSP = (int)data.MaLoaiSP,
MaSP = data.MaSP,
GiaBanRa = (decimal)data.GiaBanRa,
SoLuong = (int)data.SoLuong,
KichHoat = data.KichHoat.Value,
KhuyenMai = (int)data.KhuyenMai
};
CTSP.Add(ctsp);
}
}
else
{
var select = from s in db.SANPHAMs
from t in db.LOAISANPHAMs
where s.KichHoat == true && t.MaLoaiSP == s.MaLoaiSP &&
s.MaLoaiSP.ToString().Contains(lsp) &&
s.TenSP.ToLower().Contains(keywordTextBox.Text.ToLower())
select new { s.MaSP, s.TenSP, s.GiaBanRa, s.KhuyenMai, s.SoLuong, s.KichHoat, s.MaLoaiSP, t.TenLoaiSP };
foreach (var data in select)
{
var ctsp = new ChiTietSanPham()
{
TenLoaiSP = data.TenLoaiSP,
TenSP = data.TenSP,
MaLoaiSP = (int)data.MaLoaiSP,
MaSP = data.MaSP,
GiaBanRa = (decimal)data.GiaBanRa,
SoLuong = (int)data.SoLuong,
KichHoat = data.KichHoat.Value,
KhuyenMai = (int)data.KhuyenMai
};
CTSP.Add(ctsp);
}
}
dataSP.ItemsSource = CTSP;
}
// khỏi tạo giỏ hàng theo MAsach được truyền vào với sl mặc định là 1
public GioHang(int MaSP)
{
this.MaSP = MaSP;
ChiTietSanPham sp = data.ChiTietSanPhams.Single(n => n.MaSP == this.MaSP);
sTenSP = sp.TenSP;
sAnhBia = sp.AnhBia;
dGiaBan = decimal.Parse(sp.GiaBan.ToString());
iSlMua = 1;
}
public ActionResult Edit([Bind(Include = "MaCTSP,MetaTitle,Code,Mau,Size,SoLuong,LinkAnh,TrangThai,MaSanPham")] ChiTietSanPham chiTietSanPham)
{
if (ModelState.IsValid)
{
db.Entry(chiTietSanPham).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaSanPham = new SelectList(db.SanPhams, "MaSanPham", "TenSanPham", chiTietSanPham.MaSanPham);
return(View(chiTietSanPham));
}
public ActionResult Edit([Bind(Include = "MaSP,MaDonHang,SoLuong,DonGia")] ChiTietSanPham chiTietSanPham)
{
if (ModelState.IsValid)
{
db.Entry(chiTietSanPham).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaDonHang = new SelectList(db.DonHangs, "MaDonHang", "MaDonHang", chiTietSanPham.MaDonHang);
ViewBag.MaSP = new SelectList(db.SanPhams, "MaSP", "TenSP", chiTietSanPham.MaSP);
return(View(chiTietSanPham));
}
public ActionResult XoaSanPham(int id)
{
//Lay ra doi tuong sach can xoa theo ma
ChiTietSanPham sp = data.ChiTietSanPhams.SingleOrDefault(n => n.MaSP == id);
ViewBag.MaSP = sp.MaSP;
if (sp == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(sp));
}
private void cbbChiTietSanPham_SelectedIndexChanged(object sender, EventArgs e)
{
int maChiTietSanPham = (int)cbbChiTietSanPham.SelectedValue;
CHI_TIET_SAN_PHAM ctsp = ChiTietSanPham.LayChiTietSanPham(maChiTietSanPham);
int conTon = KhoHang.GetTonKho(maChiTietSanPham);
Console.WriteLine(conTon);
txtConLai.Text = conTon.ToString();
txtGiaBan.Text = ctsp.GIA_BAN.ToString();
txtThoiGianBaoHanh.Text = ctsp.THOI_GIAN_BAO_HANH.ToString();
txtThongTinKyThuat.Text = ctsp.THONG_TIN_KY_THUAT;
txtThongTinSanPham.Text = ctsp.THONG_TIN_SAN_PHAM;
}
public ActionResult Xoa(int masp)
{
ChiTietSanPham sp = new ChiTietSanPham();
sp = db.ChiTietSanPhams.FirstOrDefault(dep => dep.MaSP == masp);
if (sp != null)
{
List <ChiTietDonDatHang> lstDDH = db.ChiTietDonDatHangs.ToList().Where(giay => giay.MaSP == masp).ToList();
db.ChiTietDonDatHangs.DeleteAllOnSubmit(lstDDH);
db.ChiTietSanPhams.DeleteOnSubmit(sp);
db.SubmitChanges();
}
return(RedirectToAction("Qlysanpham", "Qlysanpham"));
}
// GET: Admin/ChiTietSanPhams/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietSanPham chiTietSanPham = db.ChiTietSanPhams.Find(id);
if (chiTietSanPham == null)
{
return(HttpNotFound());
}
return(View(chiTietSanPham));
}
public ActionResult XacNhanXoa(int id)
{
//Lay ra doi tuong sach can xoa theo ma
ChiTietSanPham sp = data.ChiTietSanPhams.SingleOrDefault(n => n.MaSP == id);
ViewBag.MaSP = sp.MaSP;
if (sp == null)
{
Response.StatusCode = 404;
return(null);
}
data.ChiTietSanPhams.DeleteOnSubmit(sp);
data.SubmitChanges();
return(RedirectToAction("SanPham"));
}
// GET: Admin/ChiTietSanPhams/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietSanPham chiTietSanPham = db.ChiTietSanPhams.Find(id);
if (chiTietSanPham == null)
{
return(HttpNotFound());
}
ViewBag.MaSanPham = new SelectList(db.SanPhams, "MaSanPham", "TenSanPham", chiTietSanPham.MaSanPham);
return(View(chiTietSanPham));
}
public ActionResult SuaSanPham(int id)
{
//Lay ra doi tuong sach theo ma
ChiTietSanPham sp = data.ChiTietSanPhams.SingleOrDefault(n => n.MaSP == id);
ViewBag.MaSP = sp.MaSP;
if (sp == null)
{
Response.StatusCode = 404;
return(null);
}
//Dua du lieu vao dropdownList
//Lay ds tu tabke chu de, sắp xep tang dan trheo ten chu de, chon lay gia tri Ma CD, hien thi thi Tenchude
ViewBag.MaLoai = new SelectList(data.PhanLoaiSanPhams.ToList().OrderBy(n => n.Loai), "MaLoai", "Loai", sp.MaLoai);
ViewBag.MaTheLoai = new SelectList(data.TheLoaiSanPhams.ToList().OrderBy(n => n.TenTheLoai), "MaTheLoai", "TenTheLoai", sp.MaTheLoai);
return(View(sp));
}
//
// GET: /SanPham/Details/5
public ActionResult Details(int id = 0)
{
ChiTietSanPham ctsp = new ChiTietSanPham();
var q = from s in db.SanPhams.Include("BinhLuans")
where s.maSP == id
select s;
SanPham sanpham = q.FirstOrDefault();
if (sanpham == null)
{
return(HttpNotFound());
}
ctsp.SanPham = sanpham;
ctsp.DSBinhLuan = sanpham.BinhLuans.ToList();
return(View(ctsp));
}
private void btnSave_Click(object sender, EventArgs e)
{
CHI_TIET_SAN_PHAM tmp;
try
{
tmp = (CHI_TIET_SAN_PHAM)dgvChiTietSanPham.SelectedRows[0].DataBoundItem;
}
catch (Exception)
{
tmp = null;
return;
}
if (tmp == null)
{
return;
}
ChiTietSanPham.XoaChiTietSanPham(tmp.MA_CHI_TIET_SAN_PHAM);
CHI_TIET_SAN_PHAM ctsp = ChiTietSanPham.LayChiTietSanPham((int)cbbHangSanXuat.SelectedValue,
txtDongSanPham.Text, txtSoHieuSanPham.Text, txtTenSanPham.Text);
if (ctsp != null)
{
MessageBox.Show("Thông tin thay đổi bị trùng!");
return;
}
ctsp = new CHI_TIET_SAN_PHAM();
ctsp.MA_HANG = (int)cbbHangSanXuat.SelectedValue;
ctsp.DONG_SAN_PHAM = txtDongSanPham.Text;
ctsp.SO_HIEU_SAN_PHAM = txtSoHieuSanPham.Text;
ctsp.TEN_SAN_PHAM = txtTenSanPham.Text;
ctsp.THONG_TIN_KY_THUAT = txtThongTinKyThuat.Text;
ctsp.THONG_TIN_SAN_PHAM = txtThongTinSanPham.Text;
ctsp.THOI_GIAN_BAO_HANH = Convert.ToInt32(nudThoiGianBaoHanh.Value);
ctsp.GIA_BAN = Convert.ToInt32(txtGiaBan.Text);
if (ChiTietSanPham.ThemChiTietSanPham(ctsp))
{
MessageBox.Show("Thay Đổi Thành Công!");
}
else
{
MessageBox.Show("Thay Đổi Thất Bại!");
}
FormThayDoiChiTietSanPham_Load(sender, e);
}
private void FormNhapHang_Load(object sender, EventArgs e)
{
cbbDoiTac.DataSource = new BindingList <DOI_TAC_NHAP_HANG>(DoiTacNhapHang.LayDoiTac());
cbbDoiTac.DisplayMember = "THONG_TIN";
cbbDoiTac.ValueMember = "MA_DOI_TAC";
cbbChiTietSanPham.DataSource = new BindingList <CHI_TIET_SAN_PHAM>(ChiTietSanPham.LayChiTietSanPham());
cbbChiTietSanPham.DisplayMember = "DINH_DANH";
cbbChiTietSanPham.ValueMember = "MA_CHI_TIET_SAN_PHAM";
try
{
int soLuong = Convert.ToInt32(txtSoLuong.Text);
int count = flowPanel.Controls.Count;
Console.WriteLine(soLuong + " " + count);
btnThemSanPham.Enabled = (count < soLuong);
}
catch (Exception)
{
}
}
public ActionResult Edit(FormCollection col, int masp)
{
ChiTietSanPham sp = new ChiTietSanPham();
if (sp != null)
{
sp = db.ChiTietSanPhams.FirstOrDefault(dep => dep.MaSP == masp);
sp.TenSP = col["tensp"];
sp.Hinh = col["hinh"];
sp.MoTa = col["mota"];
sp.Size = col["size"];
sp.MaLoai = int.Parse(col["loai"]);
sp.Gia = int.Parse(col["dongia"]);
sp.MaNhom = int.Parse(col["nhom"]);
db.SubmitChanges();
}
return(RedirectToAction("Qlysanpham", "Qlysanpham"));
}
public ActionResult InsertNew(FormCollection col, HttpPostedFileBase fileUpload)
{
var fileName = "";
if (fileUpload != null && fileUpload.ContentLength > 0)
{
fileName = Path.GetFileName(fileUpload.FileName);
var path = Path.Combine(Server.MapPath("~/Content/Hinh/"), fileName);
fileUpload.SaveAs(path);
}
ChiTietSanPham sp = new ChiTietSanPham();
sp.TenSP = col["tensp"];
sp.Hinh = fileName;
sp.MoTa = col["mota"];
sp.Size = col["size"];
sp.MaLoai = int.Parse(col["loai"]);
sp.Gia = int.Parse(col["dongia"]);
sp.MaNhom = int.Parse(col["nhom"]);
db.ChiTietSanPhams.InsertOnSubmit(sp);
db.SubmitChanges();
return(RedirectToAction("Qlysanpham", "Qlysanpham"));
}
public ActionResult Chitietsp(string tensp)
{
ChiTietSanPham chitietsp = db.ChiTietSanPhams.ToList().FirstOrDefault(sp => sp.TenSP.Contains(tensp));
return(View(chitietsp));
}
private void FormThayDoiChiTietSanPham_Load(object sender, EventArgs e)
{
dgvChiTietSanPham.DataSource = new BindingList <CHI_TIET_SAN_PHAM>(ChiTietSanPham.LayChiTietSanPham());
}
public static ArrayList LayDanhSachChiTietSanPham(string ma)
{
ArrayList list = new ArrayList();
string query = String.Format("SELECT * FROM ChiTietSanPham WHERE MaSP = '"+ ma +"' and STT = 1");
try
{
conn.Open();
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string masp = reader.GetString(1);
string sku = reader.GetString(2);
string model = reader.GetString(3);
string manhinh = reader.GetString(4);
string trongluong = reader.GetString(5);
string mausac = reader.GetString(6);
string kichthuocmanhinh = reader.GetString(7);
string bonhotrong = reader.GetString(8);
string bonnhongoai = reader.GetString(9);
string camera = reader.GetString(10);
string hedieuhanh = reader.GetString(11);
string loaipin = reader.GetString(12);
string congketnoi = reader.GetString(13);
string baohanh = reader.GetString(14);
string cpu = reader.GetString(15);
ChiTietSanPham sp = new ChiTietSanPham(masp, sku, model, manhinh, trongluong, mausac, kichthuocmanhinh, bonhotrong,bonnhongoai,camera,hedieuhanh,loaipin,congketnoi,baohanh,cpu);
list.Add(sp);
}
}
finally
{
conn.Close();
}
return list;
}
//Tram lam
public ActionResult ThemMoiSanPham(ChiTietSanPham sp, HttpPostedFileBase fileUpload, HttpPostedFileBase fileUpload_1, HttpPostedFileBase fileUpload_2, HttpPostedFileBase fileUpload_3)
{
//Dua du lieu vao dropdownload
ViewBag.MaLoai = new SelectList(data.PhanLoaiSanPhams.ToList().OrderBy(n => n.Loai), "MaLoai", "Loai");
ViewBag.MaTheLoai = new SelectList(data.TheLoaiSanPhams.ToList().OrderBy(n => n.TenTheLoai), "MaTheLoai", "TenTheLoai");
//Kiem tra duong dan file
if (fileUpload == null)
{
ViewBag.Thongbao = "Vui lòng chọn ảnh bìa";
return(View());
}
if (fileUpload_1 == null)
{
ViewBag.Thongbao = "Vui lòng chọn ảnh 1";
return(View());
}
if (fileUpload_2 == null)
{
ViewBag.Thongbao = "Vui lòng chọn ảnh 2";
return(View());
}
if (fileUpload_3 == null)
{
ViewBag.Thongbao = "Vui lòng chọn ảnh 3";
return(View());
}
//Them vao CSDL
else
{
if (ModelState.IsValid)
{
//Luu ten fie, luu y bo sung thu vien using System.IO;
var fileName = Path.GetFileName(fileUpload.FileName);
var fileName_1 = Path.GetFileName(fileUpload_1.FileName);
var fileName_2 = Path.GetFileName(fileUpload_2.FileName);
var fileName_3 = Path.GetFileName(fileUpload_3.FileName);
//Luu duong dan cua file
var path = Path.Combine(Server.MapPath("~/images"), fileName);
var path_1 = Path.Combine(Server.MapPath("~/images"), fileName_1);
var path_2 = Path.Combine(Server.MapPath("~/images"), fileName_2);
var path_3 = Path.Combine(Server.MapPath("~/images"), fileName_3);
//Kiem tra hình anh ton tai chua?
if (System.IO.File.Exists(path) || System.IO.File.Exists(path_1) || System.IO.File.Exists(path_2) || System.IO.File.Exists(path_3))
{
ViewBag.Thongbao = "Hình ảnh đã tồn tại";
}
else
{
//Luu hinh anh vao duong dan
fileUpload.SaveAs(path);
fileUpload_1.SaveAs(path_1);
fileUpload_2.SaveAs(path_2);
fileUpload_3.SaveAs(path_3);
}
sp.AnhBia = fileName;
sp.Anh_1 = fileName_1;
sp.Anh_2 = fileName_2;
sp.Anh_3 = fileName_3;
//Luu vao CSDL
data.ChiTietSanPhams.InsertOnSubmit(sp);
data.SubmitChanges();
}
return(RedirectToAction("SanPham"));
}
}
public bool themChiTietSanPham(ChiTietSanPham chitiet)
{
return(dal_chiTietSanPham.themChiTietSanPham(chitiet));
}
// Not Finish
public bool ThemChiTietSanPham(CHI_TIET_SAN_PHAM ctsp)
{
return(ChiTietSanPham.ThemChiTietSanPham(ctsp));
}
