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)); }