private void MySetProduct()
{
db = new SalesDBMF();
var ProQ = from ProList in db.products
select
ProList.product_id;
foreach (int ProID in ProQ)
{
cbProductID.Items.Add(ProID);
}
cbProductID.SelectedIndex = 0;
}
private void MySetCategories()
{
db = new SalesDBMF();
var CateQ = from CateList in db.categories
select
CateList.category_id;
foreach (int CateID in CateQ)
{
cbCateID.Items.Add(CateID);
}
cbCateID.SelectedIndex = 0;
}
private void MySetOrder()
{
db = new SalesDBMF();
var OrdQ = from OrdList in db.orders
select
OrdList.order_id;
foreach (int OrdID in OrdQ)
{
cbOrdersID.Items.Add(OrdID);
}
cbOrdersID.SelectedIndex = 0;
}
private void MySetCustomer()
{
db = new SalesDBMF();
var CusQ = from CusList in db.customers
select
CusList.customer_id;
foreach (string CusID in CusQ)
{
cbCusto.Items.Add(CusID);
}
cbCusto.SelectedIndex = 0;
}
private void MySetBrand()
{
db = new SalesDBMF();
var BrQ = from BraList in db.brands
select
BraList.brand_id;
foreach (int BraID in BrQ)
{
cbBrandID.Items.Add(BraID);
}
cbBrandID.SelectedIndex = 0;
}
private void MySetStore()
{
db = new SalesDBMF();
var STOQ = from StoList in db.stores
select
StoList.store_id;
foreach (string StoID in STOQ)
{
cbStore.Items.Add(StoID);
}
cbStore.SelectedIndex = 0;
}
private void MySetStaff()
{
db = new SalesDBMF();
var StaQ = from StaList in db.staffs
select
StaList.staff_id;
foreach (string StaID in StaQ)
{
cbStaff.Items.Add(StaID);
}
cbStaff.SelectedIndex = 0;
}
private void MySetDistrict()
{
db = new SalesDBMF();
var DistQ = from DistList in db.districts
select
DistList.district_name;
foreach (string DistName in DistQ)
{
cbDist.Items.Add(DistName);
}
cbDist.SelectedIndex = 0;
}
private void MySetProvince()
{
db = new SalesDBMF();
var ProvQ = from ProvList in db.provinces
select
ProvList.province_name;
foreach (string ProvName in ProvQ)
{
cbProv.Items.Add(ProvName);
}
cbProv.SelectedIndex = 0;
}
private void MySetCategory()
{
db = new SalesDBMF();
var CateQ = from CateList in db.categories
select CateList;
DataTable dt = new DataTable();
dt.Columns.Add("Category_ID");
dt.Columns.Add("Category_Name");
foreach (var p in CateQ)
{
dt.Rows.Add(p.category_id, p.category_name);
}
dtGridView.DataSource = dt;
}
private void MySetBrand()
{
db = new SalesDBMF();
var BrandQ = from BraList in db.brands
select BraList;
DataTable dt = new DataTable();
dt.Columns.Add("Brand_ID");
dt.Columns.Add("Brand_Name");
foreach (var p in BrandQ)
{
dt.Rows.Add(p.brand_id, p.brand_name);
}
dtGridView.DataSource = dt;
}
private void MySetProvince()
{
db = new SalesDBMF();
var ProvinceQ = from ProvList in db.provinces
select ProvList;
DataTable dt = new DataTable();
dt.Columns.Add("Province_ID");
dt.Columns.Add("Province_Name");
foreach (var p in ProvinceQ)
{
dt.Rows.Add(p.province_id, p.province_name);
}
dtGridView.DataSource = dt;
}
private void MySetStore()
{
db = new SalesDBMF();
var StoQ = from StoreList in db.stores
select StoreList;
DataTable dt = new DataTable();
dt.Columns.Add("Store_ID");
dt.Columns.Add("Store_Name");
dt.Columns.Add("Phone");
dt.Columns.Add("Email");
dt.Columns.Add("Street");
dt.Columns.Add("City");
dt.Columns.Add("State/Province");
dt.Columns.Add("Zipcode");
foreach (var p in StoQ)
{
dt.Rows.Add(p.store_id, p.store_name, p.phone, p.email, p.street, p.city, p.state, p.zip_code);
}
dtGridView.DataSource = dt;
}
private void MySetCustomer()
{
db = new SalesDBMF();
var CusQ = from CusList in db.customers
select CusList;
DataTable dt = new DataTable();
dt.Columns.Add("Customer_ID");
dt.Columns.Add("First_Name");
dt.Columns.Add("Last_Name");
dt.Columns.Add("Phone");
dt.Columns.Add("Email");
dt.Columns.Add("Street");
dt.Columns.Add("City");
dt.Columns.Add("State/Province");
dt.Columns.Add("Zipcode");
foreach (var p in CusQ)
{
dt.Rows.Add(p.customer_id, p.first_name, p.last_name, p.phone, p.email, p.street, p.city, p.state, p.zip_code);
}
dtGridView.DataSource = dt;
}
