Beispiel #1
0
        public IActionResult Index()
        {
            ViewBag.data   = HttpContext.Session.GetObject(SD.Sessionname);
            ViewBag.branch = HttpContext.Session.GetObject(SD.Statusbranch);
            ViewBag.roll   = HttpContext.Session.GetString("roll");
            string   Branch = ViewBag.branch;
            loadtemp load   = new loadtemp();


            var billno = _context.purchaseinvoicesummeries.OrderByDescending(i => i.Billid).Where(i => i.Branch == Branch).FirstOrDefault();

            if (billno != null)
            {
                ViewBag.Billno = billno.Billid + 1;
            }
            else
            {
                ViewBag.Billno = 1;
            }
            int bill = ViewBag.Billno;
            var tmp  = _context.tmppurchases.Where(i => i.Branch == Branch).ToList();

            foreach (var item in tmp)
            {
                load.tmppurchases.Add(item);
            }


            return(View(load));
        }
        public IActionResult Index()
        {
            ViewBag.data   = HttpContext.Session.GetObject(SD.Sessionname);
            ViewBag.branch = HttpContext.Session.GetObject(SD.Statusbranch);
            ViewBag.roll   = HttpContext.Session.GetObject(SD.Statusroll);


            string   Branch = ViewBag.branch;
            loadtemp load   = new loadtemp();

            ViewBag.Branch = _context.branch.Where(i => i.Branchname == Branch).FirstOrDefault();

            var billno = _context.salesinvoicesummery.OrderByDescending(i => i.Billid).Where(i => i.Branch == Branch).FirstOrDefault(); //bill No

            if (billno != null)
            {
                ViewBag.Billno = billno.Billid + 1;
            }
            else
            {
                ViewBag.Billno = 1;
            }
            int bill = ViewBag.Billno;

            //for print
            if (bill != 0)
            {
                int bi      = bill - 1;
                var tmp     = _context.tempseccions.Where(i => i.Branch == Branch).ToList();
                var tmpsale = _context.salesinvoices.Where(i => i.Branch == Branch && i.Billno == bi).ToList();
                if (tmp.Count != 0)
                {
                    foreach (var item in tmp)
                    {
                        load.tempseccions.Add(item);
                    }
                }
                else
                {
                    foreach (var item in tmpsale)
                    {
                        load.salesinvoices.Add(item);
                    }
                    var tmpsummery = _context.salesinvoicesummery.Where(i => i.Billid == bi && i.Branch == Branch).ToList();
                    if (tmpsummery != null)
                    {
                        foreach (var item in tmpsummery)
                        {
                            // var istdate = TimeZoneInfo.ConvertTimeFromUtc(item.Billdate, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"));
                            TimeZoneInfo timeZone = TZConvert.GetTimeZoneInfo("India Standard Time");
                            var          isdate   = TimeZoneInfo.ConvertTime(item.Billdate, timeZone);

                            ViewBag.billdate = isdate;
                            load.salesinvoicesummeries.Add(item);
                        }
                    }
                }
            }
            return(View(load));
        }