public add_proc()
{
this.InitializeComponent();
c1 = new DBconnection();
branddt = c1.Select("select * from Brand");
socketdt = c1.Select("select * from Socket");
vendordt = c1.Select("select * from Vendor");
type_box.Text = "Processor";
for (int i = 0; i < branddt.Rows.Count; i++)
{
brand_combobox.Items.Add(branddt.Rows[i]["BrandName"]);
}
for (int i = 0; i < socketdt.Rows.Count; i++)
{
socket_combobox.Items.Add(socketdt.Rows[i]["SocketName"]);
}
for (int i = 0; i < vendordt.Rows.Count; i++)
{
vendor_combobox.Items.Add(vendordt.Rows[i]["VendorName"]);
}
}
public void set_itemname()
{
DBconnection c1 = new DBconnection();
if (!is_build)
{
DataTable d1 = c1.Select("select * from Products where ProductID = " + itemid);
foreach (DataRow row in d1.Rows)
{
if (itemid == row["ProductID"].ToString())
{
itemname = row["ProductName"].ToString();
break;
}
}
}
else
{
DataTable d1 = c1.Select("select * from Builds where BuildID = " + buildid);
foreach (DataRow row in d1.Rows)
{
if (buildid == row["BuildID"].ToString())
{
itemname = row["BuildDescription"].ToString();
break;
}
}
}
}
private void mobo_box_reloaded()
{
mobo_box.Items.Clear();
mobo_tb.Clear();
mobo_tb = c1.Select("select * from Motherboard m1, Products p2 where m1.ProductID = p2.ProductID and SocketID = '" + socket + "'");
for (int i = 0; i < mobo_tb.Rows.Count; i++)
{
mobo_box.Items.Add(mobo_tb.Rows[i]["ProductName"]);
}
}
public view_build()
{
this.InitializeComponent();
c1 = new DBconnection();
d1 = c1.Select("select * from Builds");
current_session.FillDataGrid(d1, builds_grid);
}
public orderhistory()
{
this.InitializeComponent();
c1 = new DBconnection();
ord_tb = c1.Select("select o.OrderID, o.CustomerID, o.OrderDate, sum(oi.UnitPrice) as [Total Price] from Orders o, OrderItem oi where o.OrderID = oi.OrderID and CustomerID = " + current_session.customer_id + " group by o.OrderID, o.CustomerID, o.OrderDate");
current_session.FillDataGrid(ord_tb, order_histgrid);
}
public registerform()
{
this.InitializeComponent();
c2 = new DBconnection();
d2 = c2.Select("select * from City");
checks_passed = true;
emailbox.Text = current_register.current_email;
}
public upd_proc()
{
this.InitializeComponent();
c1 = new DBconnection();
prod_dt = new DataTable();
brand_dt = c1.Select("select * from Brand");
socket_dt = c1.Select("select * from Socket");
for (int i = 0; i < brand_dt.Rows.Count; i++)
{
brandbox.Items.Add(brand_dt.Rows[i]["BrandName"]);
}
for (int i = 0; i < socket_dt.Rows.Count; i++)
{
socketbox.Items.Add(socket_dt.Rows[i]["SocketName"]);
}
}
private void search_btn_Click(object sender, RoutedEventArgs e)
{
if (categ_box.SelectedIndex != -1)
{
d1 = c1.Select("select ProductID, TypeName as 'Product Type', BrandName, ProductName as 'Product Name', isAvailable as 'Available', UnitPrice as 'Price'"
+ " from Products, ProductType, Brand "
+ "where Products.TypeID = ProductType.TypeID and Products.BrandID = Brand.BrandID and TypeName = '" + categ_box.SelectedItem.ToString() + "'");
current_session.FillDataGrid(d1, search_grid);
}
else
{
string x = prod_namebox.Text;
d1 = c1.Select("select ProductID, TypeName as 'Product Type', BrandName, ProductName as 'Product Name', isAvailable as 'Available', UnitPrice as 'Price'"
+ " from Products, ProductType, Brand "
+ "where Products.TypeID = ProductType.TypeID and Products.BrandID = Brand.BrandID and ProductName like '%" + x + "%'");
current_session.FillDataGrid(d1, search_grid);
}
}
public static void set_customer_details() //assuming customer id is set
{
DBconnection x1 = new DBconnection();
DataTable cust_details = x1.Select("select * from Customer where CustomerID = " + customer_id);
foreach (DataRow row in cust_details.Rows)
{
customer_name = row["CustomerName"].ToString();
customer_addr = row["CustomerAddress"].ToString();
customer_cityid = row["CityID"].ToString();
contact = row["Contact"].ToString();
}
}
public create_build()
{
this.InitializeComponent();
c1 = new DBconnection();
mobo_tb = new DataTable();
chassis_tb = new DataTable();
ffactor = ""; socket = "";
curr_price = 0;
proc_tb = c1.Select("select * from Processor p1, Products p2 where p1.ProductID = p2.ProductID");
mobo_tb = c1.Select("select * from Motherboard m1, Products p2 where m1.ProductID = p2.ProductID");
gpu_tb = c1.Select("select * from GPU g1, Products p2 where g1.ProductID = p2.ProductID");
memory_tb = c1.Select("select * from Memory m2, Products p2 where m2.ProductID = p2.ProductID");
storage_tb = c1.Select("select * from Storage s2, Products p2 where s2.ProductID = p2.ProductID");
psu_tb = c1.Select("select * from PSU s2, Products p2 where s2.ProductID = p2.ProductID");
//chassis_tb = c1.Select("select * from Chassis ch1, Products p2 where ch1.ProductID = p2.ProductID");
for (int i = 0; i < proc_tb.Rows.Count; i++)
{
proc_box.Items.Add(proc_tb.Rows[i]["ProductName"]);
}
for (int i = 0; i < mobo_tb.Rows.Count; i++)
{
mobo_box.Items.Add(mobo_tb.Rows[i]["ProductName"]);
}
for (int i = 0; i < gpu_tb.Rows.Count; i++)
{
gpu_box.Items.Add(gpu_tb.Rows[i]["ProductName"]);
}
for (int i = 0; i < psu_tb.Rows.Count; i++)
{
psu_box.Items.Add(psu_tb.Rows[i]["ProductName"]);
}
for (int i = 0; i < memory_tb.Rows.Count; i++)
{
memory_box.Items.Add(memory_tb.Rows[i]["ProductName"]);
}
for (int i = 0; i < storage_tb.Rows.Count; i++)
{
storage_box.Items.Add(storage_tb.Rows[i]["ProductName"]);
}
}
public view_all_prod()
{
this.InitializeComponent();
c1 = new DBconnection();
d1 = c1.Select("select * from Products");
foreach (DataColumn col in d1.Columns)
{
System.Diagnostics.Debug.WriteLine((col.ToString()));
}
current_session.FillDataGrid(d1, prod_datagrid);
//prod_datagrid.CanUserAddRows = false;
}
private void search_bttn_Click(object sender, RoutedEventArgs e)
{
d1 = c1.Select("select * from Products where ProductID = " + ID_box.Text);
string price_old = "";
foreach (DataRow row in d1.Rows)
{
if (ID_box.Text == row["ProductID"].ToString())
{
price_old = row["UnitPrice"].ToString();
break;
}
}
curr_priceBox.Text = price_old;
}
private void search_btn_Click(object sender, RoutedEventArgs e)
{
prod_dt = c1.Select("select * from Products p inner join Processor p1 on p.ProductID = p1.ProductID inner join Vendor v on p.VendorID = v.VendorID inner join Brand on p.BrandID = Brand.BrandID inner join Socket S on p1.SocketID = S.SocketID");
//
foreach (DataRow row in prod_dt.Rows)
{
if (search_box.Text == row["ProductID"].ToString())
{
namebox.Text = row["ProductName"].ToString();
price_box.Text = row["UnitPrice"].ToString();
type_box.Text = "Processor";
clock_box.Text = row["ClockSpeed"].ToString();
vendor_box.Text = row["VendorName"].ToString();
brandbox.SelectedItem = row["BrandName"].ToString();
socketbox.SelectedItem = row["SocketName"].ToString();
}
}
}
private void citycombobox_Loaded(object sender, RoutedEventArgs e)
{
DataTable d2 = new DataTable();
d2 = c1.Select("select * from City");
for (int i = 0; i < d2.Rows.Count; i++)
{
citycombobox.Items.Add(d2.Rows[i]["CityName"]);
}
string temp = "";
for (int i = 0; i < d2.Rows.Count; i++)
{
if (current_session.customer_cityid == d2.Rows[i]["CityID"].ToString())
{
temp = d2.Rows[i]["CityName"].ToString();
break;
}
}
citycombobox.SelectedItem = temp;
}
public product_search()
{
this.InitializeComponent();
c1 = new DBconnection();
d2 = c1.Select("select * from ProductType");
}
private void signbttn_Click(object sender, RoutedEventArgs e)
{
DataTable login_table = c1.Select("select * from AppUser");
if (newuserflag)
{
current_register.currentpass = passbox.Password;
current_register.current_email = emailbox.Text;
this.Frame.Navigate(typeof(registerform));
return;
}
foreach (DataRow row in login_table.Rows)
{
if (emailbox.Text == row["userid"].ToString() && passbox.Password.Equals(row["userpassword"].ToString()))
{
userid = emailbox.Text;
System.Diagnostics.Debug.WriteLine(userid);
current_session.emailid = emailbox.Text;
current_session.current_pass = passbox.Password;
current_session.customer_id = row["CustomerID"].ToString();
current_session.set_customer_details();
if (row["isAdmin"].ToString() == "True")
{
this.Frame.Navigate(typeof(admin_dash));
return;
}
else
{
this.Frame.Navigate(typeof(user_dash));
return;
}
}
else
{
System.Diagnostics.Debug.WriteLine("unmatched");
}
}
/*
* if (newuserflag && adminflag)
* {
*
* // Create the message dialog and set its content
* //var messageDialog = new MessageDialog("user cannot be both new user and admin");
*
* // Show the message dialog
* //await messageDialog.ShowAsync();
*
* }
*
* else if (newuserflag)
* {
* this.Frame.Navigate(typeof(registerform));
* }
* else if(adminflag)
* {
* this.Frame.Navigate(typeof(admin_dash));
* }
*
* else
* {
* this.Frame.Navigate(typeof(user_dash));
* }
*/
}
