private void button3_Click(object sender, EventArgs e) { PharmacyData db = new PharmacyData(); IQueryable <Medicament> medsList = from b in db.Medicaments orderby b.Id select b; List <Medicament> medicaments = medsList.ToList(); foreach (Medicament medicament in medicaments) { if (medicament.MedName == "Paracetamol") { medicament.MedQuantity = medicament.MedQuantity - Data.ParacetamolQuantity; } if (medicament.MedName == "Algocalmin") { medicament.MedQuantity = medicament.MedQuantity - Data.AlgocalminQuantity; } if (medicament.MedName == "Coldrex") { medicament.MedQuantity = medicament.MedQuantity - Data.ColdrexQuantity; } if (medicament.MedName == "Vitamine") { medicament.MedQuantity = medicament.MedQuantity - Data.VitamineQuantity; } } db.SaveChanges(); Data.ParacetamolQuantity = 0; Data.AlgocalminQuantity = 0; Data.ColdrexQuantity = 0; Data.VitamineQuantity = 0; this.Hide(); Form comanda = new ComandaFinalizata(); comanda.Show(); }
private void registerButton_Click(object sender, EventArgs e) { /*if (usernameBox.Text != null && passwordBox.Text != null && confirmPasswordBox.Text != null &&!string.IsNullOrWhiteSpace(usernameBox.Text) && !string.IsNullOrWhiteSpace(passwordBox.Text)) * { * if (passwordBox.Text == confirmPasswordBox.Text && passwordBox.Text != null && !string.IsNullOrWhiteSpace(passwordBox.Text)) * { * /*var db = new PharmacyData(); * TbUser tbUser = new TbUser(); * tbUser.Username = usernameBox.Text; * tbUser.Password = passwordBox.Text; * db.TbUsers.Add(tbUser); * db.SaveChanges(); * PharmacyData db = new PharmacyData(); * IQueryable<TbUser> tbUsersList = from b in db.TbUsers * orderby b.Id * select b; * List<TbUser> tbUsers = tbUsersList.ToList(); * * foreach (TbUser tbUser in tbUsers) * { * if (tbUser.Username == usernameBox.Text && !string.IsNullOrWhiteSpace(usernameBox.Text)) * { * if (tbUser.Password == passwordBox.Text && !string.IsNullOrWhiteSpace(passwordBox.Text)) * { * * } * } * } * } * }*/ bool found = false; if (usernameBox.Text != null && passwordBox.Text != null && confirmPasswordBox.Text != null && !string.IsNullOrWhiteSpace(usernameBox.Text) && !string.IsNullOrWhiteSpace(passwordBox.Text)) { PharmacyData db = new PharmacyData(); IQueryable <TbUser> tbUsersList = from b in db.TbUsers orderby b.Id select b; List <TbUser> tbUsers = tbUsersList.ToList(); foreach (TbUser tbUser in tbUsers) { if (tbUser.Username == usernameBox.Text && !string.IsNullOrWhiteSpace(usernameBox.Text)) { found = true; MessageBox.Show("User already exists!"); } } } if (found == false) { if (passwordBox.Text == confirmPasswordBox.Text && passwordBox.Text != null && !string.IsNullOrWhiteSpace(passwordBox.Text)) { var db = new PharmacyData(); TbUser tbUser = new TbUser(); tbUser.Username = usernameBox.Text; tbUser.Password = passwordBox.Text; db.TbUsers.Add(tbUser); db.SaveChanges(); } } }