public ActionResult Authorize(Users LoginModel)
{
StockMonitorEntities11 db = new StockMonitorEntities11();
var LoggedUser = db.Users.SingleOrDefault(x => x.KayttajaNimi == LoginModel.KayttajaNimi && x.Salasana == LoginModel.Salasana);
if (LoggedUser != null)
{
if (LoggedUser.Rooli.Equals("SuperUser"))
{
ViewBag.LoginMessage = "Successful login";
ViewBag.LoggedStatus = "In";
ViewBag.LoginError = 0;
Session["UserName"] = LoggedUser.KayttajaNimi;
Session["LoginID"] = LoggedUser.Salasana;
Session["Role"] = LoggedUser.Rooli;
return(RedirectToAction("Index", "Users"));
}
else
{
ViewBag.LoginMessage = "Successful login";
ViewBag.LoggedStatus = "In";
ViewBag.LoginError = 0;
ViewBag.User = LoggedUser.KayttajaNimi;
Session["UserName"] = LoggedUser.KayttajaNimi;
Session["LoginID"] = LoggedUser.Salasana;
Session["Role"] = LoggedUser.Rooli;
return(RedirectToAction("Index", "Portfolio"));
}
}
else
{
ViewBag.LoginMessage = "Login unsuccessfull";
ViewBag.LoggedStatus = "Out";
ViewBag.LoginError = 1;
LoginModel.LoginErrorMessage = "Tuntematon käyttäjätunnus tai salasana.";
return(View("Index", LoginModel));
}
}
// GET: Transactions
public ActionResult Index(string searchString1, string sortOrder, string currentFilter, int?page, int?pagesize)
{
//Session control
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.CurrentSort = sortOrder;
ViewBag.PvmSortParam = sortOrder == "Pvm" ? "pvm_desc" : "Pvm";
ViewBag.OstoMyyntiSortParam = sortOrder == "OstoMyynti" ? "om_desc" : "OstoMyynti";
ViewBag.YritysSortParam = string.IsNullOrEmpty(sortOrder) ? "yritys_desc" : "";
ViewBag.MaaraSortParam = sortOrder == "Maara" ? "maara_desc" : "Maara";
ViewBag.aHintaSortParam = sortOrder == "aHinta" ? "ahinta_desc" : "aHinta";
ViewBag.SummaSortParam = sortOrder == "Summa" ? "summa_desc" : "Summa";
ViewBag.ValuuttaSortParam = sortOrder == "Valuutta" ? "valuutta_desc" : "Valuutta";
ViewBag.KurssiSortParam = sortOrder == "Kurssi" ? "kurssi_desc" : "Kurssi";
ViewBag.SummaESortParam = sortOrder == "Summa (€)" ? "summaE_desc" : "Summa (€)";
ViewBag.KulutSortParam = sortOrder == "Kulut" ? "kulut_desc" : "Kulut";
ViewBag.GrandtotalSortParam = sortOrder == "Kaupan loppusumma (€)" ? "grandtotal_desc" : "Kaupan loppusumma (€)";
if (searchString1 != null)
{
page = 1;
}
else
{
searchString1 = currentFilter;
}
ViewBag.currentFilter = searchString1;
StockMonitorEntities11 db = new StockMonitorEntities11();
//Display only db items belonging to session user
var userId = Session["UserName"];
var transactions = from t in db.Transactions.Include(t => t.Currency).Include(t => t.Users).Include(t => t.TransactionTypes)
select t;
if (!String.IsNullOrEmpty(searchString1))
{
switch (sortOrder)
{
case "pvm_desc":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderByDescending(t => t.Pvm);
break;
case "Pvm":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderBy(t => t.Pvm);
break;
case "om_desc":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderByDescending(t => t.OstoMyynti);
break;
case "OstoMyynti":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderBy(t => t.OstoMyynti);
break;
case "yritys_desc":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderByDescending(t => t.Yritys);
break;
case "Maara":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderBy(t => t.Maara);
break;
case "maara_desc":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderByDescending(t => t.Maara);
break;
case "aHinta":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderBy(t => t.aHinta);
break;
case "ahinta_desc":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderByDescending(t => t.aHinta);
break;
case "Summa":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderBy(t => t.Total);
break;
case "summa_desc":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderByDescending(t => t.Total);
break;
case "Valuutta":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderBy(t => t.Currency.Currency1);
break;
case "valuutta_desc":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderByDescending(t => t.Currency.Currency1);
break;
case "Kurssi":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderBy(t => t.Kurssi);
break;
case "kurssi_desc":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderByDescending(t => t.Kurssi);
break;
case "Summa (€)":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderBy(t => t.TotalEuros);
break;
case "summaE_desc":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderByDescending(t => t.TotalEuros);
break;
case "Kulut":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderBy(t => t.Kulut);
break;
case "kulut_desc":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderByDescending(t => t.Kulut);
break;
case "Kaupan loppusumma (€)":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderBy(t => t.Grandtotal);
break;
case "grandtotal_desc":
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderByDescending(t => t.Grandtotal);
break;
default:
transactions = transactions.Where(t => t.Yritys.Contains(searchString1)).OrderBy(t => t.Yritys);
break;
}
}
else
{
switch (sortOrder)
{
case "pvm_desc":
transactions = transactions.OrderByDescending(t => t.Pvm);
break;
case "Pvm":
transactions = transactions.OrderBy(t => t.Pvm);
break;
case "om_desc":
transactions = transactions.OrderByDescending(t => t.OstoMyynti);
break;
case "OstoMyynti":
transactions = transactions.OrderBy(t => t.OstoMyynti);
break;
case "yritys_desc":
transactions = transactions.OrderByDescending(t => t.Yritys);
break;
case "Maara":
transactions = transactions.OrderBy(t => t.Maara);
break;
case "maara_desc":
transactions = transactions.OrderByDescending(t => t.Maara);
break;
case "aHinta":
transactions = transactions.OrderBy(t => t.aHinta);
break;
case "ahinta_desc":
transactions = transactions.OrderByDescending(t => t.aHinta);
break;
case "Summa":
transactions = transactions.OrderBy(t => t.Total);
break;
case "summa_desc":
transactions = transactions.OrderByDescending(t => t.Total);
break;
case "Valuutta":
transactions = transactions.OrderBy(t => t.Currency.Currency1);
break;
case "valuutta_desc":
transactions = transactions.OrderByDescending(t => t.Currency.Currency1);
break;
case "Kurssi":
transactions = transactions.OrderBy(t => t.Kurssi);
break;
case "kurssi_desc":
transactions = transactions.OrderByDescending(t => t.Kurssi);
break;
case "Summa (€)":
transactions = transactions.OrderBy(t => t.TotalEuros);
break;
case "summaE_desc":
transactions = transactions.OrderByDescending(t => t.TotalEuros);
break;
case "Kulut":
transactions = transactions.OrderBy(t => t.Kulut);
break;
case "kulut_desc":
transactions = transactions.OrderByDescending(t => t.Kulut);
break;
case "Kaupan loppusumma (€)":
transactions = transactions.OrderBy(t => t.Grandtotal);
break;
case "grandtotal_desc":
transactions = transactions.OrderByDescending(t => t.Grandtotal);
break;
default:
transactions = transactions.OrderBy(t => t.Yritys);
break;
}
}
int pageSize = (pagesize ?? 10);
int pageNumber = (page ?? 1);
//return View(transactions.ToPagedList(pageNumber, pageSize));
return(View(transactions.Where(t => t.Kayttaja == userId).ToPagedList(pageNumber, pageSize)));
}
}
// GET: Portfolio
public ActionResult Index(string searchString2, string sortOrder, string currentFilter1, int?page, int?pagesize)
{
//Session control
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.YritysSortParam = string.IsNullOrEmpty(sortOrder) ? "yritys_desc" : "";
ViewBag.OsakkeetYhtSortParam = sortOrder == "Osakkeiden määrä yhteensä" ? "osakkeetyht_desc" : "Osakkeiden määrä yhteensä";
ViewBag.HankintaYhtSortParam = sortOrder == "Hankinta-arvo yhteensä" ? "hankintayht_desc" : "Hankinta-arvo yhteensä";
if (searchString2 != null)
{
page = 1;
}
else
{
searchString2 = currentFilter1;
}
ViewBag.currentFilter1 = searchString2;
StockMonitorEntities11 db = new StockMonitorEntities11();
//Display only db items belonging to session user
var userId = Session["UserName"];
var portfolio = from p in db.Portfolio
select p;
if (!String.IsNullOrEmpty(searchString2))
{
switch (sortOrder)
{
case "yritys_desc":
portfolio = portfolio.Where(p => p.Yritys.Contains(searchString2)).OrderByDescending(p => p.Yritys);
break;
case "Osakkeiden määrä yhteensä":
portfolio = portfolio.Where(p => p.Yritys.Contains(searchString2)).OrderBy(p => p.MaaraYht);
break;
case "osakkeetyht_desc":
portfolio = portfolio.Where(p => p.Yritys.Contains(searchString2)).OrderByDescending(p => p.MaaraYht);
break;
case "Hankinta-arvo yhteensä":
portfolio = portfolio.Where(p => p.Yritys.Contains(searchString2)).OrderBy(p => p.HankintaArvo);
break;
case "hankintayht_desc":
portfolio = portfolio.Where(p => p.Yritys.Contains(searchString2)).OrderByDescending(p => p.HankintaArvo);
break;
default:
portfolio = portfolio.Where(p => p.Yritys.Contains(searchString2)).OrderBy(p => p.Yritys);
break;
}
}
else
{
switch (sortOrder)
{
case "yritys_desc":
portfolio = portfolio.OrderByDescending(p => p.Yritys);
break;
case "Osakkeiden määrä yhteensä":
portfolio = portfolio.OrderBy(p => p.MaaraYht);
break;
case "osakkeetyht_desc":
portfolio = portfolio.OrderByDescending(p => p.MaaraYht);
break;
case "Hankinta-arvo yhteensä":
portfolio = portfolio.OrderBy(p => p.HankintaArvo);
break;
case "hankintayht_desc":
portfolio = portfolio.OrderByDescending(p => p.HankintaArvo);
break;
default:
portfolio = portfolio.OrderBy(p => p.Yritys);
break;
}
}
int pageSize = (pagesize ?? 15);
int pageNumber = (page ?? 1);
return(View(portfolio.Where(t => t.Kayttaja == userId).ToPagedList(pageNumber, pageSize)));
}
}
