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); }