public ActionResult ViewPaymentSlip(VendorPayModel model)
{
DatabaseClass ctx = new DatabaseClass();
int v = int.Parse(Session["VID"].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.VenderPayments.Where(i => i.VendorId == v).Select(i => i);
List <VendorPayModel> mod = new List <VendorPayModel>();
foreach (var i in req)
{
VendorPayModel dv = new VendorPayModel();
dv.VendorName = vname;
dv.year = i.Year;
dv.month = i.Month;
dv.MilkAmount = i.MilkAmount;
dv.FeedAmount = i.FeedAmount;
dv.GrossAmount = i.GrossAmount;
mod.Add(dv);
}
return(View(mod));
}
public ActionResult ViewVendorPaySlipFinal()
{
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.VenderPayments.Where(i => i.VendorId == v).Select(i => i);
List <VendorPayModel> mod = new List <VendorPayModel>();
foreach (var i in req)
{
VendorPayModel dv = new VendorPayModel();
dv.VendorName = vname;
dv.year = i.Year;
dv.month = i.Month;
dv.MilkAmount = i.MilkAmount;
dv.FeedAmount = i.FeedAmount;
dv.GrossAmount = i.GrossAmount;
mod.Add(dv);
}
//ViewBag.msg = " Gross Amount Paid to Vendor..Thank You";
return(View(mod));
//return RedirectToAction("ViewMsg", "Main");
}
public ActionResult AddVendorPaySlip(VendorPayModel model)
{
Session["month"] = model.month;
Session["year"] = model.year;
Session["vendor"] = model.UserId;
DAL d = new DAL();
ManagerPaytoVendData m = d.VendorPayDetails(model.month, model.year, model.UserId);
return(RedirectToAction("ViewVendorPaySlipFinal", "Main"));
}
public ActionResult ViewVendorPaySlipFinal(VendorPayModel model)
{
return(RedirectToAction("ViewMsg", "Main"));
}
