public static void Edit30DayHold(HoldItem oldItem, HoldItem newItem) { SqlCommand cmd = new SqlCommand("UPDATE " + TableNames._30DAYHOLD + " SET Name = '" + CheckForSpecialCharacters(newItem.name) + "', " + "System = '" + CheckForSpecialCharacters(newItem.system) + "', " + "Price = " + newItem.price + ", " + "Quantity = " + newItem.quantity + ", " + "TradeCash = " + newItem.tradeCash + ", " + "TradeCredit = " + newItem.tradeCredit + ", " + "UPC = " + newItem.UPC + ", " + "DATE = '" + newItem.dateIn + "'" + " WHERE Name = '" + CheckForSpecialCharacters(oldItem.name) + "' AND System = '" + CheckForSpecialCharacters(oldItem.system) + "' " + "AND PRICE = '" + oldItem.price + "' " + "AND TRADECASH = '" + oldItem.tradeCash + "' " + "AND TRADECREDIT = '" + oldItem.tradeCredit + "' " + "AND UPC = '" + oldItem.UPC + "' " + "AND DATE = '" + oldItem.dateIn + "'" , connect); // Find an exact match for the passed string, increase inventory try { connect.Open(); cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show("ERROR IN Edit30DayHold:\n" + e.Message); } finally { connect.Close(); } }
/// <summary> /// Creates a HoldItem based on data contained in an SqlDataReader /// </summary> /// <param name="reader">SqlDataReader containing data</param> /// <returns>A populated HoldItem</returns> public static HoldItem SQLReaderToHoldItem(SqlDataReader reader) { HoldItem item = null; item = new HoldItem(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString(), reader[6].ToString(), reader[7].ToString()); return item; }
public static void DeleteItemFrom30DayHold(HoldItem item) { SqlCommand cmd = new SqlCommand("DELETE FROM tbl30DayHold WHERE Name = '" + CheckForSpecialCharacters(item.name) + "' AND System = '" + CheckForSpecialCharacters(item.system) + "' AND Date = '" + item.dateIn + "'", connect); // Find an exact match for the passed string, delete item. try { connect.Open(); cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show("ERROR IN DeleteItemFrom30DayHold:\n" + e.Message); } finally { connect.Close(); } }