public bool deleteIVQRecord(IVQRecord IVQ)
{
SQL = "delete from invoice_queue ";
SQL += " WHERE elt_account_number = " + elt_account_number + " and queue_id="
+ IVQ.Queue_id;
Cmd = new SqlCommand(SQL, Con);
try
{
Con.Open();
Cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
Con.Close();
return(true);
}
public bool updateIVQRecord(IVQRecord IVQ)
{
IVQ.replaceQuote();
SQL = "update invoice_queue set ";
SQL += "invoiced= '" + IVQ.Invoiced + "' ";
SQL += " WHERE elt_account_number = " + elt_account_number + " and queue_id="
+ IVQ.Queue_id;
Cmd = new SqlCommand(SQL, Con);
try
{
Con.Open();
Cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
Con.Close();
return(true);
}
