private void LoadAll() { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["Default"].ConnectionString; string queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[grocerystore] ORDER BY store_id"; using (SqlConnection _con = new SqlConnection(connectionString)) { using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { GROCERYSTORE addStore = new GROCERYSTORE(); addStore.store_id = Int32.Parse(dr["store_id"].ToString()); addStore.store_name = dr["store_name"].ToString(); addStore.phone = dr["phone"].ToString(); addStore.address_id = Int32.Parse(dr["address_id"].ToString()); addStore.opening_time = dr["opening_time"].ToString(); addStore.closing_time = dr["closing_time"].ToString(); stores.Add(addStore); } } } }
private void LoadAll() { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["Default"].ConnectionString; using (SqlConnection _con = new SqlConnection(connectionString)) { string queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[user]"; using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { USER addUser = new USER(); addUser.first_name = dr["first_name"].ToString(); addUser.last_name = dr["last_name"].ToString(); addUser.email = dr["email"].ToString(); addUser.password = dr["password"].ToString(); addUser.username = dr["username"].ToString(); addUser.user_type = dr["user_type"].ToString(); users.Add(addUser); } } queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[systeminformation]"; using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { SYSTEMINFORMATION add = new SYSTEMINFORMATION(); add.system_id = Int32.Parse(dr["system_id"].ToString()); add.user_codes = dr["user_codes"].ToString(); sysinfo.Add(add); } } queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[grocerystore]"; using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { GROCERYSTORE addStore = new GROCERYSTORE(); addStore.store_id = Int32.Parse(dr["store_id"].ToString()); addStore.store_name = dr["store_name"].ToString(); addStore.phone = dr["phone"].ToString(); addStore.address_id = Int32.Parse(dr["address_id"].ToString()); addStore.opening_time = dr["opening_time"].ToString(); addStore.closing_time = dr["closing_time"].ToString(); stores.Add(addStore); } } } }
private void button5_Click(object sender, EventArgs e) { is_descending = !is_descending; stores.Clear(); if (!is_descending) { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["Default"].ConnectionString; string queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[grocerystore] ORDER BY store_name"; using (SqlConnection _con = new SqlConnection(connectionString)) { using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { GROCERYSTORE addStore = new GROCERYSTORE(); addStore.store_id = Int32.Parse(dr["store_id"].ToString()); addStore.store_name = dr["store_name"].ToString(); addStore.phone = dr["phone"].ToString(); addStore.address_id = Int32.Parse(dr["address_id"].ToString()); addStore.opening_time = dr["opening_time"].ToString(); addStore.closing_time = dr["closing_time"].ToString(); stores.Add(addStore); } } } } else { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["Default"].ConnectionString; string queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[grocerystore] ORDER BY store_name DESC"; using (SqlConnection _con = new SqlConnection(connectionString)) { using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { GROCERYSTORE addStore = new GROCERYSTORE(); addStore.store_id = Int32.Parse(dr["store_id"].ToString()); addStore.store_name = dr["store_name"].ToString(); addStore.phone = dr["phone"].ToString(); addStore.address_id = Int32.Parse(dr["address_id"].ToString()); addStore.opening_time = dr["opening_time"].ToString(); addStore.closing_time = dr["closing_time"].ToString(); stores.Add(addStore); } } } } if (counter % 5 == 0) { counter -= 5; } else { counter -= counter % 5; } DisplayStores(); }
private void button1_Click(object sender, EventArgs e) { users.Clear(); addresses.Clear(); buyers.Clear(); stores.Clear(); Globals.Persistent_Current = null; LoadAll(); //MessageBox.Show(users.Count().ToString()); bool matchFound = false; foreach (var item in users) { if (txtUsername.Text == item.username && txtPassword.Text == item.password) { Globals.has_deleted = false; matchFound = true; Globals.Persistent_Current = item; if (Globals.Persistent_Current.user_type == "deliverer" || Globals.Persistent_Current.user_type == "manager") { break; } foreach (var item_buyer in buyers) { if (item.username == item_buyer.username) { Globals.Persistent_Buyer = item_buyer; } } foreach (var item_store in stores) { if (Globals.Persistent_Buyer.default_store_id == item_store.store_id) { Globals.Persistent_Store = item_store; } } foreach (var item_address in addresses) { if (Globals.Persistent_Buyer.address == item_address.id) { Globals.Persistent_Address = item_address; } if (Globals.Persistent_Store.address_id == item_address.id) { Globals.Store_Address = item_address; } } Globals.Preferred_Credit = "N/A"; Globals.Preferred_Routing = "N/A"; BuyerFunctionality form = new BuyerFunctionality(); form.ShowDialog(); continue; } } if (!matchFound) { DialogResult dialog = new DialogResult(); dialog = MessageBox.Show("Error: Invalid Login Information.", "GroceryBama Message", MessageBoxButtons.OK); return; } if (Globals.Persistent_Current.user_type == "deliverer") { DelivererFunctionality form = new DelivererFunctionality(); form.ShowDialog(); } else if (Globals.Persistent_Current.user_type == "manager") { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["Default"].ConnectionString; using (SqlConnection _con = new SqlConnection(connectionString)) { string queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[manages] where username = @username"; using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { _cmd.Parameters.Add("@username", SqlDbType.VarChar).Value = Globals.Persistent_Current.username; DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { GROCERYSTORE addStore = new GROCERYSTORE(); addStore.address_id = Int32.Parse(dr["store_address"].ToString()); temp = addStore; } } } foreach (var item in stores) { if (temp.address_id == item.address_id) { Globals.Persistent_Store = item; } } foreach (var item_address in addresses) { if (Globals.Persistent_Store.address_id == item_address.id) { Globals.Store_Address = item_address; } } ManagerFunctionality form = new ManagerFunctionality(); form.ShowDialog(); } }
private void LoadAll() { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["Default"].ConnectionString; using (SqlConnection _con = new SqlConnection(connectionString)) { string queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[user]"; using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { USER addUser = new USER(); addUser.first_name = dr["first_name"].ToString(); addUser.last_name = dr["last_name"].ToString(); addUser.email = dr["email"].ToString(); addUser.password = dr["password"].ToString(); addUser.username = dr["username"].ToString(); addUser.user_type = dr["user_type"].ToString(); users.Add(addUser); } } queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[buyer]"; using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { BUYER addBuyer = new BUYER(); addBuyer.phone = dr["phone"].ToString(); addBuyer.address = Int32.Parse(dr["address_id"].ToString()); addBuyer.default_payment = dr["default_payment"].ToString(); addBuyer.default_store_id = Int32.Parse(dr["default_store_id"].ToString()); addBuyer.username = dr["username"].ToString(); buyers.Add(addBuyer); } } queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[address]"; using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { ADDRESS addAddress = new ADDRESS(); addAddress.id = Int32.Parse(dr["id"].ToString()); addAddress.house_number = dr["house_number"].ToString(); addAddress.state = dr["state"].ToString(); addAddress.street = dr["street"].ToString(); addAddress.city = dr["city"].ToString(); addAddress.zip_code = dr["zip_code"].ToString(); addresses.Add(addAddress); } } queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[grocerystore]"; using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { GROCERYSTORE addStore = new GROCERYSTORE(); addStore.store_id = Int32.Parse(dr["store_id"].ToString()); addStore.store_name = dr["store_name"].ToString(); addStore.phone = dr["phone"].ToString(); addStore.address_id = Int32.Parse(dr["address_id"].ToString()); addStore.opening_time = dr["opening_time"].ToString(); addStore.closing_time = dr["closing_time"].ToString(); stores.Add(addStore); } } } }
private void LoadAll() { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["Default"].ConnectionString; string queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[grocerystore]"; using (SqlConnection _con = new SqlConnection(connectionString)) { using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { GROCERYSTORE addStore = new GROCERYSTORE(); addStore.store_id = Int32.Parse(dr["store_id"].ToString()); addStore.store_name = dr["store_name"].ToString(); addStore.phone = dr["phone"].ToString(); addStore.address_id = Int32.Parse(dr["address_id"].ToString()); addStore.opening_time = dr["opening_time"].ToString(); addStore.closing_time = dr["closing_time"].ToString(); stores.Add(addStore); } } queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[item] ORDER BY item_name"; using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { ITEM addItem = new ITEM(); addItem.item_id = Int32.Parse(dr["item_id"].ToString()); addItem.item_name = dr["item_name"].ToString(); addItem.quantity = Int32.Parse(dr["quantity"].ToString()); addItem.wholesale_price = Double.Parse(dr["wholesale_price"].ToString()); addItem.listed_price = Double.Parse(dr["listed_price"].ToString()); addItem.food_group = dr["food_group"].ToString(); addItem.description = dr["description"].ToString(); addItem.exp_date = dr["exp_date"].ToString(); items.Add(addItem); } } queryStatement = "SELECT * FROM [GROCERYBAMA1].[dbo].[soldat]"; using (SqlCommand _cmd = new SqlCommand(queryStatement, _con)) { DataTable tb = new DataTable(); SqlDataAdapter _dap = new SqlDataAdapter(_cmd); _con.Open(); _dap.Fill(tb); _con.Close(); foreach (DataRow dr in tb.Rows) { SOLDAT addItem = new SOLDAT(); addItem.store_id = Int32.Parse(dr["store_id"].ToString()); addItem.item_id = Int32.Parse(dr["item_id"].ToString()); items_sold_at.Add(addItem); } } } }