public ActionResult Create([Bind(Include = "MaHangHoa,TenHangHoa,GiaNhap,GiamGia,GiaBan,SoLuong,Size,DonViTinh,MoTa,ThoiGianBaoHanh,HinhAnh,ThuongHieu,MaLoaiHangHoa,IsDeleted")] HangHoa hangHoa, HttpPostedFileBase hinhanh)
{
if (ModelState.IsValid)
{
if (hinhanh != null && hinhanh.ContentLength > 0)
{
try
{
string avatarfile = Path.GetFileName(hinhanh.FileName);
string path = Path.Combine(Server.MapPath("~/images/"), avatarfile);
hinhanh.SaveAs(path);
hangHoa.HinhAnh = avatarfile;
}
catch (Exception)
{
}
}
db.HangHoas.Add(hangHoa);
db.SaveChanges();
SetAlert("Thêm hàng hóa thành công!", "success");
return(RedirectToAction("Index"));
}
ViewBag.MaLoaiHangHoa = new SelectList(db.LoaiHangHoas.Where(i => i.IsDeleted != true), "MaLoaiHangHoa", "TenLoaiHangHoa", hangHoa.MaLoaiHangHoa);
return(View(hangHoa));
}
public ActionResult Create([Bind(Include = "MaNguoiDung,TenNguoiDung,DiaChi,SoDienThoai,Email,CMND,UserName,PassWord,MaChucVu,Avatar")] NguoiDung nguoiDung, HttpPostedFileBase avatar)
{ //,IsDeleted
if (ModelState.IsValid)
{
if (avatar != null && avatar.ContentLength > 0)
{
try
{
Random random = new Random();
string avatarfile = nguoiDung.UserName + "_" + random.Next(10000).ToString() + "_" + Path.GetFileName(avatar.FileName);
string path = Path.Combine(Server.MapPath("~/images/avatar/"), avatarfile);
avatar.SaveAs(path);
nguoiDung.Avatar = avatarfile;
}
catch (Exception)
{
//
}
}
else
{
nguoiDung.Avatar = "default.png";
}
nguoiDung.PassWord = MD5Encode.CreateMD5(nguoiDung.PassWord);
db.NguoiDungs.Add(nguoiDung);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaChucVu = new SelectList(db.ChucVus, "MaChucVu", "TenChucVu", nguoiDung.MaChucVu);
return(View(nguoiDung));
}
public void SaveAllCTBCTK(ICollection <ChiTietBaoCaoTonKho> chiTietBaoCaoTonKhoes, int id)
{
foreach (var i in chiTietBaoCaoTonKhoes)
{
i.MaBaoCaoTonKho = id;
db.ChiTietBaoCaoTonKhoes.Add(i);
db.SaveChanges();
}
}
public void DeleteAllCTPBH(int id)
{
var result = db.ChiTietPhieuBanHangs.Where(ct => ct.SoPhieuBanHang == id).ToList();
foreach (var item in result)
{
db.ChiTietPhieuBanHangs.Remove(item);
}
db.SaveChanges();
}
public ActionResult Create([Bind(Include = "MaThamSo,TenThamSo,GiaTri,NgayApDung")] ThamSo thamSo)
{
if (ModelState.IsValid)
{
db.ThamSoes.Add(thamSo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(thamSo));
}
public ActionResult Create([Bind(Include = "MaQuyen,TenQuyen")] Quyen quyen)
{
if (ModelState.IsValid)
{
db.Quyens.Add(quyen);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(quyen));
}
public ActionResult Create([Bind(Include = "MaChucVu,TenChucVu,IsDeleted")] ChucVu chucVu)
{
if (ModelState.IsValid)
{
db.ChucVus.Add(chucVu);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(chucVu));
}
public ActionResult Create([Bind(Include = "MaBaoCaoBanHang,Ngay,SoLuongPhieuBanHang,DoanhThu,TiLe")] ChiTietBaoCaoBanHang chiTietBaoCaoBanHang)
{
if (ModelState.IsValid)
{
db.ChiTietBaoCaoBanHangs.Add(chiTietBaoCaoBanHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaBaoCaoBanHang = new SelectList(db.BaoCaoBanHangs, "MaBaoCaoBanHang", "MaBaoCaoBanHang", chiTietBaoCaoBanHang.MaBaoCaoBanHang);
return(View(chiTietBaoCaoBanHang));
}
public ActionResult Create([Bind(Include = "MaLoaiHangHoa,TenLoaiHangHoa,GioiTinh,IsDeleted")] LoaiHangHoa loaiHangHoa)
{
if (ModelState.IsValid)
{
db.LoaiHangHoas.Add(loaiHangHoa);
db.SaveChanges();
SetAlert("Tạo loại hàng hóa thành công!", "success");
return(RedirectToAction("Index"));
}
return(View(loaiHangHoa));
}
public ActionResult Create([Bind(Include = "MaNhaCungCap,TenNhaCungCap,DiaChi,SoDienThoai,Email,IsDeleted")] NhaCungCap nhaCungCap)
{
if (ModelState.IsValid)
{
db.NhaCungCaps.Add(nhaCungCap);
db.SaveChanges();
SetAlert("Tạo nhà cung cấp thành công!", "success");
return(RedirectToAction("Index"));
}
return(View(nhaCungCap));
}
public ActionResult Create([Bind(Include = "MaBaoCaoTonKho,MaHangHoa,SoLuongTonDau,SoLuongNhap,SoLuongXuat,SoLuongTonCuoi,TinhTrangHangHoa")] ChiTietBaoCaoTonKho chiTietBaoCaoTonKho)
{
if (ModelState.IsValid)
{
db.ChiTietBaoCaoTonKhoes.Add(chiTietBaoCaoTonKho);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaBaoCaoTonKho = new SelectList(db.BaoCaoTonKhoes, "MaBaoCaoTonKho", "MaBaoCaoTonKho", chiTietBaoCaoTonKho.MaBaoCaoTonKho);
ViewBag.MaHangHoa = new SelectList(db.HangHoas, "MaHangHoa", "TenHangHoa", chiTietBaoCaoTonKho.MaHangHoa);
return(View(chiTietBaoCaoTonKho));
}
public ActionResult Create([Bind(Include = "MaChucVu,MaQuyen,ChuThich")] PhanQuyen phanQuyen)
{
if (ModelState.IsValid)
{
db.PhanQuyens.Add(phanQuyen);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaChucVu = new SelectList(db.ChucVus, "MaChucVu", "TenChucVu", phanQuyen.MaChucVu);
ViewBag.MaQuyen = new SelectList(db.Quyens, "MaQuyen", "TenQuyen", phanQuyen.MaQuyen);
return(View(phanQuyen));
}
public ActionResult Create([Bind(Include = "SoPhieuNhapKho,MaHangHoa,SoLuong,GiaNhap,ThanhTien")] ChiTietPhieuNhapKho chiTietPhieuNhapKho)
{
if (ModelState.IsValid)
{
db.ChiTietPhieuNhapKhoes.Add(chiTietPhieuNhapKho);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaHangHoa = new SelectList(db.HangHoas, "MaHangHoa", "TenHangHoa", chiTietPhieuNhapKho.MaHangHoa);
ViewBag.SoPhieuNhapKho = new SelectList(db.PhieuNhapKhoes, "SoPhieuNhapKho", "GhiChu", chiTietPhieuNhapKho.SoPhieuNhapKho);
return(View(chiTietPhieuNhapKho));
}
public ActionResult Create([Bind(Include = "SoPhieuDatHang,MaHangHoa,SoLuong,Gia,ThanhTien")] ChiTietPhieuDatHang chiTietPhieuDatHang)
{
if (ModelState.IsValid)
{
db.ChiTietPhieuDatHangs.Add(chiTietPhieuDatHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaHangHoa = new SelectList(db.HangHoas, "MaHangHoa", "TenHangHoa", chiTietPhieuDatHang.MaHangHoa);
ViewBag.SoPhieuDatHang = new SelectList(db.PhieuDatHangs, "SoPhieuDatHang", "TenKhachHang", chiTietPhieuDatHang.SoPhieuDatHang);
return(View(chiTietPhieuDatHang));
}
public void DeleteAllCTPNK(int id)
{
var result = db.ChiTietPhieuNhapKhoes.Where(ct => ct.SoPhieuNhapKho == id).ToList();
foreach (var item in result)
{
var hanghoa = db.HangHoas.Where(hh => hh.MaHangHoa == item.MaHangHoa).FirstOrDefault();
hanghoa.SoLuong -= item.SoLuong;
db.ChiTietPhieuNhapKhoes.Remove(item);
}
db.SaveChanges();
}
public void DeleteAllCTPKK(int id)
{
var result = db.ChiTietPhieuKiemKhoes.Where(ct => ct.SoPhieuKiemKho == id).ToList();
foreach (var item in result)
{
db.ChiTietPhieuKiemKhoes.Remove(item);
db.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "SoPhieuNhapKho")] PhieuChi phieuChi, FormCollection form)
{
string ngaychi = form["NgayChi"].ToString();
var user = (NguoiDung)Session["Account"];
string tien = form["Tongtienchi"].ToString();
string sophieunhap = form["Sophieunhapkho"].ToString();
string ghichu = form["Ghichu"].ToString();
if (ModelState.IsValid)
{
var phieu = Int32.Parse(sophieunhap);
var phieuChidb = db.PhieuChis.Where(n => n.SoPhieuNhapKho == phieu).ToList();
if (phieuChidb.Count() == 0)
{
db.PhieuChis.Add(new PhieuChi
{
NgayChi = DateTime.ParseExact(ngaychi, "dd/MM/yyyy", null),
MaNguoiDung = user.MaNguoiDung,
SoPhieuNhapKho = Int32.Parse(sophieunhap),
TongTienChi = Decimal.Parse(tien),
GhiChu = ghichu,
NgayChinhSua = DateTime.Now,
IsDeleted = false
});
db.SaveChanges();
SetAlert("Tạo phiếu chi thành công!", "success");
return(RedirectToAction("Index"));
}
else
{
SetAlert("Tạo phiếu chi thất bại, vui lòng kiểm tra lại!", "error");
}
}
ViewBag.SoPhieuNhapKho = ListPhieuNhapKho();
return(View(phieuChi));
}
public ActionResult Create([Bind(Include = "NgayBatDau,NgayKetThuc")] BaoCaoBanHang baoCaoBanHang)
{
if (ModelState.IsValid)
{
if (baoCaoBanHang.NgayBatDau > baoCaoBanHang.NgayKetThuc)
{
SetAlert("Ngày kết thúc phải sau ngày bắt đầu!", "error");
return(View(baoCaoBanHang));
}
var baocao1 = db.PhieuBanHangs.Where(n => n.NgayBan >= baoCaoBanHang.NgayBatDau && n.NgayBan <= baoCaoBanHang.NgayKetThuc);
var tongpbh = baocao1.Count();
decimal tongtien = 0;
if (tongpbh == 0)
{
//SetAlert("Không có thông tin để lập báo cáo!", "warning");
//return View(baoCaoBanHang);
tongtien = 0;
}
else
{
tongtien = baocao1.Sum(n => n.TongTien);
}
var baocao2 = db.PhieuNhapKhoes.Where(n => n.NgayNhapKho >= baoCaoBanHang.NgayBatDau && n.NgayNhapKho <= baoCaoBanHang.NgayKetThuc);
decimal tongtiennhap = 0;
if (baocao2.Count() == 0)
{
tongtiennhap = 0;
}
else
{
tongtiennhap = baocao2.Sum(n => n.TongTien);
}
var user = (NguoiDung)Session["Account"];
var res = (from pbh in db.PhieuBanHangs
where (pbh.NgayBan >= baoCaoBanHang.NgayBatDau && pbh.NgayBan <= baoCaoBanHang.NgayKetThuc)
group pbh by pbh.NgayBan into g
select new
{
NgayBan = g.Key,
SoDonHang = g.Count(),
DoanhThu = g.Sum(n => n.TongTien)
}).ToList();
decimal TongDT = 0;
foreach (var i in res)
{
TongDT += i.DoanhThu;
}
if (TongDT == 0)
{
//SetAlert("Tạo báo cáo bán hàng không thành công!", "error");
// return View(baoCaoBanHang);
}
var record = new BaoCaoBanHang
{
NgayBatDau = baoCaoBanHang.NgayBatDau,
NgayKetThuc = baoCaoBanHang.NgayKetThuc,
SoLuongPhieuBanHang = tongpbh,
TongTienBanHang = tongtien,
TongTienNhapHang = tongtiennhap,
TongDoanhThu = tongtien - tongtiennhap,
MaNguoiDung = user.MaNguoiDung,
IsDeleted = false
};
db.BaoCaoBanHangs.Add(record);
db.SaveChanges();
foreach (var i in res)
{
db.ChiTietBaoCaoBanHangs.Add(new ChiTietBaoCaoBanHang
{
MaBaoCaoBanHang = record.MaBaoCaoBanHang,
Ngay = i.NgayBan,
SoLuongPhieuBanHang = i.SoDonHang,
DoanhThu = i.DoanhThu,
TiLe = Convert.ToDouble(i.DoanhThu / TongDT)
});
db.SaveChanges();
}
SetAlert("Tạo báo cáo thành công!", "success");
return(RedirectToAction("Index"));
//Done
}
SetAlert("Tạo báo cáo bán hàng không thành công!, vui lòng kiểm tra lại", "error");
return(View(baoCaoBanHang));
}
public ActionResult Order(string TENKHACHHANG, string SDT, string DIACHI, string EMAIL, float TONGTIEN)
{
//them phieu dat hang
DateTime ngaydat = DateTime.Now;
string tenkhachhang = TENKHACHHANG;
string sdt = SDT;
string diachi = DIACHI;
string email = EMAIL;
float tongtien = TONGTIEN; //fixed bug
string hinhthucthanhtoan = "Thanh toán khi nhận hàng";
bool dathanhtoan = false;
bool daxacnhan = false;
bool isdeleted = false;
PhieuDatHang pdh = new PhieuDatHang
{
NgayDat = ngaydat,
TenKhachHang = tenkhachhang,
SoDienThoai = sdt,
Diachi = diachi,
Email = email,
TongTien = (decimal)tongtien,
HinhThucThanhToan = hinhthucthanhtoan,
DaThanhToan = dathanhtoan,
DaXacNhan = daxacnhan,
IsDeleted = isdeleted
};
try {
db.PhieuDatHangs.Add(pdh);
db.SaveChanges();
}
catch { throw; }
//them chi tiet phieu dat hang
int sophieudathang = pdh.SoPhieuDatHang;
if (Session["Cart"] != null)
{
List <ChiTietPhieuDatHang> cart = Session["Cart"] as List <ChiTietPhieuDatHang>;
for (int i = 0; i < cart.Count; i++)
{
try {
db.ChiTietPhieuDatHangs.Add(new ChiTietPhieuDatHang
{
SoPhieuDatHang = sophieudathang,
MaHangHoa = cart[i].MaHangHoa,
SoLuong = cart[i].SoLuong,
Gia = cart[i].Gia,
ThanhTien = cart[i].ThanhTien
});
db.SaveChanges();
////update so luong hang hoa
//HangHoa hh = db.HangHoas.AsEnumerable().SingleOrDefault(o => o.MaHangHoa == cart[i].MaHangHoa);
//if(hh!= null)
//hh.SoLuong -= cart[i].SoLuong;
//db.SaveChanges(); loai bo
}
catch { throw; }
}
}
//reset gio hang
Session["Cart"] = null;
SetAlert("Đặt hàng thành công!", "success");
return(Redirect("Home/Index"));
}
