/// <summary>
/// Atttempts to login using user credentials against those stored in the database.
/// </summary>
/// <param name="user"></param>
/// <param name="pass"></param>
/// <returns></returns>
public int login(string user, string pass)
{
DALSelect login = new DALSelect();
bool found;
// Attempt to retrieve user from database
DataRow userData = login.getUserData(user, out found);
// If user found
if (found)
{
fillUser(userData);
// If user account has not been suspended
if (userActive)
{
pass = hashPassword(pass);
// Check password
if (pass == userPassword)
{
return(userID);
}
}
else
{
return(-2);
}
return(-1);
}
return(0);
}
/// <summary>
/// Retrieves a specified order according to an order ID parameter and returns class model representation.
/// </summary>
/// <param name="orderID"></param>
/// <returns></returns>
public BLOrder getOrder(int orderID)
{
OrderID = orderID;
OrderDetails = DALSelect.getOrder(orderID);
OrderItems = DALSelect.getOrderItems(orderID);
ShippingDetails = DALSelect.getShippingDetails(Convert.ToInt32(OrderDetails["shipID"]));
return(this);
}
/// <summary>
/// Checks if user exists in the database under the given email.
/// </summary>
/// <param name="email"></param>
/// <returns></returns>
public static bool checkUserEmail(string email)
{
DALSelect user = new DALSelect();
bool found;
DataRow userData = user.getUserData(email, out found);
return(found);
}
/// <summary>
/// Returns ADO.net model of user for the given user email.
/// </summary>
/// <param name="email"></param>
/// <returns></returns>
public BLUser getUserByEmail(string email)
{
DALSelect user = new DALSelect();
DataRow userData = user.getUserByEmail(email);
fillUser(userData);
return(this);
}
/// <summary>
/// Returns ADO.net model of user for the given user ID.
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public BLUser getUser(int userID)
{
DALSelect user = new DALSelect();
DataRow userData = user.getSingleUser(userID);
fillUser(userData);
return(this);
}
/// <summary>
/// Returns ADO.net model for shipping linked to the given shipping ID number.
/// </summary>
/// <param name="shipID"></param>
/// <returns></returns>
public BLShipping getShipping(int shipID)
{
DataRow shipping = DALSelect.getShippingDetails(shipID);
Id = Convert.ToInt32(shipping["shipID"]);
Method = shipping["shipType"].ToString();
Description = shipping["shipDescription"].ToString();
Cost = Convert.ToDouble(shipping["shipCost"]);
Wait = Convert.ToInt32(shipping["shipDays"]);
return(this);
}
/// <summary>
/// Returns populated ADO.net model of address from database.
/// </summary>
/// <param name="user"></param>
/// <param name="type"></param>
/// <returns></returns>
public BLAddress getAddress(int user, char type)
{
DALSelect address = new DALSelect();
DataRow addressData = address.getAddress(user, type);
addType = type;
addStreet = addressData["addStreet"].ToString();
addSuburb = addressData["addSuburb"].ToString();
addState = addressData["addState"].ToString();
addZip = Convert.ToInt32(addressData["addZip"]);
return(this);
}
/// <summary>
/// Checks if user exists in the database under the given username.
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public static int checkUser(string userName)
{
DALSelect check = new DALSelect();
bool found;
DataRow userData = check.getUserData(userName, out found);
if (found)
{
return(Convert.ToInt32(userData["userID"]));
}
return(0);
}
/// <summary>
/// Returns ADO.model representation of certain product specified by the product number.
/// </summary>
/// <param name="productNumber"></param>
/// <returns></returns>
public BLProduct selectProduct(string productNumber)
{
DataRow productData = DALSelect.selectProduct(productNumber);
prodNumber = productData["prodNumber"].ToString();
prodDescription = productData["prodDescription"].ToString();
prodPrice = Convert.ToDouble(productData["prodPrice"]);
prodActive = Convert.ToBoolean(productData["prodActive"]);
teamID = productData["teamID"].ToString();
teamLocale = productData["teamLocale"].ToString();
teamName = productData["teamName"].ToString();
playFirstName = productData["playFirstName"].ToString();
playLastName = productData["playLastName"].ToString();
jerNumber = Convert.ToInt32(productData["jerNumber"]);
image = new string[2];
image[0] = productData["imgFront"].ToString();
image[1] = productData["imgBack"].ToString();
stock = DALSelect.getStock(productNumber);
return(this);
}
/// <summary>
/// Returns dataset of alll NBA team that a jersey can be defined under.
/// </summary>
/// <returns></returns>
public static DataSet getTeams()
{
return(DALSelect.getTeams());
}
/// <summary>
/// Returns product dataset according to query string.
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public static DataSet getProductsSearch(string search)
{
return(DALSelect.getProductsSearch(search));
}
/// <summary>
/// Returns product dataset if login status is admin.
/// </summary>
/// <param name="admin"></param>
/// <returns></returns>
public static DataSet getProducts(bool admin)
{
return(DALSelect.getProducts(admin));
}
/// <summary>
/// Retrieves orders a specified user has made within the system.
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static DataSet getUserOrders(BLUser user)
{
return(DALSelect.getUserOrders(user));
}
/// <summary>
/// Returns data set representation of shipping table from the SQL database.
/// </summary>
/// <returns></returns>
public static DataSet getShippingTable()
{
return(DALSelect.getShippingTable());
}
/// <summary>
/// Returns data set containing all available shipping methods in system.
/// </summary>
/// <returns></returns>
public static DataSet getShippingMethods()
{
return(DALSelect.getShippingOptions());
}
/// <summary>
/// Get all users currently in the system.
/// </summary>
/// <returns></returns>
public static DataSet getUsers()
{
DALSelect users = new DALSelect();
return(users.getUsers());
}
