public ActionResult Index2()
{
northwindEntities1 db = new northwindEntities1();
List <Products> model = db.Products.ToList();
db.Dispose();
return(View(model));
}
// GET: Products
public ActionResult Index()
{
if (Session["UserName"] == null) // Tässä tarkastetaan onko käyttäjä kirjautunut sisään
{
return(RedirectToAction("login", "home"));
}
else
{
northwindEntities1 db = new northwindEntities1();
List <Products> model = db.Products.ToList();
db.Dispose();
return(View(model));
}
}
public ActionResult Authorize(Logins LoginModel)
{
northwindEntities1 db = new northwindEntities1();
//Haetaan käyttäjän/Loginin tiedot annetuilla tunnustiedoilla tietokannasta LINQ -kyselyllä
var LoggedUser = db.Logins.SingleOrDefault(x => x.UserName == LoginModel.UserName && x.PassWord == LoginModel.PassWord);
if (LoggedUser != null)
{
ViewBag.LoginMessage = "Successfull login";
ViewBag.LoggedStatus = "In";
Session["UserName"] = LoggedUser.UserName;
return(RedirectToAction("Index", "Home")); //Tässä määritellään mihin onnistunut kirjautuminen johtaa --> Home/Index
}
else
{
ViewBag.LoginMessage = "Login unsuccessfull";
ViewBag.LoggedStatus = "Out";
LoginModel.LoginErrorMessage = "Tuntematon käyttäjätunnus tai salasana.";
return(View("Login", LoginModel));
}
}
public ActionResult _ProductSalesPerDate(string productName)
{
if (String.IsNullOrEmpty(productName))
{
productName = "Lakkalikööri"; // debug test
}
List <DailyProductSales> dailyproductsaleslist = new List <DailyProductSales>();
northwindEntities1 db = new northwindEntities1();
var orderSummary = from pds in db.ProductsDailySales
where pds.ProductName == productName
orderby pds.OrderDate
select new DailyProductSales
{
OrderDate = SqlFunctions.DateName("year", pds.OrderDate) + "." + SqlFunctions.DateName("MM", pds.OrderDate) + "." + SqlFunctions.DateName("day", pds.OrderDate),
DailySales = (float)pds.DailySales,
ProductName = pds.ProductName
};
return(Json(orderSummary, JsonRequestBehavior.AllowGet));
}
public ActionResult Authorize(Logins LoginModel)
{
northwindEntities1 db = new northwindEntities1();
var LoggedUser = db.Logins.SingleOrDefault(x => x.UserName == LoginModel.UserName && x.PassWord == LoginModel.PassWord);
if (LoggedUser != null)
{
ViewBag.LoginMessage = "Successfull login";
ViewBag.LoggedStatus = "Logged in";
ViewBag.LoginError = 0;
Session["UserName"] = LoggedUser.UserName;
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.LoginMessage = "Login unsuccessfull";
ViewBag.LoggedStatus = "Logged out";
ViewBag.LoginError = 1;
LoginModel.LoginErrorMessage = "Tuntematon käyttäjätunnus tai salasana.";
return(View("Index", LoginModel));
}
}
// GET: Products
public ActionResult Index(string sortOrder, string currentFilter1, string searchString1, string ProductCategory, string currentProductCategory, int?page, int?pagesize)
{
if (Session["UserName"] == null)
{
ViewBag.LoggedStatus = "Logged out";
return(RedirectToAction("login", "home"));
}
else
{
ViewBag.LoggedStatus = "Logged in";
ViewBag.CurrentSort = sortOrder;
ViewBag.ProductNameSortParm = String.IsNullOrEmpty(sortOrder) ? "productname_desc" : "";
// https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/sorting-filtering-and-paging-with-the-entity-framework-in-an-asp-net-mvc-application
ViewBag.UnitPriceSortParm = sortOrder == "UnitPrice" ? "unitprice_desc" : "UnitPrice";
if (searchString1 != null)
{
page = 1;
}
else
{
searchString1 = currentFilter1;
}
ViewBag.currentFilter1 = searchString1;
if ((ProductCategory != null) && (ProductCategory != "0"))
{
page = 1;
}
else
{
ProductCategory = currentProductCategory;
}
ViewBag.currentProductCategory = ProductCategory;
northwindEntities1 db = new northwindEntities1();
var tuotteet = from p in db.Products
select p;
if (!string.IsNullOrEmpty(ProductCategory) && (ProductCategory != "0"))
{
int para = int.Parse(ProductCategory);
tuotteet = tuotteet.Where(p => p.CategoryID == para);
}
if (!String.IsNullOrEmpty(searchString1))
{
switch (sortOrder)
{
case "productname_desc":
tuotteet = tuotteet.Where(p => p.ProductName.Contains(searchString1)).OrderByDescending(p => p.ProductName);
break;
case "UnitPrice":
tuotteet = tuotteet.Where(p => p.ProductName.Contains(searchString1)).OrderBy(p => p.UnitPrice);
break;
case "unitprice_desc":
tuotteet = tuotteet.Where(p => p.ProductName.Contains(searchString1)).OrderByDescending(p => p.UnitPrice);
break;
default:
tuotteet = tuotteet.Where(p => p.ProductName.Contains(searchString1)).OrderBy(p => p.ProductName);
break;
}
}
else
{
switch (sortOrder)
{
case "productname_desc":
tuotteet = tuotteet.OrderByDescending(p => p.ProductName);
break;
case "UnitPrice":
tuotteet = tuotteet.OrderBy(p => p.UnitPrice);
break;
case "unitprice_desc":
tuotteet = tuotteet.OrderByDescending(p => p.UnitPrice);
break;
default:
tuotteet = tuotteet.OrderBy(p => p.ProductName);
break;
}
}
List <Categories> lstCategories = new List <Categories>();
var categoryList = from cat in db.Categories
select cat;
Categories tyhjaCategory = new Categories();
tyhjaCategory.CategoryID = 0;
tyhjaCategory.CategoryName = "";
tyhjaCategory.CategoryIDCategoryName = "";
lstCategories.Add(tyhjaCategory);
foreach (Categories category in categoryList)
{
Categories yksiCategory = new Categories();
yksiCategory.CategoryID = category.CategoryID;
yksiCategory.CategoryName = category.CategoryName;
yksiCategory.CategoryIDCategoryName = category.CategoryID.ToString() + " - " + category.CategoryName;
lstCategories.Add(yksiCategory);
}
ViewBag.CategoryID = new SelectList(lstCategories, "CategoryID", "CategoryIDCategoryName", ProductCategory);
int pageSize = (pagesize ?? 10);
int pageNumber = (page ?? 1);
return(View(tuotteet.ToPagedList(pageNumber, pageSize)));
}
}
