public static Customer GetDefaultCustomer()
{
var query = "SELECT TOP 1 * FROM CUSTOMERS";
try
{
var result = DataAccessHandler.ExecuteSelect(query);
return(GetMappedCustomer(result.Rows[0]));
}
catch (Exception e)
{
throw e;
}
}
public static IEnumerable <Customer> GetCustomers()
{
var query = string.Format("SELECT * FROM CUSTOMERS");
try
{
var result = DataAccessHandler.ExecuteSelect(query);
return(GetMappedCustomers(result));
}
catch (Exception e)
{
throw e;
}
}
public static IEnumerable <Order> GetOrdersRandomized()
{
var query = "SELECT TOP 5 * FROM ORDERS ORDER BY NEWID()";
try
{
var result = DataAccessHandler.ExecuteSelect(query);
return(GetMappedOrders(result));
}
catch (Exception e)
{
throw e;
}
}
public static IEnumerable <Order> GetOrders(int numberOfOrders = 5)
{
var query = string.Format("SELECT TOP {0} * FROM ORDERS", numberOfOrders);
try
{
var result = DataAccessHandler.ExecuteSelect(query);
return(GetMappedOrders(result));
}
catch (Exception e)
{
throw e;
}
}
public static IEnumerable <Order> GetOrders(int customerId, int numberOfOrders = 5)
{
var query = "SELECT * FROM ORDERS WHERE CustomerId = @customerId";
SqlParameter param = new SqlParameter("@customerId", customerId);
try
{
var result = DataAccessHandler.ExecuteSelect(query, new SqlParameter[] { param });
return(GetMappedOrders(result));
}
catch (Exception e)
{
throw e;
}
}
public static Customer GetCustomerByEmailOrName(string emailOrName)
{
var query = "SELECT TOP 1 * FROM CUSTOMERS WHERE FirstName = @emailOrName OR Email = @emailOrName";
var param = new SqlParameter("@emailOrName", emailOrName);
try
{
var result = DataAccessHandler.ExecuteSelect(query, new SqlParameter[] { param });
if (result.Rows.Count > 0 && result.Rows[0] != null)
{
return(GetMappedCustomer(result.Rows[0]));
}
return(null);
}
catch (Exception e)
{
throw e;
}
}
public static Customer GetCustomerById(int customerId)
{
var query = "SELECT TOP 1 * FROM CUSTOMERS WHERE CustomerId = @customerId";
var param = new SqlParameter("@customerId", customerId);
try
{
var result = DataAccessHandler.ExecuteSelect(query, new SqlParameter[] { param });
if (result.Rows.Count > 0 && result.Rows[0] != null)
{
return(GetMappedCustomer(result.Rows[0]));
}
return(null);
}
catch (Exception e)
{
throw e;
}
}
