SP

        public static List<SP_StockBooking_Calculate_Result1> SP_StockBooking_Calculate_Result(DateTime dtNow)
        {
            using (DB_BKMSEntities context = new DB_BKMSEntities())
            {
                return context.SP_StockBooking_Calculate(dtNow).ToList();
            }
        }

        public static SP_StockBooking_LastStock_Result SP_StockBooking_LastStock_Result(Guid productId, DateTime date)
        {
            using (DB_BKMSEntities context = new DB_BKMSEntities())
            {
                return context.SP_StockBooking_LastStock(productId, date).ToList().FirstOrDefault();
            }
        }

        public static List<SP_StockBooking_Report_KuantitasItemBookingSupplier_Result> SP_StockBooking_Report_KuantitasItemBookingSupplier(string supplierCode, DateTime? startDate, DateTime? endDate)
        {
            using (DB_BKMSEntities context = new DB_BKMSEntities())
            {
                return context.SP_StockBooking_Report_KuantitasItemBookingSupplier(startDate, endDate, supplierCode).ToList();
            }
        }



        public static List<SP_StockBooking_Report_RincihanQtyItemBookingSupplier_Result> SP_StockBooking_Report_RincihanQtyItemBookingSupplier(int PLU, string supplierCode, DateTime? startDate, DateTime? endDate)
        {
            using (DB_BKMSEntities context = new DB_BKMSEntities())
            {
                return context.SP_StockBooking_Report_RincihanQtyItemBookingSupplier(startDate, endDate,supplierCode, PLU).ToList();
            }
        }


        public static void SP_StockBooking_UpdateStockTagNToZero(string createdBy, DateTime dtNow)
        {
            using (DB_BKMSEntities context = new DB_BKMSEntities())
            {
                context.SP_StockBooking_UpdateStockTagNToZero(createdBy, dtNow);
            }
        }

        public static void SP_StockBooking_UpdateStockExpiredAndNotInRangeToZero(string createdBy, DateTime dtNow)
        {
            using (DB_BKMSEntities context = new DB_BKMSEntities())
            {
                context.SP_StockBooking_UpdateStockExpiredAndNotInRangeToZero(createdBy, dtNow);
            }
        }

        public static List<SP_ReportItemStatusBooking_Result> SP_ReportItemStatusBooking(string noDokumen, string supplierCode, string status)
        {
            using (DB_BKMSEntities context = new DB_BKMSEntities())
            {
                return context.SP_ReportItemStatusBooking(noDokumen, supplierCode, status).ToList();
            }
        }

        public static List<SP_ReportRekapitulasiTagihanItemBooking_Result> SP_ReportRekapitulasiTagihanItemBooking(string supplierCode, DateTime? tglAwal, DateTime? tglAkhir)
        {
            using (DB_BKMSEntities context = new DB_BKMSEntities())
            {
                return context.SP_ReportRekapitulasiTagihanItemBooking(supplierCode, tglAwal, tglAkhir).ToList();
            }
        }

        public static List<SP_ReportPesananItemBookingSupplier_Result> SP_ReportPesananItemBookingSupplier(string supplierCode, string noTagihan)
        {
            using (DB_BKMSEntities context = new DB_BKMSEntities())
            {
                return context.SP_ReportPesananItemBookingSupplier(supplierCode, noTagihan).ToList();
            }
        }

        public static List<SP_ReportPesananItemBookingSupplierPerPLU_Result> SP_ReportPesananItemBookingSupplierPerPLU(string supplierCode, string noTagihan)
        {
            using (DB_BKMSEntities context = new DB_BKMSEntities())
            {
                return context.SP_ReportPesananItemBookingSupplierPerPLU(supplierCode, noTagihan).ToList();
            }
        }

        public static List<SP_ReportMonitoringItemBookingSupplier_Result> SP_ReportMonitoringItemBookingSupplier(string supplierCode, DateTime? tglAwal, DateTime? tglAkhir, string status, string caraKirim)
        {
            if (!string.IsNullOrEmpty(supplierCode))
            {
                supplierCode = supplierCode.ToLower() == "all" ? null : supplierCode;
            }

            using (DB_BKMSEntities context = new DB_BKMSEntities())
            {
                return context.SP_ReportMonitoringItemBookingSupplier(supplierCode, tglAwal, tglAkhir, status, caraKirim).ToList();
            }
        }