public int InsertBalance(Type810Balance model)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("csp810BalanceInsert"))
{
SqlParameter keyParameter;
command.AddWithValue("@810_Key", model.HeaderKey)
.AddWithValue("@TotalOutstandingBalance", model.TotalOutstandingBalance)
.AddWithValue("@BeginningBalance", model.BeginningBalance)
.AddWithValue("@BudgetCumulativeDifference", model.BudgetCumulativeDifference)
.AddWithValue("@BudgetMonthDifference", model.BudgetMonthDifference)
.AddOutParameter("@Balance_Key", SqlDbType.Int, out keyParameter);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.ExecuteNonQuery();
if (keyParameter.Value == null)
{
throw new Exception();
}
var balanceKey = (int)keyParameter.Value;
model.BalanceKey = balanceKey;
return(balanceKey);
}
}
public Type810Balance ParseBalance(XElement element, IDictionary <string, XNamespace> namespaces)
{
XNamespace empty;
if (!namespaces.TryGetValue(string.Empty, out empty))
{
empty = XNamespace.None;
}
var model = new Type810Balance
{
TotalOutstandingBalance = element.GetChildText(empty + "TotalOutstandingBalance"),
BeginningBalance = element.GetChildText(empty + "BeginningBalance"),
BudgetCumulativeDifference = element.GetChildText(empty + "BudgetCumulativeDifference"),
BudgetMonthDifference = element.GetChildText(empty + "BudgetMonthDifference"),
BudgetBilledToDate = element.GetChildText(empty + "BudgetBilledToDate"),
ActualBilledToDate = element.GetChildText(empty + "ActualBilledToDate"),
};
return(model);
}
public Type810Balance[] ListBalances(int headerKey)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("esp_810BalanceList"))
{
command.AddWithValue("@HeaderKey", headerKey);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
var collection = new List <Type810Balance>();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var item = new Type810Balance
{
HeaderKey = headerKey,
BalanceKey = reader.GetInt32("Balance_Key"),
};
reader.TryGetString("TotalOutstandingBalance", x => item.TotalOutstandingBalance = x);
reader.TryGetString("BeginningBalance", x => item.BeginningBalance = x);
reader.TryGetString("BudgetCumulativeDifference", x => item.BudgetCumulativeDifference = x);
reader.TryGetString("BudgetMonthDifference", x => item.BudgetMonthDifference = x);
reader.TryGetString("BudgetBilledToDate", x => item.BudgetBilledToDate = x);
reader.TryGetString("ActualBilledToDate", x => item.ActualBilledToDate = x);
collection.Add(item);
}
return(collection.ToArray());
}
}
}
public int InsertBalance(Type810Balance model)
{
return(-1);
}
