private static void AddParameters(InvoiceItem invoiceItem, SqlCommand comm)
{
comm.Parameters.AddWithValue("ClientSessionID", invoiceItem.ClientSessionID);
comm.Parameters.AddWithValue("InvoiceID", invoiceItem.InvoiceID);
}
public static InvoiceItem ReadInvoiceItem(SqlDataReader reader)
{
InvoiceItem invoiceItem = new InvoiceItem();
invoiceItem.clientSession = ClientSession.ReadClientSession(reader);
invoiceItem.invoice = Invoice.ReadInvoice(reader);
return invoiceItem;
}
public static int RemoveInvoiceItem(InvoiceItem oldInvoiceItem)
{
int rowsAffected = 0;
// Setup Connection
using (DatabaseConnection db = new DatabaseConnection("dbo.RemoveInvoiceItem"))
{
// Set Parameters
AddOldParameters(oldInvoiceItem, db.comm);
// Open Connection
db.conn.Open();
// Execute Command and Read Response
rowsAffected = db.comm.ExecuteNonQuery();
}
return rowsAffected;
}
public static int AddInvoiceItem(InvoiceItem invoiceItem)
{
int invoiceItemID = -1;
// Setup Connection
using (DatabaseConnection db = new DatabaseConnection("dbo.AddInvoiceItem"))
{
// Set Parameters
AddParameters(invoiceItem, db.comm);
// Open Connection
db.conn.Open();
// Execute Command and Read Response
invoiceItemID = Convert.ToInt32(db.comm.ExecuteScalar());
}
return invoiceItemID;
}