//REGISTER PANEL private void register_Click(object sender, EventArgs e) { using (ShopExpressEntities context = new ShopExpressEntities()) { try { context.Users.Add(new User { firstName = firstName.Text, lastName = lastName.Text, address = address.Text, city = city.Text, country = country.Text, email = email.Text, phone = phone.Text, password = password.Text, }); context.SaveChanges(); MessageBox.Show("Success! Please login now!"); this.Close(); } catch { MessageBox.Show("Oops!");//exc.Message); } } }
private void order_Click(object sender, EventArgs e) { string message = "From : " + productSeller.Text + Environment.NewLine; message += "To : " + UserControl.userFullname() + Environment.NewLine; message += "Price : " + productPrice.Text + Environment.NewLine; DialogResult result = MessageBox.Show(message, "Confirmation", MessageBoxButtons.YesNoCancel); if (result == DialogResult.Yes) { try { using (var context = new ShopExpressEntities()) { var product = new Product { productID = productIDtemp }; context.Products.Attach(product); context.Products.Remove(product); context.SaveChanges(); } MessageBox.Show("Order confirmed!", "Confirmation"); userPanel.BringToFront(); dataSetter(); } catch { MessageBox.Show("Oops, something went wrong! Please try again!", "Error!"); } } }
private void displayProduct(int prodID) { using (ShopExpressEntities context = new ShopExpressEntities()) { productIDtemp = prodID; var prod = context.Products .Where(x => x.productID == prodID) .Select(y => new { y.userID, y.genderCategory, y.categoryID, y.productDescription, y.productName, y.size, y.colorID, y.price, y.picture }).ToList(); productPanel.BringToFront(); int sellerID = prod[0].userID; int catID = prod[0].categoryID; int colID = prod[0].colorID; string pic = prod[0].picture; var seller = context.Users .Where(x => x.userID == sellerID) .Select(y => new { y.firstName, y.lastName }).ToList(); var category = context.Categories .Where(x => x.categoryID == catID) .Select(y => new { y.categoryName }).ToList(); var color = context.Colors .Where(x => x.colorID == colID) .Select(y => new { y.color }).ToList(); pl1.Text = prod[0].productName; productSeller.Text = seller[0].firstName + " " + seller[0].lastName; productCategory.Text = category[0].categoryName; productColor.Text = color[0].color; productDescription.Text = prod[0].productDescription; productGender.Text = prod[0].genderCategory; productSize.Text = prod[0].size; productPrice.Text = prod[0].price + " €"; productPicture.Image = Image.FromFile(Path.GetFullPath(pic)); productPicture.SizeMode = PictureBoxSizeMode.StretchImage; productPicture.Size = new System.Drawing.Size(300, 370); if (UserControl.ID() == sellerID) { try { order.Hide(); } catch { } } else { try { order.Show(); } catch { } } }; }
private void searchButton_Click(object sender, EventArgs e) { using (ShopExpressEntities context = new ShopExpressEntities()) { try { var catID = context.Categories .Where(g => g.categoryName == searchCategoryBox.Text) .Select(x => new { x.categoryID }).ToList(); string selectedGender = searchGenderBox.Text; int selectedCategory = catID[0].categoryID; var products = context.Products .Where(x => x.categoryID == selectedCategory && x.genderCategory == selectedGender) .Select(y => new { y.productID, y.userID, y.genderCategory, y.categoryID, y.productName, y.size, y.colorID, y.price }).ToList(); dataGridView1.DataSource = products; foreach (DataGridViewRow row in dataGridView1.Rows) { int uID = Convert.ToInt32(row.Cells[8].Value); int cID = Convert.ToInt32(row.Cells[9].Value); int ccID = Convert.ToInt32(row.Cells[10].Value); var userL = context.Users .Where(x => x.userID == uID) .Select(y => new { y.firstName, y.lastName }).ToList(); var categoryL = context.Categories .Where(x => x.categoryID == cID) .Select(y => new { y.categoryName }).ToList(); var colorL = context.Colors .Where(x => x.colorID == ccID) .Select(y => new { y.color }).ToList(); row.Cells[2].Value = userL[0].firstName.ToString() + " " + userL[0].lastName.ToString(); row.Cells[4].Value = categoryL[0].categoryName.ToString(); row.Cells[5].Value = colorL[0].color.ToString(); } } catch { MessageBox.Show("Choose gender and category please!"); } }; }
private void fullName_Click(object sender, EventArgs e) { userProfilePanel.BringToFront(); profileFullName2.Text = UserControl.userFullname(); profileCountry2.Text = UserControl.getCountry(); profileCity2.Text = UserControl.getCity(); using (ShopExpressEntities context = new ShopExpressEntities()) { int getUserID = UserControl.ID(); var products = context.Products .Where(g => g.userID == getUserID) .Select(y => new { y.productID, y.userID, y.genderCategory, y.categoryID, y.productName, y.size, y.colorID, y.price }).ToList(); dataGridView2.DataSource = products; } }
private void comboBox_Load() { using (ShopExpressEntities context = new ShopExpressEntities()) { List <Category> categoryList = new List <Category>(); List <Color> colorList = new List <Color>(); categoryList = context.Categories.ToList(); colorList = context.Colors.ToList(); itemCategory.DataSource = categoryList; itemCategory.ValueMember = "categoryID"; itemCategory.DisplayMember = "categoryName"; itemCategory.Text = "Choose category"; itemColor.DataSource = colorList; itemColor.ValueMember = "colorID"; itemColor.DisplayMember = "color"; itemColor.Text = "Choose color"; } }
private void uploadItemButton_Click(object sender, EventArgs e) { try { using (ShopExpressEntities context = new ShopExpressEntities()) { var catID = context.Categories .Where(x => x.categoryName == itemCategory.Text) .Select(x => new { x.categoryID }).ToList(); var colID = context.Colors .Where(y => y.color == itemColor.Text) .Select(y => new { y.colorID }).ToList(); context.Products.Add(new Product { categoryID = catID[0].categoryID, userID = UserControl.ID(), productName = itemName.Text, productDescription = itemDescription.Text, genderCategory = gender.Text, size = itemSize.Text, colorID = colID[0].colorID, price = Convert.ToInt64(itemPrice.Text), picture = picPath.Text } ); context.SaveChanges(); MessageBox.Show("New item is added!"); userPanel.BringToFront(); dataSetter(); } } catch { MessageBox.Show("Oops! Some data is invalid!"); } }
public static int logIn(string email, string pass) { using (var context = new ShopExpressEntities()) { var user = context.Users .Where(x => x.email == email && x.password == pass) .Select(x => new { x.userID, x.firstName, x.lastName, x.city, x.country }).ToList(); try { user_id = user[0].userID; firstName = user[0].firstName; lastName = user[0].lastName; country = user[0].country; city = user[0].city; return(user[0].userID); } catch { return(0); } }; }
private void dataSetter() { using (var context = new ShopExpressEntities()) { searchCategoryBox.DataSource = context.Categories.ToList(); searchCategoryBox.ValueMember = "categoryID"; searchCategoryBox.DisplayMember = "categoryName"; searchCategoryBox.Text = "Choose category"; fullName.Text = UserControl.userFullname(); dataGridView1.DataSource = context.Products.ToList(); foreach (DataGridViewRow row in dataGridView1.Rows) { int uID = Convert.ToInt32(row.Cells[8].Value); int cID = Convert.ToInt32(row.Cells[9].Value); int ccID = Convert.ToInt32(row.Cells[10].Value); var userL = context.Users .Where(x => x.userID == uID) .Select(y => new { y.firstName, y.lastName }).ToList(); var categoryL = context.Categories .Where(x => x.categoryID == cID) .Select(y => new { y.categoryName }).ToList(); var colorL = context.Colors .Where(x => x.colorID == ccID) .Select(y => new { y.color }).ToList(); row.Cells[2].Value = (userL[0].firstName + " " + userL[0].lastName).ToString(); row.Cells[4].Value = categoryL[0].categoryName.ToString(); row.Cells[5].Value = colorL[0].color.ToString(); } int uIDu = UserControl.ID(); dataGridView2.DataSource = context.Products .Where(x => x.userID == uIDu) .Select(x => new { x.userID, x.price, x.productID, x.productName, x.size, x.genderCategory, x.colorID, x.categoryID }) .ToList(); foreach (DataGridViewRow row2 in dataGridView2.Rows) { int uID = Convert.ToInt32(row2.Cells[8].Value); int cID = Convert.ToInt32(row2.Cells[9].Value); int ccID = Convert.ToInt32(row2.Cells[10].Value); var userL = context.Users .Where(x => x.userID == uID) .Select(y => new { y.firstName, y.lastName }).ToList(); var categoryL = context.Categories .Where(x => x.categoryID == cID) .Select(y => new { y.categoryName }).ToList(); var colorL = context.Colors .Where(x => x.colorID == ccID) .Select(y => new { y.color }).ToList(); row2.Cells[2].Value = (userL[0].firstName + " " + userL[0].lastName).ToString(); row2.Cells[4].Value = categoryL[0].categoryName.ToString(); row2.Cells[5].Value = colorL[0].color.ToString(); //Seller, category and color name: //MessageBox.Show(row2.Cells[2].Value.ToString() + ":" + row2.Cells[4].Value.ToString() + ":" + row2.Cells[5].Value.ToString()); } } }