public ActionResult AddSuppPayment(SupplierPayModel model)
        {
            Session["month"]  = model.month;
            Session["year"]   = model.year;
            Session["vendor"] = model.UserId;
            DAL             d = new DAL();
            SupplierPayData m = d.PaymentDetails(model.month, model.year, model.UserId);

            return(RedirectToAction("ViewSuppPayment", "Feed"));
        }
        public ActionResult ViewSuppPayment(SupplierPayModel model)
        {
            DatabaseClass ctx = new DatabaseClass();
            int           v   = int.Parse(Session["vendor"].ToString());
            //To view the data from database
            string vnm = (from k in ctx.Logins
                          where k.Uid == v
                          select k.UserName).FirstOrDefault().ToString();
            string vname = vnm.ToString();
            var    req   = ctx.FeedSupplierPayments.Where(i => i.VendorId == v).Select(i => i);
            List <SupplierPayModel> mod = new List <SupplierPayModel>();

            foreach (var i in req)
            {
                SupplierPayModel dv = new SupplierPayModel();
                dv.VendorName = vname;
                dv.year       = i.Year;
                dv.month      = i.Month;
                dv.Amount     = i.TotalAmount;
                mod.Add(dv);
            }
            return(View(mod));
        }