public CustPastPurchaseReport(string choice)
{
InitializeComponent();
string query;
if (choice.Equals("item"))
{
query = "SELECT bcpark354.OrderDetail.ItemID, bcpark354.PurchaseOrder.CustomerID, bcpark354.PurchaseOrder.OrderID, bcpark354.PurchaseOrder.OrderDate, bcpark354.OrderDetail.Qty FROM bcpark354.PurchaseOrder INNER JOIN bcpark354.OrderDetail ON bcpark354.PurchaseOrder.OrderID=bcpark354.OrderDetail.OrderID WHERE bcpark354.PurchaseOrder.CustomerID = " + Program.custID + " ORDER BY bcpark354.OrderDetail.ItemID";
DBConnect con = new DBConnect();
con.OpenConnection();
SqlDataReader Data = con.getData(query);
List <string> purchases = new List <string>();
try
{
while (Data.Read())
{
purchases.Add("ItemID: " + Data["ItemID"] + " -OrderID: " + Data["OrderID"] + " -CustomerID: " + Data["CustomerID"] + " -OrderDate: " + Data["OrderDate"] + " -Quantity: " + Data["Qty"]);
}
listBox1.DataSource = purchases;
}
catch (Exception a)
{
MessageBox.Show(a.Message, "Failed to Produce Report", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
else if (choice.Equals("dates"))
{
query = "SELECT bcpark354.PurchaseOrder.OrderDate, bcpark354.OrderDetail.ItemID, bcpark354.PurchaseOrder.CustomerID, bcpark354.PurchaseOrder.OrderID, bcpark354.OrderDetail.Qty FROM bcpark354.PurchaseOrder INNER JOIN bcpark354.OrderDetail ON bcpark354.PurchaseOrder.OrderID=bcpark354.OrderDetail.OrderID WHERE bcpark354.PurchaseOrder.CustomerID = " + Program.custID + " ORDER BY bcpark354.PurchaseOrder.DeliveryDate";
DBConnect con = new DBConnect();
con.OpenConnection();
SqlDataReader Data = con.getData(query);
List <string> purchases = new List <string>();
try
{
while (Data.Read())
{
purchases.Add("OrderDate: " + Data["OrderDate"] + " -ItemID: " + Data["ItemID"] + " -CustomerID: " + Data["CustomerID"] + " -OrderID: " + Data["OrderID"] + " -Quantity: " + Data["Qty"]);
}
listBox1.DataSource = purchases;
}
catch (Exception a)
{
MessageBox.Show(a.Message, "Failed to Produce Report", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Equals("9999"))
{
Admin next = new Admin();
MessageBox.Show("Welcome Admin");
next.Show();
this.Hide();
}
else if (textBox1.TextLength > 4)
{
MessageBox.Show(textBox1.Text, "Incorrect Input", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
else
{
DBConnect con = new DBConnect();
con.OpenConnection();
try
{
string query = "SELECT * FROM bcpark354.Customer";
SqlDataReader Data = con.getData(query);
while (Data.Read())
{
if (textBox1.Text.Equals(Data["CustomerID"].ToString()))
{
Program.custID = textBox1.Text;
Cust next = new Cust();
MessageBox.Show("Welcome Customer");
next.Show();
this.Hide();
}
}
Data.Close();
con.CloseConnection();
}
catch (Exception x)
{
MessageBox.Show(x.Message, "Customer Retrival Failed", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
}
public CreatePurchaseOrder()
{
InitializeComponent();
try
{
DBConnect con = new DBConnect();
con.OpenConnection();
string query = "SELECT * FROM bcpark354.Merchandise ";
SqlDataReader Data = con.getData(query);
List <string> items = new List <string>();
while (Data.Read())
{
items.Add("ItemID: " + Data["ItemID"] + " - Name: " + Data["Name"] + " - Description: " + Data["Description"] + " - ListPrice: " + Data["ListPrice"].ToString());
}
listBox1.DataSource = items;
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Failed to Populate Merchandise", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
public TotalPurchaseOrders()
{
InitializeComponent();
DBConnect con = new DBConnect();
con.OpenConnection();
string query = "SELECT bcpark354.PurchaseOrder.OrderDate, count(bcpark354.PurchaseOrder.OrderDate) as NumberOrders, SUM(bcpark354.OrderDetail.UnitPrice) as TotalSales FROM bcpark354.PurchaseOrder INNER JOIN bcpark354.OrderDetail ON bcpark354.PurchaseOrder.OrderID=bcpark354.OrderDetail.OrderID GROUP BY bcpark354.PurchaseOrder.OrderDate ORDER BY bcpark354.PurchaseOrder.OrderDate DESC";
SqlDataReader Data = con.getData(query);
List <string> purchases = new List <string>();
try
{
while (Data.Read())
{
purchases.Add("OrderDate: " + Data["OrderDate"] + " -NumberOfOrders: " + Data["NumberOrders"] + " -TotalSales: " + Data["TotalSales"]);
}
listBox1.DataSource = purchases;
}
catch (Exception a)
{
MessageBox.Show(a.Message, "Failed to Produce Report", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
private void button1_Click(object sender, EventArgs e)
{
int count = 0;
DBConnect con = new DBConnect();
con.OpenConnection();
string itemIDvar = pItem.Substring(8, 4);
string Mquery = "select ListPrice from bcpark354.Merchandise where ItemID =" + itemIDvar;
string Cquery = "select * from bcpark354.PurchaseOrder";
string Xquery = "select AccountBalance from bcpark354.Customer where CustomerID =" + Program.custID;
string Pquery = "Insert into bcpark354.PurchaseOrder(OrderID, CustomerID, DeliveryDate, OrderDate)";
string Oquery = "Insert into bcpark354.OrderDetail(OrderID, ItemID, UnitPrice, Qty)";
string Tquery = "update bcpark354.Customer set AccountBalance = @AccountBalance where CustomerID =" + Program.custID;
MessageBox.Show(itemIDvar);
SqlDataReader Data = con.getData(Cquery);
try
{
while (Data.Read())
{
count++;
}
Data.Close();
count++;
}
catch (Exception w)
{
MessageBox.Show(w.Message, "Could not produce orderID", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
SqlDataReader Data2 = con.getData(Mquery);
try
{
while (Data2.Read())
{
UnitPriceVar = Data2.GetDecimal(0);
}
Data2.Close();
}
catch (Exception r)
{
MessageBox.Show(r.Message, "Could not produce orderID", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
SqlDataReader Data3 = con.getData(Xquery);
try
{
while (Data3.Read())
{
funds = Data3.GetDecimal(0);
}
Data3.Close();
}
catch (Exception r)
{
MessageBox.Show(r.Message, "Could not produce orderID", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
total = UnitPriceVar * decimal.Parse(pQuantity);
if (funds >= total)
{
SqlDataAdapter Da = new SqlDataAdapter();
SqlDataAdapter Ha = new SqlDataAdapter();
SqlDataAdapter Ca = new SqlDataAdapter();
try
{
Da.InsertCommand = new SqlCommand(Pquery + "values (@OrderID, @CustomerID, @DeliveryDate, @OrderDate)", con.connection);
Da.InsertCommand.Parameters.Add("@OrderID", SqlDbType.Char).Value = count.ToString();
Da.InsertCommand.Parameters.Add("@CustomerID", SqlDbType.Char).Value = Program.custID;
Da.InsertCommand.Parameters.Add("@DeliveryDate", SqlDbType.DateTime).Value = pDate.Date;
Da.InsertCommand.Parameters.Add("@OrderDate", SqlDbType.DateTime).Value = nDate.Date;
Da.InsertCommand.ExecuteNonQuery();
Ha.InsertCommand = new SqlCommand(Oquery + "values (@OrderID, @ItemID, @UnitPrice, @Qty)", con.connection);
Ha.InsertCommand.Parameters.Add("@OrderID", SqlDbType.Char).Value = count.ToString();
Ha.InsertCommand.Parameters.Add("@ItemID", SqlDbType.Char).Value = itemIDvar;
Ha.InsertCommand.Parameters.Add("@UnitPrice", SqlDbType.Decimal).Value = total;
Ha.InsertCommand.Parameters.Add("@Qty", SqlDbType.Int).Value = int.Parse(pQuantity);
Ha.InsertCommand.ExecuteNonQuery();
Ca.UpdateCommand = new SqlCommand(Tquery, con.connection);
Ca.UpdateCommand.Parameters.Add("@AccountBalance", SqlDbType.Decimal).Value = (funds - total);
Ca.UpdateCommand.ExecuteNonQuery();
MessageBox.Show("Your order as been entered into the system. Thank You");
}
catch (Exception x)
{
MessageBox.Show(x.Message, "Could not confirm order", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
else
{
MessageBox.Show("Sorry, you do not have enough funds for that purchase");
}
}