public int InvoiceInsert(AdminInvoiceRequestModel model)
{
int uid = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Invoice_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@ClientId", model.ClientId);
paramCollection.AddWithValue("@QuoteAccepted", model.QuoteAccepted);
paramCollection.AddWithValue("@Price", model.Price);
paramCollection.AddWithValue("@FileNumber", model.FileNumber);
paramCollection.AddWithValue("@ProductDescription", model.ProductDescription);
SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int);
p.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(p);
}, returnParameters : delegate(SqlParameterCollection param)
{
int.TryParse(param["@Id"].Value.ToString(), out uid);
});
InsertInvoiceLineItems(uid, model.LineItems);
return(uid);
}
public void AcceptQuote(AdminInvoiceRequestModel model)
{
DataProvider.ExecuteNonQuery(GetConnection, "dbo.InvoiceQuotes_Update"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", model.Id);
paramCollection.AddWithValue("@QuoteAccepted", model.QuoteAccepted);
});
}
public void QuoteRevisedUpdateStatus(int Id, AdminInvoiceRequestModel model)
{
DataProvider.ExecuteNonQuery(GetConnection, "dbo.InvoiceRevisedQuote_Update"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", model.CurrentInvoice);
paramCollection.AddWithValue("@Status", model.Status);
paramCollection.AddWithValue("@ReplacedBy", Id);
});
}
public void UpdateInvoice(AdminInvoiceRequestModel model)
{
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Invoice_Update"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", model.Id);
paramCollection.AddWithValue("@ClientId", model.ClientId);
paramCollection.AddWithValue("@QuoteAccepted", model.QuoteAccepted);
paramCollection.AddWithValue("@Price", model.Price);
});
UpdateInvoiceLineItems(model.Id, model.LineItems);
}
