public PgInstrumentDetail(InstrumentVm instrument, IInstrumentManager instrumentManager, bool editMode = false) { InitializeComponent(); _instrumentManager = instrumentManager; _instrument = instrument; _editMode = false; _editMode = editMode; }
public List <InstrumentVm> SelectInstrumentsByStatus(string status) { List <InstrumentVm> instruments = new List <InstrumentVm>(); var conn = DbConnection.GetConnection(); var cmd = new SqlCommand("sp_select_instruments_by_status", conn) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@Status", status); try { conn.Open(); var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { InstrumentVm newInstrument = new InstrumentVm { InstrumentId = reader.GetString(0), InstrumentTypeId = reader.GetString(1), InstrumentFamily = reader.GetString(2), InstrumentStatusId = reader.GetString(3), InstrumentBrandId = reader.GetString(4), Price = reader.GetDecimal(5), RentalTermId = reader.GetString(6), RentalFee = reader.GetDecimal(7), PrepListDescription = reader.GetString(8) }; instruments.Add(newInstrument); } } } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(instruments); }
public List <InstrumentVm> SelectAllInCart() { List <InstrumentVm> instruments = new List <InstrumentVm>(); var conn = DbConnection.GetConnection(); var cmd = new SqlCommand("sp_select_all_in_cart", conn) { CommandType = CommandType.StoredProcedure }; try { conn.Open(); var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { InstrumentVm newInstrument = new InstrumentVm { InstrumentId = reader.GetString(0), InstrumentTypeId = reader.GetString(1), InstrumentStatusId = reader.GetString(3), InstrumentBrandId = reader.GetString(4), Price = reader.GetDecimal(5), RentalTermId = reader.GetString(6), RentalFee = reader.GetDecimal(7), }; instruments.Add(newInstrument); } } } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(instruments); }