// GET: CountCartridge

        public ActionResult CountCartridge(string datetimepicker)
        {
            Debug.WriteLine(string.Format("datetimepicker={0}", datetimepicker));
            string dateTimePicker;

            if (datetimepicker != null)
            {
                ViewBag.DTP    = datetimepicker;
                dateTimePicker = datetimepicker;
            }
            else
            {
                ViewBag.DTP    = DateTime.Today.ToShortDateString();
                dateTimePicker = DateTime.Today.ToShortDateString();
            }
            IEnumerable <sp_SEL_RemainDays2Result> remainDays = _db.sp_SEL_RemainDays2();
            //CartridgeStateView cartridgeStateView = new CartridgeStateView(dateTimePicker);
            //IEnumerable<CartridgeStateView> csv=cartridgeStateView.
            IEnumerable <CartridgeStateView2> cartridgeStateView = new List <CartridgeStateView2>();

            /* foreach(var item in cartridgeStateView)
             * {
             *   item.InputDate = dateTimePicker;
             * }*/
            Mapper.CreateMap <sp_SEL_RemainDays2Result, CartridgeStateView2>().ConstructProjectionUsing(x => new CartridgeStateView2(dateTimePicker)); //.ConstructUsing(new CartridgeStateView(dateTimePicker));
            Mapper.Map(remainDays, cartridgeStateView);
            return(View(cartridgeStateView.Where(x => x.CountCartridge > 0).OrderBy(x => x.CountCartridge).ToList()));
        }
        /*
         * public ActionResult Index()
         * {
         *  IEnumerable<sp_SEL_RemainDaysResult> remainDays=_db.sp_SEL_RemainDays();
         *  IEnumerable<RemainDaysView> remainDaysView = new List<RemainDaysView>();
         *  Mapper.CreateMap<sp_SEL_RemainDaysResult, RemainDaysView>();
         *  Mapper.Map(remainDays, remainDaysView);
         *  return View(remainDaysView.OrderBy(x=>x.NumberDays).ToList());
         * }*/

        public ActionResult Index()
        {
            IEnumerable <sp_SEL_RemainDays2Result> remainDays     = _db.sp_SEL_RemainDays2();
            IEnumerable <RemainDaysView2>          remainDaysView = new List <RemainDaysView2>();

            Mapper.CreateMap <sp_SEL_RemainDays2Result, RemainDaysView2>();
            Mapper.Map(remainDays, remainDaysView);
            return(View(remainDaysView.OrderBy(x => x.NumberDays).ToList()));
        }