public ActionResult Delete(int mahoadon, int makhuyenmai)
{
GiamGia giamGia = db.GiamGias.SingleOrDefault(n => n.MaHoaDon == mahoadon && n.MaKhuyenMai == makhuyenmai);
db.GiamGias.Remove(giamGia);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public double getPhanTramGiam(DateTime ngaydung, string magiamgia)
{
if (kiemTraGiamGia(ngaydung, magiamgia))
{
GiamGia phantram = data.GiamGias.Where(v => v.MaGiamGia.Equals(magiamgia)).FirstOrDefault();
return(phantram.SoLuongGiam);
}
return(0);
}
public void SuaGiamGia(string magg, Decimal phantramgiam, DateTime ngaybatdau, DateTime ngayketthuc)
{
GiamGia ns = new GiamGia();
ns.MaGiamGia = magg;
ns.PhanTramGiam = phantramgiam;
ns.NgayBatDau = ngaybatdau;
ns.NgayKetThuc = ngayketthuc;
gg.SuaGiamGia(ns);
}
public ActionResult Edit([Bind(Include = "MaKhuyenMai,MaHoaDon,ApDung")] GiamGia giamGia)
{
if (ModelState.IsValid)
{
db.Entry(giamGia).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaHoaDon = new SelectList(db.HoaDonThanhToans, "MaHoaDon", "GhiChu", giamGia.MaHoaDon);
ViewBag.MaKhuyenMai = new SelectList(db.KhuyenMais, "MaKhuyenMai", "MoTa", giamGia.MaKhuyenMai);
return(View(giamGia));
}
// GET: GiamGias/Edit/5
public ActionResult Edit(int?mahoadon, int?makhuyenmai)
{
if (mahoadon == null && makhuyenmai == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
GiamGia giamGia = db.GiamGias.SingleOrDefault(n => n.MaHoaDon == mahoadon && n.MaKhuyenMai == makhuyenmai);
if (giamGia == null)
{
return(HttpNotFound());
}
ViewBag.MaHoaDon = new SelectList(db.HoaDonThanhToans, "MaHoaDon", "GhiChu", giamGia.MaHoaDon);
ViewBag.MaKhuyenMai = new SelectList(db.KhuyenMais, "MaKhuyenMai", "MoTa", giamGia.MaKhuyenMai);
return(View(giamGia));
}
public JsonResult GetBill(int Page, string Search, DateTime dateStart, DateTime dateEnd)
{
int Skip = 0, SizePage = 10;
if (Page == 1)
{
Skip = 0;
}
else
{
Skip = (Page * SizePage) - SizePage;
}
DateTime TimeNe = DateTime.ParseExact("1900-01-01", "yyyy-MM-dd", null);
var bill = (from a in db.tbl_HoaDon
join b in db.tbl_HoaDon_SanPham on a.id equals b.id_hoadon
join c in db.tbl_KhachHang on a.id_khachhang equals c.id into TenKH
join f in db.tbl_KhuyenMai on a.id_voucher equals f.id into GiamGia
from g in GiamGia.DefaultIfEmpty()
from e in TenKH.DefaultIfEmpty()
where ((Search != null && (a.mahoadon.ToLower().Contains(Search.ToLower()) || e.tenkhachhang.ToLower().Contains(Search.ToLower()))) || Search == null) &&
((dateStart == TimeNe && dateEnd == TimeNe) || ((dateStart != null && dateEnd != null) && DbFunctions.TruncateTime(a.ngaylap) >= dateStart.Date && DbFunctions.TruncateTime(a.ngaylap) <= dateEnd.Date))
group a by
new
{
a.mahoadon,
a.id,
a.ngaylap,
a.tongtien,
e.tenkhachhang,
g.giamgia
} into d
orderby d.Key.ngaylap descending
select new
{
idHoaDon = d.Key.id,
MaHD = d.Key.mahoadon,
ThoiGian = d.Key.ngaylap,
TenKH = d.Key.tenkhachhang,
TongTien = d.Key.tongtien,
KhuyenMai = d.Key.giamgia,
KhachTra = d.Key.giamgia != null ? d.Key.tongtien - d.Key.giamgia : d.Key.tongtien,
}).Skip(Skip).Take(SizePage);
return(Json(bill, JsonRequestBehavior.AllowGet));
}
public List <GiamGia> LayGiamGia()
{
List <GiamGia> listgg = new List <GiamGia>();
var lstgg = db.spGiamGia_SelectAll().ToList();
foreach (var n in lstgg)
{
GiamGia e = new GiamGia()
{
MaGiamGia = n.MaGiamGia,
PhanTramGiam = n.PhanTramGiam,
NgayBatDau = n.NgayBatDau,
NgayKetThuc = n.NgayKetThuc
};
listgg.Add(e);
}
return(listgg);
}
public HoaDon(DataRow row)
{
this.MaHoaDon = (int)row["MaHoaDon"];
this.ThoiDiemVao = (DateTime)row["thoiDiemVao"];
if (thoiDiemRa.ToString() != "")
{
this.ThoiDiemRa = (DateTime)thoiDiemRa;
}
this.TrangThai = (int)row["TrangThai"];
if (GiamGia.ToString() != "")
{
this.GiamGia = (float)Convert.ToDouble(row["GiamGia"]);
}
//if (TienDua.ToString() != "")
// this.TienDua = (int)row["tienDua"];
//if (TienThua.ToString() != "")
// this.TienThua = (int)row["tienThua"];
}
public bool XoaGiamGia(ref string err, int MaGiamGia)
{
bool f = false;
GiamGia hs = dbs.GiamGias.Single(p => p.MaGiamGia == MaGiamGia);
try
{
if (hs != null)
{
dbs.GiamGias.DeleteOnSubmit(hs);
dbs.SubmitChanges();
f = true;
}
}
catch (Exception ex)
{
err = ex.Message;
}
return(f);
}
public List <GiamGia> ToList(DataTable dt)
{
List <GiamGia> l = new List <GiamGia>();
foreach (DataRow dr in dt.Rows)
{
GiamGia g = new GiamGia();
g.MaGiamGia = Convert.ToInt32(dr[0]);
g.MaSP = Convert.ToInt32(dr[1]);
g.TenSP = Convert.ToString(dr[2]);
g.PhanTram = Convert.ToInt32(dr[3]);
g.GiaGiam = Convert.ToDouble(dr[4]);
g.HinhAnh = Convert.ToString(dr[5]);
g.Active = Convert.ToString(dr[6]);
g.NgayBatDau = Convert.ToString(dr[7]);
g.NgayKetThuc = Convert.ToString(dr[8]);
g.NgayNhap = Convert.ToString(dr[9]);
l.Add(g);
}
return(l);
}
public ActionResult MaGiam(string magiam)
{
var Magiam1 = db.GiamGias.Where(x => x.MaGiamGia == magiam).FirstOrDefault();
if (Magiam1.SoLuong > 0 && Magiam1 != null)
{
GiamGia dh = db.GiamGias.Find(Magiam1.ID);
Session["MaGiam"] = Magiam1.GiaTri;
Session["soluongma"] = null;
dh.SoLuong--;
db.Entry(dh).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("GioHang"));
}
else if (Magiam1.SoLuong <= 0 || Magiam1 != null)
{
Session["soluongma"] = 0;
return(RedirectToAction("GioHang"));
}
else
{
return(View());
}
}
public bool kiemTraGiamGia(DateTime ngaydung, string magiamgia)
{
GiamGia voucher = data.GiamGias.Where(s => s.MaGiamGia.Equals(magiamgia)).FirstOrDefault();
if (voucher != null)
{
if (voucher.SoLuongCon <= 0)
{
return(false);
}
else
{
if (ngaydung > voucher.NgayKetThuc)
{
return(false);
}
}
return(true);
}
else
{
return(false);
}
}
public void SuaGiamGia(GiamGia gg)
{
db.spGiamGia_Update(gg.MaGiamGia, gg.PhanTramGiam, gg.NgayBatDau, gg.NgayKetThuc);
}
public void ThemGiamGia(GiamGia gg)
{
db.spGiamGia_Insert(gg.MaGiamGia, gg.PhanTramGiam, gg.NgayBatDau, gg.NgayKetThuc);
}
