public InvoiceCompleted(int invoiceID)
{
InitializeComponent();
invoice = new Invoice(invoiceID);
invoiceContentsList = InvoiceContentsDatabase.GetInvoiceContents(invoiceID);
this.customerID = invoice.customer.StoreID;
Customer c = CustomerDatabase.SearchCustomersByID(customerID);
ProvinceTax provinceTax = ProvinceTaxDatabase.GetProvinceByName(c.Province);
if (provinceTax.pst == 0)
{
PST = false;
}
else
{
PST = true;
}
panel1.Location = new Point(30, 135);
panel1.Size = new Size(900, 360);
panel1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
panel1.AutoScroll = true;
panel1.BackColor = Color.DarkGray;
this.Controls.Add(panel1);
AddLabels(customerID);
AddTotalBoxes(customerID);
AddItemBoxes();
}
public Invoice(int invoiceID)
{
// WholeSale Company Information
CompanyName = "Great West Wholesale LTD";
CompanyAddress = "1670 PANDORA ST. VANCOUVER, BC V5L 1L6";
CompanyPhoneNumber = "604-255-9588";
CompanyFax = "604-255-9589";
CompanyTollFree = "1-800-901-9588";
GSTNo = "R102186178";
Items = new List <Product>();
MySqlConnection conn = new MySqlConnection(LoginInfo.LoginCreds);
try
{
conn.Open();
MySqlCommand cmd;
MySqlDataReader rdr;
String sql;
sql = "SELECT * FROM Invoices WHERE InvoiceID = " + invoiceID + ";";
cmd = new MySqlCommand(sql, conn);
rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
InvoiceID = Int32.Parse(rdr[0].ToString());
customer = CustomerDatabase.SearchCustomersByID(Int32.Parse(rdr[1].ToString()));
PurchaseOrder = rdr[2].ToString();
List <InvoiceContentInfo> items = InvoiceContentsDatabase.GetInvoiceContents(InvoiceID);
Product temp;
for (int i = 0; i < items.Count; i++)
{
temp = ProductDatabase.SearchProductByItemNo(items[i].ItemNo);
temp.SpecialNotes = items[i].SpecialNotes;
temp.Quantity = items[i].Quantity;
temp.BackOrder = items[i].Backorder;
temp.BackOrderSpecialNotes = items[i].BackOrderSpecialNotes;
Items.Add(temp);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
conn.Close();
}
public Invoice(int invoiceID)
{
// WholeSale Company Information
CompanyName = "Great West Wholesale LTD";
CompanyAddress = "1670 PANDORA ST. VANCOUVER, BC V5L 1L6";
CompanyPhoneNumber = "604-255-9588";
CompanyFax = "604-255-9589";
CompanyTollFree = "1-800-901-9588";
GSTNo = "R102186178";
Items = new List <Product>();
String pswd = "password";
String user = "******";
String connStr = "server=localhost;user="******";database=GWW;port=3306;password="******"SELECT * FROM Invoices WHERE InvoiceID = " + invoiceID + ";";
cmd = new MySqlCommand(sql, conn);
rdr = cmd.ExecuteReader();
//InvoiceID | StoreID | PurchaseOrder | SpecialNotes | InvoiceNo | SubTotal | Gst | Pst | NetTotal | Stage |
if (rdr.HasRows)
{
rdr.Read();
InvoiceID = Int32.Parse(rdr[0].ToString());
customer = CustomerDatabase.SearchCustomersByID(Int32.Parse(rdr[1].ToString()));
CustomerName = customer.StoreName;
CustomerContact = customer.StoreContact;
CustomerAddress = customer.ShippingAddress;
CustomerPhone = customer.PhoneNumber;
CustomerTerms = customer.PaymentTerms;
CustomerShippingTerms = customer.ShippingInstructions;
PurchaseOrder = rdr[2].ToString();
SpecialNotes = rdr[3].ToString();
BackorderNotes = rdr[4].ToString();
InvoiceNo = rdr[5].ToString();
SubTotal = Single.Parse(rdr[6].ToString());
Gst = Single.Parse(rdr[7].ToString());
Pst = Single.Parse(rdr[8].ToString());
NetTotal = Single.Parse(rdr[9].ToString());
freight = Single.Parse(rdr[10].ToString());
Stage = Int32.Parse(rdr[11].ToString());
List <InvoiceContentInfo> items = InvoiceContentsDatabase.GetInvoiceContents(InvoiceID);
Product temp;
for (int i = 0; i < items.Count; i++)
{
temp = ProductDatabase.SearchProductByItemNo(items[i].ItemNo);
temp.SpecialNotes = items[i].SpecialNotes;
temp.Quantity = items[i].Quantity;
temp.BackOrder = items[i].Backorder;
temp.BackOrderSpecialNotes = items[i].BackOrderSpecialNotes;
Items.Add(temp);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
conn.Close();
}
