/// <summary>
/// Handles the delete item button being clicked
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdDeleteItem_Click(object sender, RoutedEventArgs e)
{
try
{
if (listItems.SelectedItem != null)
{
int total = 0;
int itemCost = 0;
clsItem item = (clsItem)listItems.SelectedItem;
if (listItems.Items.Count == 1)
{
listItems.Items.Clear();
}
else
{
listItems.Items.Remove(item);
}
Int32.TryParse(txtCost.Text, out total);
Int32.TryParse(item.Cost, out itemCost);
total -= itemCost;
txtCost.Text = total.ToString();
}
}
catch (Exception ex)
{
throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message);
}
}
DataSet ds; // Dataset to hold the returned data from queries
/// <summary>
/// Returns the full list of jewelry items from the database
/// </summary>
/// <returns></returns>
public ObservableCollection<clsItem> itemsCollection()
{
try
{
db = new clsDataAccess();
ObservableCollection<clsItem> col_Items = new ObservableCollection<clsItem>();
string sSQL; //Holds an SQL statement
int iRet = 0; //Number of return values
ds = new DataSet(); //Holds the return values
clsItem items; //Used to load the return values into the combo box
sSQL = "SELECT ItemCode, ItemDesc, Cost " + "FROM ItemDesc";
ds = db.ExecuteSQLStatement(sSQL, ref iRet);
//Creates item objects based on the data pulled from the query than adds the object to a list
for (int i = 0; i < iRet; i++)
{
items = new clsItem();
items.ItemCode = ds.Tables[0].Rows[i][0].ToString();
items.ItemDesc = ds.Tables[0].Rows[i]["ItemDesc"].ToString();
items.Cost = ds.Tables[0].Rows[i]["Cost"].ToString();
col_Items.Add(items);
}
return col_Items;
}
catch (Exception ex)
{
throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message);
}
}
public ObservableCollection<clsItem> itemsCollection()
{
clsDataAccess db;
ObservableCollection<clsItem> col_Items;
db = new clsDataAccess();
string sSQL; //Holds an SQL statement
int iRet = 0; //Number of return values
DataSet ds = new DataSet(); //Holds the return values
clsItem items; //Used to load the return values into the combo box
sSQL = "SELECT ItemCode, ItemDesc, Cost " + "FROM ItemDesc";
col_Items = new ObservableCollection<clsItem>();
ds = db.ExecuteSQLStatement(sSQL, ref iRet);
//Creates Flight objects based on the data pulled from the query than adds the object to a list
for (int i = 0; i < iRet; i++)
{
items = new clsItem();
items.ItemCode = ds.Tables[0].Rows[i][0].ToString();
items.ItemDesc = ds.Tables[0].Rows[i]["ItemDesc"].ToString();
items.Cost = ds.Tables[0].Rows[i]["Cost"].ToString();
col_Items.Add(items);
}
return col_Items;
}
private void cmdDeleteItem_Click(object sender, RoutedEventArgs e)
{
try
{
if (boxListItem.SelectedItem != null)
{
clsItem currentItem = (clsItem)boxListItem.SelectedItem;
String sItemCode = currentItem.ItemCode;
clsLineItem line;
DataSet ds = new DataSet();
int iRet = 0;
String sSQLCheck = "SELECT * FROM LineItems WHERE ItemCode = '" + sItemCode + "'";
ds = db.ExecuteSQLStatement(sSQLCheck, ref iRet);
if (iRet == 0)
{
String sSQL = "Delete FROM ItemDesc " +
"Where ItemCode = '" + sItemCode + "'";
db.ExecuteNonQuery(sSQL);
boxListItem.Items.Clear();
UpdateBox();
txtName.Text = "";
txtDesc.Text = "";
txtCost.Text = "";
}
else
{
//Following LineItem info added by JD
//DISPLAY THE INVOICES THAT THIS ITEM IS A PART OF
line = new clsLineItem();
//StatusLabel
statusLabel.Content = "That item can't be deleted because it is on the following invoices: ";
for (int i = 0; i < iRet; i++)
{
//Get the InvoiceNum and add it on to StatusLabel based on the ItemCode
line.InvoiceNum = ds.Tables[0].Rows[i][0].ToString();
//statusLabel.Content + InvoiceNum
statusLabelInvoice.Content = statusLabelInvoice.Content + " " + line.InvoiceNum;
}
}
}
else
{
statusLabel.Content = "Please select an item to delete";
}
}
catch (Exception ex)
{
throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message);
}
}
private void selectedItemChanged(object sender, SelectionChangedEventArgs e)
{
clsItem item = new clsItem();
item = (clsItem)boxListItem.SelectedItem;
if (item != null)
{
txtName.Text = item.ItemCode;
txtDesc.Text = item.ItemDesc;
txtCost.Text = item.Cost;
statusLabel.Content = "";
}
}
/// <summary>
/// Handles the add item button being clicked
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdAdd_Click(object sender, RoutedEventArgs e)
{
try
{
if (selectItem.SelectedItem != null)
{
int total = 0;
int itemCost = 0;
clsItem item = (clsItem)selectItem.SelectedItem;
listItems.Items.Add(item);
Int32.TryParse(txtCost.Text, out total);
Int32.TryParse(item.Cost, out itemCost);
total += itemCost;
txtCost.Text = total.ToString();
}
}
catch (Exception ex)
{
throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message);
}
}
public void UpdateBox()
{
string sSQL; //Holds an SQL statement
int iRet = 0; //Number of return values
DataSet ds = new DataSet();
clsItem item;
sSQL = "SELECT ItemCode, ItemDesc, Cost " +
"FROM ItemDesc";
ds = db.ExecuteSQLStatement(sSQL, ref iRet);
for (int i = 0; i < iRet; i++)
{
item = new clsItem();
item.ItemCode = ds.Tables[0].Rows[i][0].ToString();
item.ItemDesc = ds.Tables[0].Rows[i]["ItemDesc"].ToString();
item.Cost = ds.Tables[0].Rows[i]["Cost"].ToString();
boxListItem.Items.Add(item);
}
}
public void UpdateBox()
{
string sSQL; //Holds an SQL statement
int iRet = 0; //Number of return values
DataSet ds = new DataSet();
clsItem item;
sSQL = "SELECT ItemCode, ItemDesc, Cost " +
"FROM ItemDesc";
ds = db.ExecuteSQLStatement(sSQL, ref iRet);
for (int i = 0; i < iRet; i++)
{
item = new clsItem();
item.ItemCode = ds.Tables[0].Rows[i][0].ToString();
item.ItemDesc = ds.Tables[0].Rows[i]["ItemDesc"].ToString();
item.Cost = ds.Tables[0].Rows[i]["Cost"].ToString();
boxListItem.Items.Add(item);
}
}
/// <summary>
/// Returns the collection of items from a certain invoice
/// </summary>
/// <param name="invoiceNumber"></param>
/// <returns></returns>
public ObservableCollection<clsItem> invoiceItems(string invoiceNumber)
{
try
{
db = new clsDataAccess();
ObservableCollection<clsItem> col_Items = new ObservableCollection<clsItem>();
List<string> itemCode = new List<string>();
string sSQL; //Holds an SQL statement
int iRet = 0; //Number of return values
ds = new DataSet(); //Holds the return values
clsItem items; //Used to load the return values into the combo box
sSQL = "SELECT ItemCode FROM LineItems "
+ "WHERE InvoiceNum = " + invoiceNumber;
ds = db.ExecuteSQLStatement(sSQL, ref iRet);
// adds all of the different item codes on the invoice to a list
for (int i = 0; i < iRet; i++)
{
itemCode.Add(ds.Tables[0].Rows[i]["ItemCode"].ToString());
}
if (itemCode.Count > 0)
{
foreach (string code in itemCode)
{
sSQL = "SELECT ItemCode, ItemDesc, Cost FROM ItemDesc "
+ "WHERE ItemCode = '" + code + "'";
ds = db.ExecuteSQLStatement(sSQL, ref iRet);
items = new clsItem();
items.ItemCode = ds.Tables[0].Rows[0][0].ToString();
items.ItemDesc = ds.Tables[0].Rows[0]["ItemDesc"].ToString();
items.Cost = ds.Tables[0].Rows[0]["Cost"].ToString();
col_Items.Add(items);
}
}
return col_Items;
}
catch (Exception ex)
{
throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message);
}
}
