public ActionResult ViewFeedItem(AddFeedTransModel 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.Products.Where(i => i.VendorUid == v).Select(i => i);
var req = from i in ctx.FeedTransactions
where i.VendorId == v
select i;
List <AddFeedTransModel> mod = new List <AddFeedTransModel>();
foreach (var i in req)
{
AddFeedTransModel dv = new AddFeedTransModel();
dv.VendorName = vname;
dv.ItemName = i.ItemName;
dv.Quantity = i.ItemQuantity;
dv.Amount = i.ItemAmount;
dv.Date = i.FeedTransDate;
mod.Add(dv);
}
return(View(mod));
}
//Add Feed Transaction Details - manual code
public ActionResult AddFeedTrans()
{
DatabaseClass ctx = new DatabaseClass();
AddFeedTransModel model = new AddFeedTransModel();
var res = from l in ctx.Logins
where l.Role == "Vendor"
select new { VendorName = l.UserName, UserId = l.Uid };
List <SelectListItem> vend = new List <SelectListItem>();
foreach (var i in res)
{
vend.Add(new SelectListItem()
{
Text = i.VendorName, Value = i.UserId.ToString()
});
}
ViewBag.vend = vend;
Session["vendor"] = vend;
var r = from l in ctx.FeedItems
select new { itemname = l.ItemName, feedid = l.FeedItemId };
List <SelectListItem> feed = new List <SelectListItem>();
foreach (var i in r)
{
feed.Add(new SelectListItem()
{
Text = i.itemname, Value = i.feedid.ToString()
});
}
Session["feeditem"] = feed;
ViewBag.feed = feed;
return(View());
}
public ActionResult AddFeedTrans(AddFeedTransModel model)
{
DAL d = new DAL();
Session["vendor"] = model.VendorId;
Session["feeditem"] = model.ItemId;
AddFeedTransData at = d.TransDetails(model.ItemId, model.Quantity, model.Date, model.VendorId);
return(RedirectToAction("AddFeedTrans", "Feed"));
}
//View Feed Transaction Details - manual code
public ActionResult ViewFeedTransold()
{
DatabaseClass ctx = new DatabaseClass();
AddFeedTransModel model = new AddFeedTransModel();
var res = from l in ctx.Logins
where l.Role == "vendor"
select new { VendorName = l.UserName, UserId = l.Uid };
List <SelectListItem> vend = new List <SelectListItem>();
foreach (var i in res)
{
vend.Add(new SelectListItem()
{
Text = i.VendorName, Value = i.UserId.ToString()
});
}
ViewBag.vend = vend;
Session["VendId"] = vend;
return(View());
}
public ActionResult ViewFeedTransold(AddFeedTransModel model)
{
Session["VendId"] = model.UserId;
return(RedirectToAction("ViewFeedTrans", "Feed"));
}
