public ActionResult Details(int id)
{
var dao = new QuanLyKhoHangDao().ViewDentail(id);
SetViewBag(dao.MaKho);
return(View(dao));
}
// GET: Admin/QuanLyKhoHang
public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
{
var dao = new QuanLyKhoHangDao();
var model = dao.LayTatCaDS(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
public ActionResult CapNhat(int id)
{
var dao = new QuanLyKhoHangDao();
ViewBag.MaNguoiDung = new CT_QHDao().NguoiQuanLy();
var quyenhan = dao.ViewDentail(id);
SetViewBag(quyenhan.MaKho);
return(View(quyenhan));
}
public ActionResult CapNhat(QuanLyKhoHang qh)
{
qh.NgayPhan = DateTime.Now;
var dao = new QuanLyKhoHangDao();
var cq = dao.ChinhSua(qh);
if (cq == true)
{
SetAlert("Cap nhat thanh cong", "success");
return(RedirectToAction("Index", "QuanLyKhoHang"));
}
else
{
return(RedirectToAction("CapNhat", "QuanLyKhoHang"));
}
}
public double?Sum()
{
var sessionCart = (List <CartItem>)Session[CartSesstion];
double?tong = 0;
var lathongtin = Session[CommonConstants.MaND_SESSTION]; //lay ma quan ly tu session
var mand = Convert.ToString(lathongtin); //chuyen ma thanh string
var dao2 = new QuanLyKhoHangDao().TimNguoiDungTheoMa(mand);
foreach (var item in sessionCart)
{
var giahang = new ChiTiet_HangHoaDao().ThongTinTimTheoMaHang_MaKho(item.Hang_Hoa.MaHang, dao2.MaKho);
var bien = item.SoLuong * giahang[0].DonGia;
tong = tong + bien;
}
return(tong);
}
public ActionResult ThemMoi(QuanLyKhoHang ql)
{
if (ql.MaNguoiDung != null)
{
ql.NgayPhan = DateTime.Now;
var dao = new QuanLyKhoHangDao();
var id = dao.ThemMoi(ql);
if (id > 0)
{
SetAlert("Thêm quyền thành công", "success");
return(RedirectToAction("Index", "QuanLyKhoHang"));
}
else
{
return(RedirectToAction("ThemMoi", "QuanLyKhoHang"));
}
}
SetAlert("Chưa chọn người quản lý", "error");
return(RedirectToAction("ThemMoi", "QuanLyKhoHang"));
}
public ActionResult XuatHang()
{
//khai Bao
var sessionCart = (List <CartItem>)Session[CartSesstion];// danh sach cart
var dao = new ChiTietDonHangDao();
var dao1 = new ChiTiet_HangHoaDao();
DS_XuatKho BienTam = new DS_XuatKho(); //khai bao bien tam
//ma nguoi dung
var lathongtin = Session[CommonConstants.MaND_SESSTION]; //lay ma quan ly tu session
var mand = Convert.ToString(lathongtin); //chuyen ma thanh string
var dao2 = new QuanLyKhoHangDao().TimNguoiDungTheoMa(mand); //tim ma nguoi dung trong bang quan ly kho hang
int Stt = dao2.STT; //gan gia tri cho stt
int maKho = dao2.MaKho;
var result = ExportData(dao2);
foreach (var item in sessionCart)
{
if (item.SoLuong > 0)
{
BienTam.MaHang = item.Hang_Hoa.MaHang;
BienTam.NgayXuat = DateTime.Now;
BienTam.SoLuong = item.SoLuong;
BienTam.DonGia = item.Hang_Hoa.DonGia;
BienTam.STT = Stt;
var id = dao.ThemMoi(BienTam);
if (id > 0)
{
dao1.ChinhSua(BienTam, maKho);
}
}
}
Session[CartSesstion] = null;
SetAlert("Đã tạo xong Hàng Xuất Kho", "success");
return(RedirectToAction("Index", "Home"));
}
// GET: Admin/XuatHang
public ActionResult Index(int page = 1, int pageSize = 10)
{
var dao = new ChiTiet_HangHoaDao();
// lấy mã người dùng
var lathongtin = Session[CommonConstants.MaND_SESSTION];
var mand = Convert.ToString(lathongtin);
string maNguoiDung = mand;
//Tim nguoi quan ly kho
var dao1 = new QuanLyKhoHangDao().TimNguoiDungTheoMa(maNguoiDung);
if (dao1 != null)
{
int maKho = dao1.MaKho;
var model = dao.LayTatCaDSTheoMaKho(page, pageSize, maKho);
return(View(model));
}
else
{
return(RedirectToAction("Trangloi"));
}
}
//update gio hang
public JsonResult Update(string cartModel)
{
var jsonCart = new JavaScriptSerializer().Deserialize <List <CartItem> >(cartModel);
//danh sach hang trong cart
var sessionCart = (List <CartItem>)Session[CartSesstion];
//=======danh sach hang nguoi quan ly kho======
//lay ma nguoi quan ly
var lathongtin = Session[CommonConstants.MaND_SESSTION];
var mand = Convert.ToString(lathongtin);
string maNguoiDung = mand;
//Tim nguoi quan ly kho
var dao1 = new QuanLyKhoHangDao().TimNguoiDungTheoMa(maNguoiDung);
int maKho = dao1.MaKho;
// danh sach trong kho
var dao = new ChiTiet_HangHoaDao().LayDStheoManguoiDung(maKho);
foreach (var item in sessionCart)
{
var jsonItem = jsonCart.SingleOrDefault(x => x.Hang_Hoa.MaHang == item.Hang_Hoa.MaHang);
var HangTrongKho = dao.SingleOrDefault(x => x.MaHang == item.Hang_Hoa.MaHang);
if (jsonItem != null && jsonItem.SoLuong > 0 && jsonItem.SoLuong <= HangTrongKho.Soluong)
{
item.SoLuong = jsonItem.SoLuong;
}
else if (jsonItem != null && jsonItem.SoLuong > 0 && jsonItem.SoLuong > HangTrongKho.Soluong)
{
item.SoLuong = Convert.ToInt32(HangTrongKho.Soluong);
}
}
Session[CartSesstion] = sessionCart;
return(Json(new
{
status = true
}));
}
public ActionResult Import(HttpPostedFileBase excelfile)
{
if (excelfile == null || excelfile.ContentLength == 0)
{
ViewBag.Error = "Hãy chọn một file excel<br>";
return(View("Index"));
}
else
{
if (excelfile.FileName.EndsWith("xls") || excelfile.FileName.EndsWith("xlsx"))
{
try
{
string path = Server.MapPath("~/Content/Excelfile/" + excelfile.FileName);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
excelfile.SaveAs(path);
Excel.Application application = new Excel.Application();
Excel.Workbook workbook = application.Workbooks.Open(path);
Excel.Worksheet worksheet = workbook.ActiveSheet;
Excel.Range range = worksheet.UsedRange;
List <Excel_hanghoa> hanghoa = new List <Excel_hanghoa>();
Excel_thongtin tt = new Excel_thongtin();
//chèn vào model với các giá trị trong excelfile
for (int row = 3; row < range.Rows.Count; row++)
{
if (row < 4)
{
tt.MaNguoiTao = ((Excel.Range)range.Cells[row - 2, 3]).Text;
tt.TenNguoiTao = ((Excel.Range)range.Cells[row - 2, 2]).Text;
tt.MaNhaCungCap = int.Parse(((Excel.Range)range.Cells[row, 4]).Text);
tt.TenNhaCungCap = ((Excel.Range)range.Cells[row, 2]).Text;
}
else
{
if (row > 5)
{
if (row <= range.Rows.Count - 2)
{
Excel_hanghoa hh = new Excel_hanghoa();
hh.Mahang = int.Parse(((Excel.Range)range.Cells[row, 1]).Text);
hh.TenHang = ((Excel.Range)range.Cells[row, 2]).Text;
hh.TenLoaihang = ((Excel.Range)range.Cells[row, 3]).Text;
hh.SoLuong = int.Parse(((Excel.Range)range.Cells[row, 4]).Text);
hh.DonGia = double.Parse(((Excel.Range)range.Cells[row, 5]).Text);
hanghoa.Add(hh);
}
}
}
}
//=============Xử lý thông tin nhập vào bảng giá trị================
//tìm người mã mã kho bằng mã người tạo
var dao = new QuanLyKhoHangDao();
var thongtin = dao.TimNguoiDungTheoMa(tt.MaNguoiTao);
var dao1 = new CT_NhapHangDao();
//nhap hang vao table CT_NhapHang
for (int i = 0; i < hanghoa.Count; i++)
{
CT_NhapHang bientam = new CT_NhapHang();
bientam.MaHang = hanghoa[i].Mahang;
bientam.MaNhaCungCap = tt.MaNhaCungCap;
bientam.MaKho = thongtin.MaKho;
bientam.NguoiNhap = thongtin.DanhSachNguoiDung.TenNguoiDung + "(" + tt.MaNguoiTao + ")";
bientam.NgayNhap = DateTime.Now;
var id = dao1.ThemMoi(bientam);
}
//Nhập hàng vào chi tiết hàng hóa
var dao2 = new ChiTiet_HangHoaDao();
for (int i = 0; i < hanghoa.Count; i++)
{
ChiTietHangHoa bientam = new ChiTietHangHoa();
bientam.MaKho = thongtin.MaKho;
bientam.MaHang = hanghoa[i].Mahang;
bientam.Soluong = hanghoa[i].SoLuong;
bientam.DonGia = hanghoa[i].DonGia;
var id = dao2.ThemMoi(bientam);
}
ViewBag.ListHang = hanghoa;
return(View("ThanhCong"));
}
catch (Exception ex)
{
ViewBag.Error = "file đã tồn tại, Bạn có thể chọn tên khác";
return(View("Index"));
}
}
else
{
ViewBag.Error = "File không hợp lệ";
return(View("Index"));
}
}
}
