/// <summary>
/// method to save items to the databse
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public static bool SaveToDatabase(clsItemsLogic item)
{
using (OleDbConnection db = clsItemsSQL.GetConnection())
{
db.Open();
clsItemsSQL sql = new clsItemsSQL();
OleDbCommand command = new OleDbCommand(sql.saveitem(), db);
command.Parameters.Add(new OleDbParameter("@ItemCode", item.ItemCode));
command.Parameters.Add(new OleDbParameter("@ItemDesc", item.ItemDesc));
command.Parameters.Add(new OleDbParameter("@Cost", item.ItemPrice));
return((command.ExecuteNonQuery() == 0) ? false : true);
}
}
private void ItemDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (ItemDataGrid.SelectedValue == null)
{
return;
}
clsItemsLogic it = (clsItemsLogic)ItemDataGrid.SelectedValue;
TextBoxCode.IsReadOnly = true;
TextBoxCode.Text = it.ItemCode;
TextBoxDesc.Text = it.ItemDesc;
TextBoxCost.Text = it.ItemPrice.ToString();
}
private void ButtonSave_Click(object sender, RoutedEventArgs e)
{
clsItemsLogic it = new clsItemsLogic();
it.ItemCode = TextBoxCode.Text;
it.ItemDesc = TextBoxDesc.Text;
it.ItemPrice = Convert.ToDecimal(TextBoxCost.Text);
if (clsItemsLogic.UpdateItem(it))
{
MessageBox.Show("item Updated");
Clear();
Onload();
}
else
{
MessageBox.Show("Item not updated");
}
}
/// <summary>
/// method to update datebase items
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public static bool UpdateItem(clsItemsLogic item)
{
if (item.ItemCode == null)
{
return(false);
}
using (OleDbConnection db = clsItemsSQL.GetConnection())
{
db.Open();
clsItemsSQL sql = new clsItemsSQL();
OleDbCommand command = new OleDbCommand(sql.update(), db);
command.Parameters.AddRange(new OleDbParameter[] {
new OleDbParameter("@Items", item.ItemDesc),
new OleDbParameter("@Cost", item.ItemPrice),
new OleDbParameter("@ItemCode", item.ItemCode)
});
return((command.ExecuteNonQuery() == 0) ? false : true);
}
}
/// <summary>
/// overloaded delete item method
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public static bool DeleteItem(clsItemsLogic item)
{
return(DeleteItem(item.ItemCode));
}
