public Type824Reference[] ListReferences(int headerKey) { using (var connection = new SqlConnection(connectionString)) using (var command = connection.CreateCommand("esp_824ReferenceList")) { command.AddWithValue("@HeaderKey", headerKey); if (connection.State != ConnectionState.Open) { connection.Open(); } var collection = new List <Type824Reference>(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var item = new Type824Reference { HeaderKey = headerKey, ReferenceKey = reader.GetInt32("Reference_Key"), }; reader.TryGetString("AppAckCode", x => item.AppAckCode = x); reader.TryGetString("ReferenceQualifier", x => item.ReferenceQualifier = x); reader.TryGetString("ReferenceNbr", x => item.ReferenceNbr = x); reader.TryGetString("TransactionSetId", x => item.TransactionSetId = x); reader.TryGetString("CrossReferenceNbr", x => item.CrossReferenceNbr = x); reader.TryGetString("PurchaseOrderNbr", x => item.PurchaseOrderNbr = x); reader.TryGetString("PaymentsAppliedThroughDate", x => item.PaymentsAppliedThroughDate = x); reader.TryGetString("TotalPaymentsApplied", x => item.TotalPaymentsApplied = x); reader.TryGetString("PaymentDueDate", x => item.PaymentDueDate = x); reader.TryGetString("TotalAmountDue", x => item.TotalAmountDue = x); collection.Add(item); } return(collection.ToArray()); } } }
public int InsertReference(Type824Reference model) { using (var connection = new SqlConnection(connectionString)) using (var command = connection.CreateCommand("csp824ReferenceInsert")) { SqlParameter keyParameter; command.AddWithValue("@824_Key", model.HeaderKey) .AddWithValue("@AppAckCode", model.AppAckCode) .AddWithValue("@ReferenceQualifier", model.ReferenceQualifier) .AddWithValue("@ReferenceNbr", model.ReferenceNbr) .AddWithValue("@TransactionSetId", model.TransactionSetId) .AddWithValue("@CrossReferenceNbr", model.CrossReferenceNbr) .AddWithValue("@PurchaseOrderNbr", model.PurchaseOrderNbr) .AddWithValue("@PaymentsAppliedThroughDate", model.PaymentsAppliedThroughDate) .AddWithValue("@TotalPaymentsApplied", model.TotalPaymentsApplied) .AddWithValue("@PaymentDueDate", model.PaymentDueDate) .AddWithValue("@TotalAmountDue", model.TotalAmountDue) .AddOutParameter("@Reference_Key", SqlDbType.Int, out keyParameter); if (connection.State != ConnectionState.Open) { connection.Open(); } command.ExecuteNonQuery(); if (keyParameter.Value == null) { throw new Exception(); } var referenceKey = (int)keyParameter.Value; model.ReferenceKey = referenceKey; return(referenceKey); } }
public Type824Reference ParseReference(XElement element, IDictionary <string, XNamespace> namespaces) { XNamespace empty; if (!namespaces.TryGetValue(string.Empty, out empty)) { empty = XNamespace.None; } var model = new Type824Reference { AppAckCode = element.GetChildText(empty + "AppAckCode"), ReferenceQualifier = element.GetChildText(empty + "ReferenceQualifier"), ReferenceNbr = element.GetChildText(empty + "ReferenceNbr"), TransactionSetId = element.GetChildText(empty + "TransactionSetId"), CrossReferenceNbr = element.GetChildText(empty + "CrossReferenceNbr"), PurchaseOrderNbr = element.GetChildText(empty + "PurchaseOrderNbr"), PaymentsAppliedThroughDate = element.GetChildText(empty + "PaymentsAppliedThroughDate"), TotalPaymentsApplied = element.GetChildText(empty + "TotalPaymentsApplied"), PaymentDueDate = element.GetChildText(empty + "PaymentDueDate"), TotalAmountDue = element.GetChildText(empty + "TotalAmountDue"), }; var errorLoopElement = element.Element(empty + "TechErrorLoop"); if (errorLoopElement != null) { var errorElements = errorLoopElement.Elements(empty + "TechError"); foreach (var errorElement in errorElements) { var errorModel = ParseTechError(errorElement, namespaces); model.AddTechError(errorModel); } } return(model); }