public JsonResult PostExport(string ma) { bool success = true; string message = "Kết quả: Xuất báo cáo thành công."; try { var daoNH = new NhapHangDao(); NhapHang obj_PNK = daoNH.GetById(ma); List <ChiTietNhap> lst_CT_PNK = obj_PNK.ChiTietNhaps.OrderBy(obj => (obj.ID)).ToList(); List <DT_NhapKho> lst_DT_NK = new List <DT_NhapKho>(); for (int i = 0; i < lst_CT_PNK.Count; i++) { DT_NhapKho obj_DT_NK = new DT_NhapKho(); obj_DT_NK.STT = (i + 1).ToString(); obj_DT_NK.Mat_Hang = lst_CT_PNK.ElementAt(i).HangHoa.TenHH.ToString(); obj_DT_NK.So_Luong = lst_CT_PNK.ElementAt(i).SoLuong.ToString(); obj_DT_NK.DVT = lst_CT_PNK.ElementAt(i).HangHoa.DonViTinh.Ten; obj_DT_NK.Don_Gia = lst_CT_PNK.ElementAt(i).DonGia.ToString(); obj_DT_NK.Ma_Kho = lst_CT_PNK.ElementAt(i).MaKho.ToString(); obj_DT_NK.Thanh_Tien = (int.Parse(obj_DT_NK.So_Luong) * double.Parse(obj_DT_NK.Don_Gia)).ToString(); lst_DT_NK.Add(obj_DT_NK); } System.Web.HttpContext.Current.Session["Ma_NCC"] = obj_PNK.NhaCungCap.MaNCC; System.Web.HttpContext.Current.Session["Ten_NCC"] = obj_PNK.NhaCungCap.CongTy; System.Web.HttpContext.Current.Session["Dia_Chi_NCC"] = obj_PNK.NhaCungCap.DiaChi; System.Web.HttpContext.Current.Session["Nguoi_Giao"] = obj_PNK.NguoiGiaoHang; System.Web.HttpContext.Current.Session["Nguoi_Lap"] = obj_PNK.NguoiLapPhieu; System.Web.HttpContext.Current.Session["Dien_Giai"] = obj_PNK.DienGiai; System.Web.HttpContext.Current.Session["So_CT"] = obj_PNK.IDNhap; System.Web.HttpContext.Current.Session["SDT_NCC"] = obj_PNK.NhaCungCap.DienThoai.ToString(); System.Web.HttpContext.Current.Session["Ngay_HT"] = obj_PNK.NgayNhap.Value.Day.ToString() + "/" + obj_PNK.NgayNhap.Value.Month.ToString() + "/" + obj_PNK.NgayNhap.Value.Year.ToString(); System.Web.HttpContext.Current.Session["Tong_Tien"] = String.Format("{0:0,0}", obj_PNK.TongTien.Value); System.Web.HttpContext.Current.Session["Tien_Chu"] = CommonFunction.ConvertCurrency(obj_PNK.TongTien.Value); System.Web.HttpContext.Current.Session["Data_Source"] = lst_DT_NK; } catch (Exception ex) { success = false; message = "Kết quả: " + ex.ToString() + "."; } return(Json(new { success = success, message = message })); }
public ActionResult EditChiTietNhapHang(ChitietNhapHang ctnh) { var rs = new NhapHangDao().EditChiTietNhapHang(ctnh); if (rs == true) { return(RedirectToAction("Index", "NhapHang")); // return Chi tiết nhập hàng manh == ctnh.manh } else { ModelState.AddModelError("", "Update không thành công"); } return(View("Index")); }
public ActionResult NhapHang(NhapHang nh) { var user = (UserLogin)Session[Common.CommonConstant.USER_SESSION]; nh.NguoiNhap = user.ID; var kq = new NhapHangDao().Insert(nh); if (kq == true) { return(RedirectToAction("Index", "NhapHang")); } else { ModelState.AddModelError("", "Nhập hàng thất bại"); } return(View("Index")); }
public JsonResult CreatePNK(string ma, string ngay_nhap, string ma_ncc, string nguoi_lap_phieu, string nguoi_giao, string dien_giai, string tong_tien) { bool success = true; string message = "Kết quả: Tạo phiếu nhập kho thành công!"; var dao = new NhapHangDao(); var daoID = new CauHinhIDDao(); NhapHang obj = new NhapHang(); obj.IDNhap = ma; obj.NgayNhap = DateTime.ParseExact(ngay_nhap, "dd/MM/yyyy", null); obj.DoiTac = int.Parse(ma_ncc); obj.NguoiLapPhieu = nguoi_lap_phieu; obj.NguoiGiaoHang = nguoi_giao; obj.DienGiai = dien_giai; obj.LoaiGiaoDichID = 3; obj.TongTien = decimal.Parse(tong_tien); obj.CreatedDate = DateTime.Now; obj.CreateBy = Session["UserName"].ToString(); obj.TrangThai = 1; try { dao.Insert(obj); daoID.Update("NH"); } catch (Exception ex) { success = false; message = "Kết quả: " + ex.ToString() + "."; } return(Json(new { success = success, message = message })); }
public ActionResult GetDoanhThuTheoThang() { var list = new List <DoanhThuViewModel>(); decimal doanhthu, tongnhap, loinhuan; var nam = DateTime.Now.Year; for (int j = 2019; j <= nam; j++) { for (int i = 1; i <= 12; i++) { tongnhap = new NhapHangDao().TongNhap(i, j); doanhthu = new DonHangDao().DoanhThuTheoThang(i, j); loinhuan = doanhthu - tongnhap; if (doanhthu != 0) { list.Add(new DoanhThuViewModel { Thang = i, Nam = j, TongNhap = tongnhap, DoanhThu = doanhthu, LoiNhuan = loinhuan }); } } } return(Json(list, JsonRequestBehavior.AllowGet)); }
public ActionResult EditChiTietNhapHang(int manh, string masp, string mamau, string matt, string madl) { var edit = new NhapHangDao().SanPham(manh, masp, mamau, matt, madl); return(View(edit)); }
public ActionResult Index() { var listNH = new NhapHangDao().ListNH(); return(View(listNH)); }
public JsonResult XoaItem(int manh, string masp, string mamau, string matt, string madl) { var rs = new NhapHangDao().XoaItem(manh, masp, mamau, matt, madl); return(Json(new { status = true })); }