public inventoryItem getSingleItemById(int itemId)
{
inventoryItem requestedItem = new inventoryItem();
try
{
//Attempt to populate an instance of the "inventoryItem" class with the information requested from
//the database.
dbQuery dbConnect = new dbQuery();
DataTable dbRequest = dbConnect.requestInventoryItem(itemId);
requestedItem.Item_Id = Int32.Parse((dbRequest.Rows[0][0]).ToString());
requestedItem.Item_Name = (dbRequest.Rows[0][1]).ToString();
requestedItem.Item_Price = decimal.Parse((dbRequest.Rows[0][2]).ToString());
requestedItem.Standard_Offer = Int32.Parse((dbRequest.Rows[0][3]).ToString());
requestedItem.Loyalty_Offer = Int32.Parse((dbRequest.Rows[0][4]).ToString());
requestedItem.Item_Stock = Int32.Parse((dbRequest.Rows[0][5]).ToString());
}
catch
{
//If "inventoryItem" is not properly populated, return a 0 as item Id
//(read as an error by the PresentationLayer).
requestedItem.Item_Id = 0;
}
return(requestedItem);
}
public void sendLoyaltyToUpdate(int id, int loyaltyNo)
{
//Send altered LoyaltyCard information to database.
dbQuery updateDB = new dbQuery();
updateDB.updateItemLoyaltyOffer(id, loyaltyNo);
}
public void sendPriceControlToUpdate(int id, string validatedPriceData, int offerNo)
{
//Send altered PriceControl form to database to update information.
decimal price = decimal.Parse(validatedPriceData);
dbQuery updateDB = new dbQuery();
updateDB.updateItemPrice(id, price);
updateDB.updateItemStandardOffer(id, offerNo);
}
public ListBox loadInventoryData(int formType)
{
ListBox toFill = new ListBox();
dbQuery dbConnect = new dbQuery();
DataTable dbItems = dbConnect.allInventoryItems();
string sp = " - "; //Uniform spacing between "columns" in listbox.
string addItem;
//Load class with written names for offer types (instead of Id's).
StandardAndLoyaltyOffers offers = new StandardAndLoyaltyOffers();
//"formType" refers to the form which called the function;
//0 is PriceControl,
//1 is StockMonitor
//2 is LoyaltyCard.
if (formType == 0)
{
toFill.Items.Add("Item Id" + sp + "Item Name" + sp + "Price" + sp + "Standard Offer");
//Populate requested listbox with formatted data.
foreach (DataRow row in dbItems.Rows)
{
addItem = row[0] + sp + row[1] + sp + "£" + row[2] + sp + offers.getOfferName(Int32.Parse(row[3].ToString()));
toFill.Items.Add(addItem);
}
}
else if (formType == 1)
{
toFill.Items.Add("Item Id" + sp + "Item Name" + sp + "Stock");
//Populate requested listbox with formatted data.
foreach (DataRow row in dbItems.Rows)
{
addItem = row[0] + sp + row[1] + sp + row[5];
toFill.Items.Add(addItem);
}
}
else if (formType == 2)
{
toFill.Items.Add("Item Id" + sp + "Item Name" + sp + "Loyalty Offer");
//Populate requested listbox with formatted data.
foreach (DataRow row in dbItems.Rows)
{
addItem = row[0] + sp + row[1] + sp + offers.getLoyaltyName(Int32.Parse(row[4].ToString()));
toFill.Items.Add(addItem);
}
}
//Return the requested data.
return(toFill);
}
public int inventoryItemCount()
{
//Method to loop through each item in the database, to count how many items there are.
int itemCounter = 0;
dbQuery dbConnect = new dbQuery();
DataTable dbItems = dbConnect.allInventoryItems();
foreach (DataRow row in dbItems.Rows)
{
itemCounter++;
}
return(itemCounter);
}
public performanceReport GenerateReport()
{
//Report to be filled.
performanceReport report = new performanceReport();
//Fill a local variable with each of the sales records to be processed.
dbQuery accessDB = new dbQuery();
DataTable allSales = accessDB.allAccountingRecords();
//Local Variables for working out the values to be inserted into the
//report.
decimal totalEarnings = 0;
int totalSales = 0;
int totalCustomers = 0;
DateTime saleDate;
decimal thisYearEarnings = 0;
decimal thisYearSales = 0;
decimal thisYearCustomers = 0;
decimal priorYearEarnings = 0;
decimal priorYearSales = 0;
decimal priorYearCustomers = 0;
//Go through each record of the datatable.
//Row[0] is Id.
//Row[1] is date.
//Row[2] is spend (earnings).
//Row[3] is total individual items in purchase.
foreach (DataRow Row in allSales.Rows)
{
totalEarnings += decimal.Parse(Row[2].ToString());
totalSales += Int32.Parse(Row[3].ToString());
totalCustomers++;
//Get date associated with current row.
saleDate = DateTime.Parse(Row[1].ToString());
//If saleDate is within 1 year of current date.
if (saleDate < systemDate && saleDate > systemDate.AddYears(-1))
{
thisYearEarnings += decimal.Parse(Row[2].ToString());
thisYearSales += Int32.Parse(Row[3].ToString());
thisYearCustomers++;
}
//If saleDate is within 2 years of current date, but not within 1 year.
else if (saleDate < systemDate.AddYears(-1) && saleDate > systemDate.AddYears(-2))
{
priorYearEarnings += decimal.Parse(Row[2].ToString());
priorYearSales += Int32.Parse(Row[3].ToString());
priorYearCustomers++;
}
}
//Append all of the calculated values to report.
report.Total_Earnings = totalEarnings;
report.Total_Items_Sold = totalSales;
report.Total_Customers = totalCustomers;
report.Past_Year_Earnings = thisYearEarnings;
report.Past_Year_Items_Sold = decimal.ToInt32(thisYearSales);
report.Past_Year_Customers = decimal.ToInt32(thisYearCustomers);
//Calculate the percentage differences between this year and last,
//then append them to the report.
decimal percentageEarnings = thisYearEarnings / priorYearEarnings * 100;
decimal percentageSales = thisYearSales / priorYearSales * 100;
decimal percantageCustomers = thisYearCustomers / priorYearCustomers * 100;
report.Percentage_Of_Prior_Year_Earnings = percentageEarnings;
report.Percentage_Of_Prior_Year_Items_Sold = percentageSales;
report.Percentage_Of_Prior_Year_Customers = percantageCustomers;
//Return the filled out report class.
return(report);
}
