private void Button1_Click(object sender, EventArgs e) { using (EntityModel db = new EntityModel()) { var y = db.Users.ToList().Where(x => (x.UserName == textBox1.Text)).ToList(); if (y.Count == 0) { User user1 = new User() { UserName = textBox1.Text, Password = textBox2.Text, Name = textBox4.Text, Surname = textBox5.Text }; db.Users.Add(user1); db.SaveChanges(); Close(); } else { MessageBox.Show("The user already exists"); } } }
private void Product_Click(object sender, EventArgs e) { using (EntityModel db = new EntityModel()) { listView3.Items.Clear(); panel1.Visible = true; panel2.Visible = true; panel3.Visible = true; ListViewItem list; int id = 0; var tapilan = db.products.ToList().Where(x => x.User_id == user).ToList(); foreach (var item in tapilan) { id++; list = new ListViewItem(id.ToString()); list.SubItems.Add(item.Name); list.SubItems.Add(item.Price); list.SubItems.Add(item.Quantity.ToString()); list.SubItems.Add(item.Description); listView3.Items.Add(list); } } }
private void Custom_Click(object sender, EventArgs e) { using (EntityModel db = new EntityModel()) { listView1.Items.Clear(); panel1.Visible = true; panel2.Visible = false; panel3.Visible = false; ListViewItem list; int id = 0; var tapilan = db.customs.ToList().Where(x => x.User_id == user).ToList(); foreach (var item in tapilan) { id++; list = new ListViewItem(id.ToString()); list.SubItems.Add(item.Name); list.SubItems.Add(item.Surname); list.SubItems.Add(item.Email); list.SubItems.Add(item.Phone); list.SubItems.Add(item.Address); listView1.Items.Add(list); } } }
private void Order_Click(object sender, EventArgs e) { using (EntityModel db = new EntityModel()) { listView2.Items.Clear(); panel1.Visible = true; panel2.Visible = true; panel3.Visible = false; ListViewItem list; int id = 0; var tapilan = db.orders.ToList().Where(x => x.User_id == user).ToList().ToList(); foreach (var item in tapilan) { id++; list = new ListViewItem(id.ToString()); list.SubItems.Add(item.Client_id.Name); list.SubItems.Add(item.Product_id.Name); list.SubItems.Add(item.Quantity.ToString()); list.SubItems.Add(item.OrderTime.ToString()); list.SubItems.Add(item.Arrive.ToString()); if (DateTime.Now > item.Arrive) { list.SubItems.Add("Ended"); } else if (DateTime.Now < item.Arrive) { list.SubItems.Add("Waiting"); } else if (DateTime.Now == item.Arrive) { list.SubItems.Add("Sending"); } listView2.Items.Add(list); } } }
private void comboBox1_TextChanged(object sender, EventArgs e) { using (EntityModel db = new EntityModel()) { comboBox2.Items.Clear(); var prod = db.products.ToList().Where(x => x.User_id == Form1.user); foreach (var item in prod) { if (item.Quantity > 0) { comboBox2.Items.Add(item.Name); } } if (comboBox1.SelectedIndex < 1) { errorProvider1.SetError(comboBox1, "Client is empty"); } else { errorProvider1.Clear(); } if (comboBox2.SelectedIndex < 1) { errorProvider1.SetError(comboBox2, "Product is empty"); } else { errorProvider1.Clear(); } if (comboBox1.SelectedItem != null && comboBox2.SelectedItem != null) { errorProvider1.Clear(); button1.Enabled = true; } } }
private void textBox1_TextChanged(object sender, EventArgs e) { if (panel1.Visible == true && panel2.Visible == false && panel3.Visible == false) { using (EntityModel db = new EntityModel()) { ListViewItem list; int id = 0; listView1.Items.Clear(); if (textBox1.Text == "") { var tapilan = db.customs.ToList().Where(x => x.User_id == user).ToList(); foreach (var item in tapilan) { id++; list = new ListViewItem(id.ToString()); list.SubItems.Add(item.Name); list.SubItems.Add(item.Surname); list.SubItems.Add(item.Email); list.SubItems.Add(item.Phone); list.SubItems.Add(item.Address); listView1.Items.Add(list); } } else { var tapilan = db.customs.ToList().Where(x => (x.Id.ToString().Contains(textBox1.Text) || x.Name.Contains(textBox1.Text) || x.Surname.Contains(textBox1.Text) || x.Phone.Contains(textBox1.Text) || x.Email.Contains(textBox1.Text) || x.Address.Contains(textBox1.Text)) && x.User_id == user ).ToList(); foreach (var item in tapilan) { id++; list = new ListViewItem(id.ToString()); list.SubItems.Add(item.Name); list.SubItems.Add(item.Surname); list.SubItems.Add(item.Email); list.SubItems.Add(item.Phone); list.SubItems.Add(item.Address); listView1.Items.Add(list); } } } } else if (panel1.Visible == true && panel2.Visible == true && panel3.Visible == false) { using (EntityModel db = new EntityModel()) { ListViewItem list; int id = 0; listView2.Items.Clear(); if (textBox1.Text == "") { var tapilan = db.orders.ToList().Where(x => x.User_id == user).ToList(); foreach (var item in tapilan) { id++; list = new ListViewItem(id.ToString()); list.SubItems.Add(item.Client_id.Name); list.SubItems.Add(item.Product_id.Name); list.SubItems.Add(item.Quantity.ToString()); list.SubItems.Add(item.OrderTime.ToString()); list.SubItems.Add(item.Arrive.ToString()); if (DateTime.Now > item.Arrive) { list.SubItems.Add("Ended"); } else if (DateTime.Now < item.Arrive) { list.SubItems.Add("Waiting"); } else if (DateTime.Now == item.Arrive) { list.SubItems.Add("Sending"); } listView2.Items.Add(list); } } else { var tapilan = db.orders.ToList().Where(x => (x.Id.ToString().Contains(textBox1.Text) || x.Arrive.ToString().Contains(textBox1.Text) || x.Client_id.Name.Contains(textBox1.Text) || x.Product_id.Name.Contains(textBox1.Text) || x.OrderTime.ToString().Contains(textBox1.Text) || x.Quantity.ToString().Contains(textBox1.Text)) && x.User_id == user ).ToList(); foreach (var item in tapilan) { id++; list = new ListViewItem(id.ToString()); list.SubItems.Add(item.Client_id.Name); list.SubItems.Add(item.Product_id.Name); list.SubItems.Add(item.Quantity.ToString()); list.SubItems.Add(item.OrderTime.ToString()); list.SubItems.Add(item.Arrive.ToString()); if (DateTime.Now > item.Arrive) { list.SubItems.Add("Ended"); } else if (DateTime.Now < item.Arrive) { list.SubItems.Add("Waiting"); } else if (DateTime.Now == item.Arrive) { list.SubItems.Add("Sending"); } listView2.Items.Add(list); } } } } else if (panel1.Visible == true && panel2.Visible == true && panel3.Visible == true) { using (EntityModel db = new EntityModel()) { ListViewItem list; int id = 0; listView3.Items.Clear(); if (textBox1.Text == "") { var tapilan = db.products.ToList().Where(x => x.User_id == user).ToList(); foreach (var item in tapilan) { id++; list = new ListViewItem(id.ToString()); list.SubItems.Add(item.Name); list.SubItems.Add(item.Price); list.SubItems.Add(item.Quantity.ToString()); list.SubItems.Add(item.Description); listView3.Items.Add(list); } } else { var tapilan = db.products.ToList().Where(x => (x.Id.ToString().Contains(textBox1.Text) || x.Name.Contains(textBox1.Text) || x.Description.Contains(textBox1.Text) || x.Quantity.ToString().Contains(textBox1.Text) || x.Price.Contains(textBox1.Text)) && x.User_id == user ).ToList(); foreach (var item in tapilan) { id++; list = new ListViewItem(id.ToString()); list.SubItems.Add(item.Name); list.SubItems.Add(item.Price); list.SubItems.Add(item.Quantity.ToString()); list.SubItems.Add(item.Description); listView3.Items.Add(list); } } } } }