/// <summary>
/// Returns a single invoice
/// </summary>
/// <param name="invoiceNumber">Invoice Number</param>
/// <returns>Invoice</returns>
public static Invoice GetInvoice(string invoiceNumber)
{
try
{
Invoice tempInvoice = new Invoice();
tempInvoice.iInvoiceNumber = invoiceNumber;
using (OleDbConnection conn = new OleDbConnection(sConnectionString))
{
using (OleDbDataAdapter adapter = new OleDbDataAdapter())
{
conn.Open();
OleDbDataReader reader = null;
OleDbCommand command = new OleDbCommand("SELECT * from INVOICE " +
"WHERE InvoiceNumber = ?", conn);
command.Parameters.AddWithValue("InvoiceNumber", invoiceNumber);
reader = command.ExecuteReader();
while (reader.Read())
{
tempInvoice.sCustomerNumber = reader[1].ToString();
tempInvoice.sInvoiceDate = Convert.ToDateTime(reader[2]);
}
}
}
tempInvoice.cCustomer = DACustomer.GetCustomer(Convert.ToInt32(tempInvoice.sCustomerNumber));
tempInvoice.lItemList = GetInvoiceItems(invoiceNumber);
tempInvoice.calcTotal();
return(tempInvoice);
}
catch (Exception ex)
{
Exceptions.Spool(ex);
return(null);
}
}
public DataTable ViewProfile(string userid)
{
DataTable dt;
DAUser DA = new DAUser();
dt = DA.GetUserTypeById(userid);
if (dt.Rows.Count > 0)
{
if (Convert.ToInt32(dt.Rows[0]["USER_TYPE_ID"]) == (int)Enumaration.UserType.Student)
{
DACustomer DAC = new DACustomer();
DataTable customer = DAC.GetCustomer(dt.Rows[0]["ID"].ToString(), dt.Rows[0]["REFERENCE_TYPE_ID"].ToString());
dt = customer;
}
}
return(dt);
}
