/// <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)); }