public LogIn()
{
DBSelect dBSelect = new DBSelect();
dBSelect.SelectCategoryWithProducts();
InitializeComponent();
}
//Made by Mikkel E.R. Glerup
/// <summary>
/// Returns a list of subscriptions which cotains a category
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static List <Categories> SelectSubscriptionwithCategory(int ID)
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectSubscriptionwithCategory(ID));
}
// Made by Helena Brunsgaard Madsen
/// <summary>
/// return a Deals with the given ID
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static Deals SelectDeal(int ID)
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectDeal(ID));
}
// Made by Helena Brunsgaard Madsen
/// <summary>
/// Creates a list of all deals in the database
/// </summary>
/// <returns></returns>
public static List <Deals> SelectAllDeals()
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectAllDeals());
}
//Mikkel E.R. Glerup
/// <summary>
/// Creates a list of subscriptions which are inactive
/// </summary>
/// <returns></returns>
public static List <Subscription> SelectInactiveSubscriptions()
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectInactiveSubscriptions());
}
public static Subscription SelectSubcription(int ID)
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectSubscription(ID));
}
// Made by Helena Brunsgaard Madsen
/// <summary>
/// Creates an object based of the given ID
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static Product SelectProduct(int?ID)
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectProduct(ID));
}
//Made by Mikkel E.R. Glerup
/// <summary>
/// Selects a user with the given ID from the database
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static User SelectUser(int ID)
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectUser(ID));
}
//Made by Mikkel E.R. Glerup
/// <summary>
/// Creates a list of categories with the amount of products contained
/// </summary>
/// <returns></returns>
public static List <Categories> SelectCategoriesAndProducts()
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectCategoryWithProducts());
}
// Made by Helena Brunsgaard Madsen
/// <summary>
/// Creates a category with the ID specified
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static Categories SelectCategory(int?ID)
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectCategory(ID));
}
//Made by Mikkel E.R. Glerup
/// <summary>
/// Checks username and password with the data in the database
/// </summary>
/// <returns></returns>
public static bool UserLogin()
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.GetUserIdByUsernameAndPassword());
}
// Made by Helena Brunsgaard Madsen
/// <summary>
/// Creates a list of all categories in the database
/// </summary>
/// <returns></returns>
public static List <Categories> SelectAllCategories()
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectAllCategories());
}
// Made by Helena Brunsgaard Madsen
/// <summary>
/// Returns a Customer with the ID specified
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static Customer SelectCustomer(int ID)
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectCustomer(ID));
}
// Made by Mikkel E.R. Glerup
/// <summary>
/// Creates a list with all customers that has a deal
/// </summary>
/// <returns></returns>
public static List <StatDeals> SelectCustomersWithDeals()
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectCustomersWithDeals());
}
// Made by Helena Brunsgaard Madsen
/// <summary>
/// Creates a list of all customers in the database
/// </summary>
/// <returns></returns>
public static List <Customer> SelectAllCustomers()
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectAllCustomers());
}
//Made by Mikkel E.R. Glerup
/// <summary>
/// Returns a list of DealTypes with the amount of times used
/// </summary>
/// <returns></returns>
public static List <StatDeals> SelectDealTypes()
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectDealTypes());
}
// Made by Helena Brunsgaard Madsen
/// <summary>
/// Creates a list of all products in the database
/// </summary>
/// <returns></returns>
public static List <Product> SelectAllProducts()
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectAllProducts());
}
// Made by Mikkel E.R. Glerup
/// <summary>
/// Creates a list of all users in the database
/// </summary>
/// <returns></returns>
public static List <User> SelectAllUsers()
{
DBSelect dBSelect = new DBSelect();
return(dBSelect.SelectAllUsers());
}