private Dictionary <string, object> prepareGuitarParameters(clsGuitar prGuitar) { Dictionary <string, object> par = new Dictionary <string, object>(9); par.Add("serial_no", prGuitar.serial_no.ToString()); par.Add("guitar_type", prGuitar.guitar_type); par.Add("style", prGuitar.style); par.Add("price", prGuitar.price.ToString()); par.Add("quantity", prGuitar.quantity.ToString()); par.Add("tremolo", prGuitar.tremolo); par.Add("pickup", prGuitar.pickup); par.Add("electric", prGuitar.electric); par.Add("hollow", prGuitar.hollow); return(par); }
public List <clsGuitar> GetGuitars() { DataTable lcResult = clsDbConnection.GetDataTable("SELECT * FROM guitar", null); List <clsGuitar> lcNames = new List <clsGuitar>(); foreach (DataRow dr in lcResult.Rows) { clsGuitar lcGuitar = new clsGuitar(); lcGuitar.serial_no = (int)dr["serial_no"]; lcGuitar.guitar_type = (string)dr["guitar_type"]; lcGuitar.style = (string)dr["style"]; lcGuitar.price = (decimal)dr["price"]; lcGuitar.quantity = (int)dr["quantity"]; lcGuitar.tremolo = (string)dr["tremolo"].ToString(); lcGuitar.pickup = (string)dr["pickup"].ToString(); lcGuitar.electric = dr["electric"].ToString(); lcGuitar.hollow = dr["hollow"].ToString(); lcNames.Add(lcGuitar); } return(lcNames); }
public string PutGuitar(clsGuitar prGuitar) { // update try { int lcRecCount = clsDbConnection.Execute( "UPDATE guitar SET price = @price, quantity = @quantity, tremolo = @tremolo, pickup = @pickup, electric = @electric, hollow = @hollow WHERE serial_no = @serial_no", prepareGuitarParameters(prGuitar)); if (lcRecCount == 1) { return("One guitar updated"); } else { return("Unexpected guitar update count: " + lcRecCount); } } catch (Exception ex) { return(ex.GetBaseException().Message); } }
public string PostGuitar(clsGuitar prGuitar) { // insert try { int lcRecCount = clsDbConnection.Execute( "Insert Into guitar Values(@serial_no, @guitar_type, @style, @price, @quantity, @tremolo, @pickup, @electric, @hollow)", prepareGuitarParameters(prGuitar)); if (lcRecCount == 1) { return("One guitar inserted"); } else { return("Unexpected guitar insert count: " + lcRecCount); } } catch (Exception ex) { return(ex.GetBaseException().Message); } }