public Type810DetailTax ParseDetailTax(XElement element, IDictionary <string, XNamespace> namespaces)
{
XNamespace empty;
if (!namespaces.TryGetValue(string.Empty, out empty))
{
empty = XNamespace.None;
}
var model = new Type810DetailTax
{
AssignedId = element.GetChildText(empty + "AssignedId"),
MonetaryAmount = element.GetChildText(empty + "MonetaryAmount"),
Percent = element.GetChildText(empty + "Percent"),
RelationshipCode = element.GetChildText(empty + "RelationshipCode"),
DollarBasis = element.GetChildText(empty + "DollarBasis"),
TaxTypeCode = element.GetChildText(empty + "TaxTypeCode"),
JurisdictionCode = element.GetChildText(empty + "JurisdictionCode"),
JurisdictionCodeQualifier = element.GetChildText(empty + "JurisdictionCodeQualifier"),
ExemptCode = element.GetChildText(empty + "ExemptCode"),
Description = element.GetChildText(empty + "Description"),
};
return(model);
}
public Type810DetailTax[] ListDetailTaxes(int detailKey)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("csp810ExportDetailTax"))
{
command.AddWithValue("@DetailKey", detailKey);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
var collection = new List <Type810DetailTax>();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var item = new Type810DetailTax
{
DetailKey = detailKey,
TaxKey = reader.GetInt32("Tax_Key"),
};
reader.TryGetString("AssignedId", x => item.AssignedId = x);
reader.TryGetString("MonetaryAmount", x => item.MonetaryAmount = x);
reader.TryGetString("Percent", x => item.Percent = x);
reader.TryGetString("RelationshipCode", x => item.RelationshipCode = x);
reader.TryGetString("DollarBasis", x => item.DollarBasis = x);
reader.TryGetString("TaxTypeCode", x => item.TaxTypeCode = x);
reader.TryGetString("JurisdictionCode", x => item.JurisdictionCode = x);
reader.TryGetString("JurisdictionCodeQualifier", x => item.JurisdictionCodeQualifier = x);
reader.TryGetString("ExemptCode", x => item.ExemptCode = x);
reader.TryGetString("Description", x => item.Description = x);
collection.Add(item);
}
return(collection.ToArray());
}
}
}
public int InsertDetailTax(Type810DetailTax model)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("csp810DetailTaxInsert"))
{
SqlParameter keyParameter;
command.AddWithValue("@Detail_Key", model.DetailKey)
.AddWithValue("@AssignedId", model.AssignedId)
.AddWithValue("@MonetaryAmount", model.MonetaryAmount)
.AddWithValue("@Percent", model.Percent)
.AddWithValue("@RelationshipCode", model.RelationshipCode)
.AddWithValue("@DollarBasis", model.DollarBasis)
.AddWithValue("@TaxTypeCode", model.TaxTypeCode)
.AddWithValue("@TaxJurisdictionCodeQualifier", model.JurisdictionCodeQualifier)
.AddWithValue("@TaxJurisdictionCode", model.JurisdictionCode)
.AddWithValue("@ExemptCode", model.ExemptCode)
.AddWithValue("@Description", model.Description)
.AddOutParameter("@Tax_Key", SqlDbType.Int, out keyParameter);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.ExecuteNonQuery();
if (keyParameter.Value == null)
{
throw new Exception();
}
var taxKey = (int)keyParameter.Value;
model.TaxKey = taxKey;
return(taxKey);
}
}
public int InsertDetailTax(Type810DetailTax model)
{
return(-1);
}
