public void ParseTax(Prism810Context context, string[] marketFields)
{
var current = context.Current;
if (current == null || current.ModelType != Type810Types.DetailItem)
{
throw new InvalidOperationException();
}
var detailItem = current as Type810DetailItem;
if (detailItem == null)
{
throw new InvalidOperationException();
}
var model = new Type810DetailItemTax
{
TaxTypeCode = marketFields.AtIndex(2),
TaxAmount = marketFields.AtIndex(3),
RelationshipCode = marketFields.AtIndex(6),
};
detailItem.AddTax(model);
}
public Type810DetailItemTax[] ListDetailItemTaxes(int detailItemKey)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("esp_810DetailItemTaxList"))
{
command.AddWithValue("@ItemKey", detailItemKey);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
var collection = new List <Type810DetailItemTax>();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var item = new Type810DetailItemTax
{
ItemKey = detailItemKey,
TaxKey = reader.GetInt32("Tax_Key"),
};
reader.TryGetString("TaxTypeCode", x => item.TaxTypeCode = x);
reader.TryGetString("TaxAmount", x => item.TaxAmount = x);
reader.TryGetString("RelationshipCode", x => item.RelationshipCode = x);
collection.Add(item);
}
return(collection.ToArray());
}
}
}
public Type810DetailItemTax[] ListDetailItemTaxesByHeader(int headerKey)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("csp810ExportTaxList"))
{
command.AddWithValue("@810Key", headerKey);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
var collection = new List <Type810DetailItemTax>();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var item = new Type810DetailItemTax
{
TaxKey = reader.GetInt32("Tax_Key"),
};
reader.TryGetString("ChargeIndicator", x => item.TaxTypeCode = x);
reader.TryGetString("ChargeCode", x => item.TaxAmount = x);
collection.Add(item);
}
return(collection.ToArray());
}
}
}
public Type810DetailItemTax ParseDetailItemTax(XElement element, IDictionary <string, XNamespace> namespaces)
{
XNamespace empty;
if (!namespaces.TryGetValue(string.Empty, out empty))
{
empty = XNamespace.None;
}
var model = new Type810DetailItemTax
{
TaxTypeCode = element.GetChildText(empty + "TaxTypeCode"),
TaxAmount = element.GetChildText(empty + "TaxAmount"),
RelationshipCode = element.GetChildText(empty + "RelationshipCode"),
};
return(model);
}
public int InsertDetailItemTax(Type810DetailItemTax model)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("csp810DetailItemTaxInsert"))
{
command.AddWithValue("@Item_Key", model.ItemKey)
.AddIfNotEmptyOrDbNull("@TaxTypeCode", model.TaxTypeCode)
.AddIfNotEmptyOrDbNull("@TaxAmount", model.TaxAmount)
.AddIfNotEmptyOrDbNull("@RelationshipCode", model.RelationshipCode);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.ExecuteNonQuery();
model.TaxKey = 1;
return(1);
}
}
