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();
}
