public ActionResult CompanyTransactions()
{
var tList = db.transaction.OrderBy(x => x.tId);
//var trans = new List<trans>();
var T = (from t in db.transaction
join c in db.Customer on t.cId equals c.cId
join o in db.OrderList on t.cId equals o.cId
select new trans
{
cId = (int)t.cId,
customerName = c.cFName + c.cLName,
customerEmail = c.cEmail,
companyIncome = (decimal)t.companyIncome,
transactionDate = (DateTime)t.tDate
}).ToList();
ViewBag.TotalIncome = T.Sum(x => x.companyIncome).ToString("0.##");
var vm = new vTransactionVM
{
trans = (List <trans>)T,
total = T.Sum(x => x.companyIncome)
};
return(View());
}
public ActionResult transaction(vTransactionVM vm)
{
vm.total = (decimal)Session[CDictionary.TK_Cart_TOTALPRICE];
var userId = (int)Session[CDictionary.SK_LOGINED_USER_ID];
transaction ts = new transaction();
ts.cId = userId;
ts.companyIncome = vm.total * (decimal)0.9;
ts.tDate = DateTime.Now;
db.transaction.Add(ts);
return(View("ProductList", "Product"));
}
