public List <VendorDocument> ExecuteVendorDocumentFind(string queryText) { string connectionString = ConfigurationManager.AppSettings["SQLConnectionString"]; using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryText, conn); conn.Open(); SqlDataAdapter da = new SqlDataAdapter(command); DataTable dt = new DataTable(); da.Fill(dt); conn.Close(); da.Dispose(); List <VendorDocument> vendorDocuments = new List <VendorDocument>(); foreach (DataRow row in dt.Rows) { VendorDocument document = new VendorDocument() { ContactID = row["ContactID"].ToString(), ContactName = row["ContactName"].ToString(), Category = row["Category"].ToString(), Filename = row["Filename"].ToString(), PublicID = row["PublicID"].ToString(), SPID = row["SPID"].ToString(), Status = row["Status"].ToString(), Subcategory = row["Subcategory"].ToString(), Description = row["Description"].ToString(), }; vendorDocuments.Add(document); } return(vendorDocuments); } }
public VendorDocument GetVendorDocumentByPublicID(string PublicID) { string connectionString = ConfigurationManager.AppSettings["SQLConnectionString"]; string queryText = ConfigurationManager.AppSettings["BaseVendorDocumentSelectStatement"]; queryText += " AND (Doc.PublicID = '" + PublicID + "')"; queryText += " ORDER BY Doc.PublicID desc"; using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryText, conn); conn.Open(); SqlDataAdapter da = new SqlDataAdapter(command); DataTable dt = new DataTable(); da.Fill(dt); conn.Close(); da.Dispose(); VendorDocument matchingDocument = new VendorDocument(); if (dt.Rows.Count > 0) { matchingDocument.ContactID = dt.Rows[0]["ContactID"].ToString(); matchingDocument.ContactName = dt.Rows[0]["ContactName"].ToString(); matchingDocument.Category = dt.Rows[0]["Category"].ToString(); matchingDocument.Filename = dt.Rows[0]["Filename"].ToString(); matchingDocument.PublicID = dt.Rows[0]["PublicID"].ToString(); matchingDocument.SPID = dt.Rows[0]["SPID"].ToString(); matchingDocument.Status = dt.Rows[0]["Status"].ToString(); matchingDocument.Subcategory = dt.Rows[0]["Subcategory"].ToString(); matchingDocument.Description = dt.Rows[0]["Description"].ToString(); return(matchingDocument); } return(null); } }