public List <IProducerInfoDO> ViewAllProducers()
{
//create new list for producers VIEW ALL
List <IProducerInfoDO> viewList = new List <IProducerInfoDO>();
try
{
//create connection
using (SqlConnection connectionToSQL = new SqlConnection(connectionString))
//create a command
using (SqlCommand command = new SqlCommand("VIEW_ALL_PRODUCERS", connectionToSQL))
{
try
{
connectionToSQL.Open();
//use reader
SqlDataReader reader = command.ExecuteReader();
//reader pulls each row
while (reader.Read())
{
IProducerInfoDO producer = new ProducerDO();
producer.ProducerID = reader.GetInt64(0);
producer.CompanyName = reader.GetString(1);
producer.ContactName = reader.GetString(2);
producer.Phone = reader.GetString(3);
producer.Address = reader.GetString(4);
//after data is pulled from row, that object is added to list
viewList.Add(producer);
}
}
catch (Exception e)
{
//write error, if any, to file
ErrorLogging.LogError(e);
throw e;
}
finally
{
connectionToSQL.Close();
connectionToSQL.Dispose();
}
}
}
catch (Exception e)
{
ErrorLogging.LogError(e);
//throw up to presentation layer, then push to user
throw e;
}
finally
{
}
return(viewList);
}
public static IProducerInfoDO MapPOtoDO(ProducerPO iFrom)
{
IProducerInfoDO newproducer = new ProducerDO();
newproducer.ProducerID = iFrom.ProducerID;
newproducer.CompanyName = iFrom.CompanyName;
newproducer.ContactName = iFrom.ContactName;
newproducer.Address = iFrom.Address;
newproducer.Phone = iFrom.Phone;
return(newproducer);
}
public IProducerInfoDO ViewProducerByID(long ProducerID)
{
IProducerInfoDO viewProducer = new ProducerDO();
try
{
using (SqlConnection connectionToSQL = new SqlConnection(connectionString))
using (SqlCommand command = new SqlCommand("VIEW_PRODUCER_BY_ID", connectionToSQL))
{
try
{
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 35;
command.Parameters.AddWithValue("@ProducerID", ProducerID);
connectionToSQL.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
//map products from reader to interface object
viewProducer.ProducerID = reader.GetInt64(0);
viewProducer.CompanyName = reader.GetString(1);
viewProducer.ContactName = reader.GetString(2);
viewProducer.Phone = reader.GetString(3);
viewProducer.Address = reader.GetString(4);
}
}
catch (Exception e)
{
//write error to file and pass on to next level
ErrorLogging.LogError(e);
throw e;
}
finally
{
}
}
}
catch (Exception e)
{
ErrorLogging.LogError(e);
throw e;
}
finally
{
//nothing
}
return(viewProducer);
}
