public async Task<ReportServiceModel> GetProductMovement()
        {
            ReportServiceModel model = new ReportServiceModel();

            List<DropDownModel> warehouses = await WarehouseRepository.GetAll().Where(x => x.WarehouseStatus == Status.Active
               ).Select(x => new DropDownModel()
               {
                   Id = x.WarehouseSerial,
                   Name = x.WarehouseName,

               }).Take(20).ToListAsync();

            model.Warehouses = warehouses;

            List<DropDownModel> products = await ProducTabRepository.GetAll().Where(x => x.ProdStatus == Status.Active
              ).Select(x => new DropDownModel()
              {
                  Id = x.ProdSerial,
                  Name = x.ProdHead,

              }).Take(20).ToListAsync();

            model.Products = products;

            model.SessionSerial = SessionWrapper.Get(SessionWrapper.SessionKeys.CustSessionId);
            model.UserSerial = Convert.ToInt16(SessionWrapper.Get(SessionWrapper.SessionKeys.UserSerial));
            model.ConcernSerial = Convert.ToInt16(SessionWrapper.Get(SessionWrapper.SessionKeys.UserSerial));
            return model;
        }
        public async Task<ReportServiceModel> FindWarehouses(string keyword)
        {
            ReportServiceModel model = new ReportServiceModel();
            List<DropDownModel> list = await WarehouseRepository.GetAll().Where(x => x.WarehouseStatus == Status.Active && x.WarehouseName.Trim().ToLower().Contains(keyword.Trim().ToLower())
               ).Select(x => new DropDownModel()
               {
                   Id = x.WarehouseSerial,
                   Name = x.WarehouseName,

               }).Take(20).ToListAsync();
            model.Warehouses = list;
            return model;
        }
        public async Task<ReportServiceModel> FindProducts(string keyword)
        {
            ReportServiceModel model = new ReportServiceModel();
            List<DropDownModel> list = await ProducTabRepository.GetAll().Where(x => x.ProdStatus == Status.Active && x.ProdHead.Trim().ToLower().Contains(keyword.Trim().ToLower())
               ).Select(x => new DropDownModel()
               {
                   Id = x.ProdSerial,
                   Name = x.ProdHead,

               }).Take(20).ToListAsync();
            model.Products = list;
            return model;
        }