private async void bunifuThinButton21_Click(object sender, EventArgs e) { using (THGLdbEntities tHGLdbEntities = new THGLdbEntities()) { var proion = tHGLdbEntities.Proion.Single(a => a.Barcode == @"sdgfsd"); proion.Onoma = "newName"; proion.Kathgoria = "xarti"; await tHGLdbEntities.SaveChangesAsync(); var pelatis = tHGLdbEntities.Pelatis.Single(a => a.Kwdikos_Pelati == ""); int?p = pelatis.Anakuklwnei.Sum(a => a.pontoi); //Proion proion = new Proion //{ // Barcode = bunifuMaterialTextbox1.Text, // Onoma = bunifuMaterialTextbox2.Text, // Kathgoria = bunifuDropdown1.selectedValue, // Pontoi = int.Parse(bunifuMaterialTextbox4.Text), // Anakuklwsimo = bunifuiOSSwitch1.Value ? "ΝΑΙ" : "ΟΧΙ", //}; //tHGLdbEntities.Proion.Add(proion); //await tHGLdbEntities.SaveChangesAsync(); } }
private void bunifuThinButton21_Click(object sender, EventArgs e) { using (THGLdbEntities tHGLdbEntities = new THGLdbEntities()) { var pelates = tHGLdbEntities.Pelatis.ToList().OrderByDescending(a => a.getPoints()).ThenBy(a => a.Onoma).Take(10).ToList(); dataGridView1.DataSource = pelates; } }
private void bunifuThinButton23_Click(object sender, EventArgs e) { using (THGLdbEntities tHGLdbEntities = new THGLdbEntities()) { var editPelatis = tHGLdbEntities.Pelatis.Single(a => a.Kwdikos_Pelati == bunifuMaterialTextbox1.Text); bunifuMaterialTextbox2.Text = editPelatis.Onoma; bunifuMaterialTextbox3.Text = editPelatis.Epitheto; //await tHGLdbEntities.SaveChangesAsync(); var pelates = tHGLdbEntities.Pelatis.OrderByDescending(a => a.getPoints()).ThenBy(a => a.Onoma).Take(10); //int? p = pelatis.Anakuklwnei.Sum(a => a.pontoi); } }
private async void bunifuThinButton21_Click(object sender, EventArgs e) { try { using (THGLdbEntities tHGLdbEntities = new THGLdbEntities()) { var editPelatis = tHGLdbEntities.Pelatis.Single(a => a.Kwdikos_Pelati == bunifuMaterialTextbox1.Text); editPelatis.Onoma = bunifuMaterialTextbox2.Text; editPelatis.Epitheto = bunifuMaterialTextbox3.Text; await tHGLdbEntities.SaveChangesAsync(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Exception Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/* private void clearForm() * { * foreach (Control control in Controls) * { * if (control is BunifuMaterialTextbox) * control.Text = string.Empty; * } * }*/ private async void bunifuThinButton21_Click(object sender, EventArgs e) { using (THGLdbEntities tHGLdbEntities = new THGLdbEntities()) { Pelatis pelatis = new Pelatis { Kwdikos_Pelati = bunifuMaterialTextbox1.Text, Onoma = bunifuMaterialTextbox2.Text, Epitheto = bunifuMaterialTextbox3.Text, Hm_gennisis = Convert.ToDateTime(bunifuMaterialTextbox4.Text), Poli = bunifuMaterialTextbox5.Text, Tk = bunifuMaterialTextbox6.Text, Dieuthinsi = bunifuMaterialTextbox7.Text, Thlefwno = bunifuMaterialTextbox8.Text, Sxolia = bunifuMaterialTextbox9.Text, Pontoi = int.Parse(bunifuMaterialTextbox10.Text), }; tHGLdbEntities.Pelatis.Add(pelatis); await tHGLdbEntities.SaveChangesAsync(); } this.ClearForm(); }