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); }