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 }));
}
