public List <instrumentsDAO> GetAllInstruments()
{
List <instrumentsDAO> _instrumentslist = new List <instrumentsDAO>();
try
{
using (SqlConnection _connection = new SqlConnection(connectionstring))
{
using (SqlCommand _command = new SqlCommand("Sp_ViewInstruments", _connection))
{
_command.CommandType = CommandType.StoredProcedure;
_connection.Open();
using (SqlDataReader _reader = _command.ExecuteReader())
{
while (_reader.Read())
{
instrumentsDAO _instrumentsToList = new instrumentsDAO();
_instrumentsToList.Instruments_ID = _reader.GetInt32(0);
_instrumentsToList.InstrumentName = _reader.GetString(1);
_instrumentsToList.InstrumentDescription = _reader.GetString(2);
_instrumentsToList.InstrumentPrice = _reader.GetDecimal(3);
_instrumentsToList.InstrumentsQuantity = _reader.GetInt32(4);
_instrumentslist.Add(_instrumentsToList);
}
}
}
}
}
catch (Exception _Error)
{
Error_Logger Log = new Error_Logger();
Log.Errorlogger(_Error);
}
return(_instrumentslist);
}
public void CreateInstruments(instrumentsDAO instrumentsToCreate)
{
try
{
using (SqlConnection _connection = new SqlConnection(connectionstring))
{
using (SqlCommand _command = new SqlCommand("Sp_CreateInstrument", _connection))
{
_command.CommandType = CommandType.StoredProcedure;
_command.Parameters.AddWithValue("@Name", instrumentsToCreate.InstrumentName);
_command.Parameters.AddWithValue("@Description", instrumentsToCreate.InstrumentDescription);
_command.Parameters.AddWithValue("@Price", instrumentsToCreate.InstrumentPrice);
_command.Parameters.AddWithValue("@InstrumentsQuantity", instrumentsToCreate.InstrumentsQuantity);
_connection.Open();
_command.ExecuteNonQuery();
_connection.Close();
_connection.Dispose();
}
}
}
catch (Exception _Error)
{
Error_Logger Log = new Error_Logger();
Log.Errorlogger(_Error);
}
}
public bool DeleteInstruments(instrumentsDAO instrumentToDelete)
{
bool yes = false;
try
{
using (SqlConnection _connection = new SqlConnection(connectionstring))
{
using (SqlCommand _command = new SqlCommand("Sp_DeleteInstrument", _connection))
{
_command.CommandType = CommandType.StoredProcedure;
_command.Parameters.AddWithValue("@Instruments_ID", instrumentToDelete.Instruments_ID);
_connection.Open();
_command.ExecuteNonQuery();
yes = true;
_connection.Close();
}
}
}
catch (Exception _Error)
{
Error_Logger Log = new Error_Logger();
Log.Errorlogger(_Error);
}
if (yes == true)
{
}
return(yes);
}