public int InsertPayment(Type810Payment model)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("csp810PaymentInsert"))
{
SqlParameter keyParameter;
command.AddWithValue("@810_Key", model.HeaderKey)
.AddWithValue("@AmountQualifierCode", model.AmountQualifierCode)
.AddWithValue("@MonetaryAmount", model.MonetaryAmount)
.AddWithValue("@TimeUnit", model.TimeUnit)
.AddWithValue("@DateTimeQualifier", model.DateTimeQualifier)
.AddWithValue("@Date", model.Date)
.AddOutParameter("@Payment_Key", SqlDbType.Int, out keyParameter);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.ExecuteNonQuery();
if (keyParameter.Value == null)
{
throw new Exception();
}
var paymentKey = (int)keyParameter.Value;
model.PaymentKey = paymentKey;
return(paymentKey);
}
}
public Type810Payment ParsePayment(XElement element, IDictionary <string, XNamespace> namespaces)
{
XNamespace empty;
if (!namespaces.TryGetValue(string.Empty, out empty))
{
empty = XNamespace.None;
}
var model = new Type810Payment
{
AmountQualifierCode = element.GetChildText(empty + "AmountQualifierCode"),
MonetaryAmount = element.GetChildText(empty + "MonetaryAmount"),
TimeUnit = element.GetChildText(empty + "TimeUnit"),
DateTimeQualifier = element.GetChildText(empty + "DateTimeQualifier"),
Date = element.GetChildText(empty + "Date"),
};
return(model);
}
public int InsertPayment(Type810Payment model)
{
return(-1);
}
