public ActionResult Create(SanPham sanpham)
{
if (ModelState.IsValid)
{
if (sanpham.ImageFile.FileName != null)
{
string fileName = Path.GetFileNameWithoutExtension(sanpham.ImageFile.FileName);
string extension = Path.GetExtension(sanpham.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
sanpham.AnhSanPham = "~/FileUpload/" + fileName;
fileName = Path.Combine(Server.MapPath("~/FileUpload/"), fileName);
sanpham.ImageFile.SaveAs(fileName);
}
using (var db = new BanHangEntity())
{
db.SanPhams.Add(sanpham);
db.SaveChanges();
return(RedirectToAction("Edit", "SanPham", new { id = sanpham.SanPhamID }));
}
}
else
{
using (var db = new BanHangEntity())
{
sanpham.LoaiSanPhamCollection = db.LoaiSanPhams.ToList <LoaiSanPham>();
sanpham.DonViTinhCollection = db.DonViTinhs.ToList <DonViTinh>();
sanpham.NhaCungCapCollection = db.NhaCungCaps.ToList <NhaCungCap>();
return(View(sanpham));
}
}
}
List <SanPham> getlstSanpham()
{
db = new BanHangEntity();
var lst = db.SanPhams.SqlQuery("Select * from SanPham").ToList <SanPham>();
return(lst);
}
List <DonViTinh> getlstDVT()
{
db = new BanHangEntity();
var lst = db.DonViTinhs.ToList();
return(lst);
}
List <ThuocTinhSanPham> getlstThuocTinhSanPham()
{
db = new BanHangEntity();
var lst = db.ThuocTinhSanPhams.SqlQuery("Select * from ThuocTinhSanPham").ToList <ThuocTinhSanPham>();
return(lst);
}
public ActionResult Edit(LoaiSanPham dv)
{
if (Session["username"] == null)
{
return(RedirectToAction("/Index", "Users"));
}
else
{
if (ModelState.IsValid)
{
if (dv.ImageFile != null)
{
string fileName = Path.GetFileNameWithoutExtension(dv.ImageFile.FileName);
string extension = Path.GetExtension(dv.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
dv.AnhDaiDien = "~/FileUpload/" + fileName;
fileName = Path.Combine(Server.MapPath("~/FileUpload/"), fileName);
dv.ImageFile.SaveAs(fileName);
}
using (var db = new BanHangEntity())
{
db.Entry(dv).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(dv));
}
}
public ActionResult Edit(int id)
{
if (Session["username"] == null)
{
return(RedirectToAction("/Index", "Users"));
}
else
{
using (var db = new BanHangEntity())
{
try
{
SanPham sanPham = db.SanPhams.Include("ThuocTinhSanPhams").Include("ThuocTinhSanPhams.ThuocTinh").FirstOrDefault(x => x.SanPhamID == id);
sanPham.LoaiSanPhamCollection = db.LoaiSanPhams.ToList <LoaiSanPham>();
sanPham.DonViTinhCollection = db.DonViTinhs.ToList <DonViTinh>();
sanPham.NhaCungCapCollection = db.NhaCungCaps.ToList <NhaCungCap>();
return(View(sanPham));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(new HttpStatusCodeResult(404, "Error in cloud - GetPLUInfo" + ex.Message));
}
}
}
}
public ActionResult Create(LoaiSanPham loaiSanPham)
{
if (Session["username"] == null)
{
return(RedirectToAction("/Index", "Users"));
}
else
{
if (ModelState.IsValid)
{
if (loaiSanPham.ImageFile != null)
{
string fileName = Path.GetFileNameWithoutExtension(loaiSanPham.ImageFile.FileName);
string extension = Path.GetExtension(loaiSanPham.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
loaiSanPham.AnhDaiDien = "~/FileUpload/" + fileName;
fileName = Path.Combine(Server.MapPath("~/FileUpload/"), fileName);
loaiSanPham.ImageFile.SaveAs(fileName);
}
using (var db = new BanHangEntity())
{
db.LoaiSanPhams.Add(loaiSanPham);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(loaiSanPham));
}
}
public ActionResult DeleteItem(int SanPhamID)
{
using (var db = new BanHangEntity())
{
if (Session["username"] == null)
{
return(RedirectToAction("/Index", "Users"));
}
else
{
int id = (int)Session["usernameid"];
//var lstSanPham = db.SanPhams.Include(x => x.ChiTietDonDatHangs).ToList();
var donDatHang = db.DonDatHangs.Where(x => x.TaiKhoanDatHangID == id && x.TinhTrang == 0).FirstOrDefault();
var chiTiet = db.ChiTietDonDatHangs.Where(x => x.SanPhamID == SanPhamID && x.DonDatHangID == donDatHang.DonDatHangID).FirstOrDefault();
if (donDatHang != null)
{
donDatHang.ChiTietDonDatHangs.Remove(chiTiet);
db.SaveChanges();
int?soluong = 0;
foreach (var i in donDatHang.ChiTietDonDatHangs)
{
soluong = soluong + i.SoLuong;
}
Session["soluong"] = soluong;
}
return(RedirectToAction("/CartView", "Home"));
}
}
}
List <NhaCungCap> GetNhaCungCaps()
{
db = new BanHangEntity();
var lst = db.NhaCungCaps.ToList();
return(lst);
}
List <ThuocTinh> GetThuocTinhs()
{
db = new BanHangEntity();
var lst = db.ThuocTinhs.ToList();
return(lst);
}
public ActionResult Create(int id, int SanPhamID, int ThuocTinhID, string mota, string ghichu)
{
using (var db = new BanHangEntity())
{
if (id == 0)
{
ThuocTinhSanPham thuocTinhSanPham = new ThuocTinhSanPham();
thuocTinhSanPham.SanPhamID = SanPhamID;
thuocTinhSanPham.ThuocTinhID = ThuocTinhID;
thuocTinhSanPham.NoiDungMoTa = mota;
thuocTinhSanPham.GhiChu = ghichu;
db.ThuocTinhSanPhams.Add(thuocTinhSanPham);
}
else
{
ThuocTinhSanPham thuocTinhSanPham = db.ThuocTinhSanPhams.Find(id);
thuocTinhSanPham.ThuocTinhID = ThuocTinhID;
thuocTinhSanPham.SanPhamID = SanPhamID;
thuocTinhSanPham.NoiDungMoTa = mota;
thuocTinhSanPham.GhiChu = ghichu;
}
db.SaveChanges();
return(RedirectToAction("Edit", "SanPham", new { id = SanPhamID }));
}
}
List <DonDatHang> getlstDonDatHang()
{
db = new BanHangEntity();
var lst = db.DonDatHangs.OrderBy(x => x.DonDatHangID).ToList();
return(lst);
}
List <LoaiSanPham> getlstLoaiSanPham()
{
db = new BanHangEntity();
var lst = db.LoaiSanPhams.OrderBy(x => x.LoaiSanPhamID).ToList();
return(lst);
}
List <DichVu> getlstDichVu()
{
db = new BanHangEntity();
var lst = db.DichVus.OrderBy(x => x.DichVuID).ToList();
return(lst);
}
// GET: Users
List <User> getlstUser()
{
db = new BanHangEntity();
var lst = db.Users.ToList();
return(lst);
}
public ActionResult Create(DonDatHang donDatHang)
{
using (var db = new BanHangEntity())
{
db.DonDatHangs.Add(donDatHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(DonDatHang donDatHang)
{
using (var db = new BanHangEntity())
{
db.Entry(donDatHang).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(User us)
{
using (var db = new BanHangEntity())
{
db.Entry(us).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("/List"));
}
public ActionResult Edit(ThuocTinhSanPham sanPham)
{
using (var db = new BanHangEntity())
{
db.Entry(sanPham).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
// GET: DonDatHang
public ActionResult BangKeMuaHangHoa(string currentSFilter, string searchDateS, string currentFFilter, string searchDateF, int?option, int?sanPhamID, int?page)
{
if (Session["username"] == null)
{
return(RedirectToAction("/Index", "Users"));
}
else
{
db = new BanHangEntity();
ViewBag.lstSanPham = new SelectList(db.SanPhams, "SanPhamID", "TenSanPham", sanPhamID);
ViewBag.sanPhamID = sanPhamID;
if (searchDateS != null || searchDateF != null)
{
page = 1;
}
else
{
searchDateS = currentSFilter;
searchDateF = currentFFilter;
}
ViewBag.CurrentSFilter = searchDateS;
ViewBag.CurrentFFilter = searchDateF;
var lstDonDatHang = getlstDonDatHang().AsQueryable().Where(x => x.TinhTrang != 0);
if (sanPhamID.HasValue)
{
lstDonDatHang = lstDonDatHang.Where(s => s.ChiTietDonDatHangs.Any(x => x.SanPhamID == sanPhamID));
}
if (!String.IsNullOrEmpty(searchDateS))
{
lstDonDatHang = lstDonDatHang.Where(s => s.NgayDat >= Convert.ToDateTime(searchDateS));
}
if (!String.IsNullOrEmpty(searchDateF))
{
lstDonDatHang = lstDonDatHang.Where(s => s.NgayDat <= Convert.ToDateTime(searchDateF));
}
if (option.HasValue)
{
if (option == -1)
{
lstDonDatHang = lstDonDatHang.Where(o => o.TinhTrang != TrangThaiDonHang.CHUA_GUI && o.TinhTrang != TrangThaiDonHang.THANH_LY_HUY_HANG);
}
else
{
lstDonDatHang = lstDonDatHang.Where(o => o.TinhTrang == option);
}
}
int pageSize = 5;
int pageNumber = (page ?? 1);
return(View(lstDonDatHang.ToPagedList(pageNumber, pageSize)));
}
}
public ActionResult Create()
{
using (var db = new BanHangEntity())
{
SanPham sp = new SanPham();
sp.LoaiSanPhamCollection = db.LoaiSanPhams.ToList <LoaiSanPham>();
sp.DonViTinhCollection = db.DonViTinhs.ToList <DonViTinh>();
sp.NhaCungCapCollection = db.NhaCungCaps.ToList <NhaCungCap>();
return(View(sp));
}
}
public FileResult ExportMau03(string searchDateS = null, string searchDateF = null, int?option = null, int?sanPhamID = null)
{
using (var db = new BanHangEntity())
{
IQueryable <DonDatHang> results = db.DonDatHangs;
string tenHang = "";
if (option.HasValue)
{
if (option == -1)
{
results = results.Where(o => o.TinhTrang != TrangThaiDonHang.CHUA_GUI && o.TinhTrang != TrangThaiDonHang.THANH_LY_HUY_HANG);
}
else
{
results = results.Where(o => o.TinhTrang == option);
}
}
string[] strTu, strDen;
DateTime?tu = null, den = null;
if (!string.IsNullOrWhiteSpace(searchDateS) && searchDateS != "undefined" && searchDateS != "null")
{
strTu = searchDateS.Split(' ');
tu = DateTime.Parse(strTu[0]);
if (tu.HasValue)
{
results = results.Where(o => o.NgayDat >= tu);
}
}
if (!string.IsNullOrWhiteSpace(searchDateF) && searchDateF != "undefined" && searchDateF != "null")
{
strDen = searchDateF.Split(' ');
den = DateTime.Parse(strDen[0]);
if (den.HasValue)
{
results = results.Where(o => o.NgayDat <= den);
}
}
if (sanPhamID.HasValue)
{
results = results.Where(o => o.ChiTietDonDatHangs.Any(y => y.SanPhamID == sanPhamID));
tenHang = db.SanPhams.Find(sanPhamID) != null?db.SanPhams.Find(sanPhamID).TenSanPham : "";
}
results = results.OrderBy(o => o.TinhTrang).OrderByDescending(o => o.NgayDat);
string sWebRootFolder = HostingEnvironment.ApplicationPhysicalPath + "\\FileUpload";
ExportMau03(results.ToList(), "Mau03", sWebRootFolder, tu, den, sanPhamID, tenHang);
string fPath = sWebRootFolder + "\\" + "Mau03.xlsx";
System.IO.FileInfo fi = new System.IO.FileInfo(fPath);
return(File(fPath, System.Net.Mime.MediaTypeNames.Application.Octet, "Mau03" + fi.Extension));
}
}
public ActionResult Create()
{
//if (Session["username"] == null)
// return RedirectToAction("/Index", "Users");
//else
//{
using (var db = new BanHangEntity())
{
ThuocTinhSanPham sp = new ThuocTinhSanPham();
return(View(sp));
}
//}
}
public ActionResult Create(ThuocTinh thuocTinh)
{
if (ModelState.IsValid)
{
using (var db = new BanHangEntity())
{
db.ThuocTinhs.Add(thuocTinh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(thuocTinh));
}
public ActionResult Delete(float id)
{
using (var db = new BanHangEntity())
{
User user = db.Users.Find(id);
if (user != null)
{
db.Users.Remove(user);
db.SaveChanges();
}
}
return(RedirectToAction("/List"));
}
public ActionResult Edit(ThuocTinh thuocTinh)
{
if (ModelState.IsValid)
{
using (var db = new BanHangEntity())
{
db.Entry(thuocTinh).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(thuocTinh));
}
public ActionResult Delete(float id)
{
using (var db = new BanHangEntity())
{
DichVu dichVu = db.DichVus.Find(id);
if (dichVu != null)
{
db.DichVus.Remove(dichVu);
db.SaveChanges();
}
}
return(RedirectToAction("/Index"));
}
public ActionResult DeleteChiTietDon(int idChiTiet, int idDonHang)
{
using (var db = new BanHangEntity())
{
ChiTietDonDatHang chiTietDonDatHang = db.ChiTietDonDatHangs.Find(idChiTiet);
if (chiTietDonDatHang != null)
{
db.ChiTietDonDatHangs.Remove(chiTietDonDatHang);
db.SaveChanges();
}
}
return(RedirectToAction("/Edit/" + idDonHang));
}
public ActionResult Delete(float id)
{
using (var db = new BanHangEntity())
{
NhaCungCap nhaCungCap = db.NhaCungCaps.Find(id);
if (nhaCungCap != null)
{
db.NhaCungCaps.Remove(nhaCungCap);
db.SaveChanges();
}
}
return(RedirectToAction("/Index"));
}
public ActionResult Delete(float id)
{
using (var db = new BanHangEntity())
{
LoaiSanPham loaiSanPham = db.LoaiSanPhams.Find(id);
if (loaiSanPham != null)
{
db.LoaiSanPhams.Remove(loaiSanPham);
db.SaveChanges();
}
}
return(RedirectToAction("/Index"));
}
