public static Common.Models.Billing.Invoice Create( Common.Models.Billing.Invoice model, Common.Models.Account.Users creator, IDbConnection conn = null, bool closeConnection = true) { if (!model.Id.HasValue) { model.Id = Guid.NewGuid(); } model.CreatedBy = model.ModifiedBy = creator; model.Created = model.Modified = DateTime.UtcNow; DBOs.Billing.Invoice dbo = Mapper.Map <DBOs.Billing.Invoice>(model); conn = DataHelper.OpenIfNeeded(conn); conn.Execute("INSERT INTO \"invoice\" (\"id\", \"bill_to_contact_id\", \"date\", \"due\", " + "\"subtotal\", \"tax_amount\", \"total\", \"external_invoice_id\", \"bill_to_name_line_1\", " + "\"bill_to_name_line_2\", \"bill_to_address_line_1\", \"bill_to_address_line_2\", " + "\"bill_to_city\", \"bill_to_state\", \"bill_to_zip\", \"matter_id\", \"billing_group_id\", " + "\"utc_created\", \"utc_modified\", \"created_by_user_pid\", \"modified_by_user_pid\") " + "VALUES (@Id, @BillToContactId, @Date, @Due, @Subtotal, @TaxAmount, " + "@Total, @ExternalInvoiceId, @BillTo_NameLine1, @BillTo_NameLine2, @BillTo_AddressLine1, " + "@BillTo_AddressLine2, @BillTo_City, @BillTo_State, @BillTo_Zip, @MatterId, @BillingGroupId, " + "@UtcCreated, @UtcModified, @CreatedByUserPId, @ModifiedByUserPId)", dbo); DataHelper.Close(conn, closeConnection); return(model); }
public static void Delete( Common.Models.Billing.Invoice model, Common.Models.Account.Users deleter, IDbConnection conn = null, bool closeConnection = true) { DBOs.Billing.Invoice dbo = Mapper.Map <DBOs.Billing.Invoice>(model); conn = DataHelper.OpenIfNeeded(conn); conn.Execute("DELETE FROM \"invoice_expense\" WHERE \"invoice_id\"=@Id", dbo); conn.Execute("DELETE FROM \"invoice_fee\" WHERE \"invoice_id\"=@Id", dbo); conn.Execute("DELETE FROM \"invoice_time\" WHERE \"invoice_id\"=@Id", dbo); conn.Execute("DELETE FROM \"invoice\" WHERE \"id\"=@Id", dbo); DataHelper.Close(conn, closeConnection); }
public static Common.Models.Billing.Invoice Edit(Common.Models.Billing.Invoice model, Common.Models.Account.Users modifier, IDbConnection conn = null, bool closeConnection = true) { model.ModifiedBy = modifier; model.Modified = DateTime.UtcNow; DBOs.Billing.Invoice dbo = Mapper.Map <DBOs.Billing.Invoice>(model); conn = OpenIfNeeded(conn); conn.Execute("UPDATE \"invoice\" SET " + "\"bill_to_contact_id\"=@BillToContactId, \"date\"=@Date, \"due\"=@Due, \"subtotal\"=@Subtotal, \"tax_amount\"=@TaxAmount, " + "\"total\"=@Total, \"external_invoice_id\"=@ExternalInvoiceId, \"bill_to_name_line_1\"=@BillTo_NameLine1, \"bill_to_name_line_2\"=@BillTo_NameLine2, " + "\"bill_to_address_line_1\"=@BillTo_AddressLine1, \"bill_to_address_line_2\"=@BillTo_AddressLine2, \"bill_to_city\"=@BillTo_City, " + "\"bill_to_state\"=@BillTo_State, \"bill_to_zip\"=@BillTo_Zip, \"matter_id\"=@MatterId, \"billing_group_id\"=@BillingGroupId, " + "\"utc_modified\"=@UtcModified, \"modified_by_user_pid\"=@ModifiedByUserPId " + "WHERE \"id\"=@Id", dbo); Close(conn, closeConnection); return(model); }