private void frmconferenace_Load(object sender, EventArgs e) { VibesDataSourceEntities entities = new VibesDataSourceEntities(); comboBox1.DataSource = entities.Tb_Customers.ToList(); comboBox1.ValueMember = "ID"; comboBox1.DisplayMember = "CustomerName"; comboBox2.DataSource = entities.Tb_Hotels.ToList(); comboBox2.ValueMember = "ID"; comboBox2.DisplayMember = "Name"; SelectData(entities); }
private void btnDelete_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(labid.Text)) { MessageBox.Show("Please Select Confereance", "Information", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { int ID = int.Parse(labid.Text); VibesDataSourceEntities entities = new VibesDataSourceEntities(); Tb_Conferences conferences = entities.Tb_Conferences.SingleOrDefault(a => a.ID == ID); entities.Tb_Conferences.Remove(conferences); if (entities.SaveChanges() > 0) { MessageBox.Show("The conferance has been deleted", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); SelectData(entities); } } }
private void btnEdit_Click(object sender, EventArgs e) { MyHelper helper = new MyHelper(); if (helper.EnableandUnEnableControls(this.groupBox1)) { } else { Tb_Conferences conferences = new Tb_Conferences(); conferences.ID = int.Parse(labid.Text); conferences.Name = txtname.Text; conferences.Persident_of_Conferences = txtpersident.Text; conferences.from = datefrom.Value; conferences.to = dateto.Value; conferences.introdaction = txtinroduced.Text; conferences.Note = txtNote.Text; conferences.customerid = Convert.ToInt32(comboBox1.SelectedValue); conferences.hotelid = Convert.ToInt32(comboBox2.SelectedValue); ValidationContext context = new ValidationContext(conferences); List <ValidationResult> list = new List <ValidationResult>(); if (Validator.TryValidateObject(conferences, context, list, true)) { VibesDataSourceEntities entities = new VibesDataSourceEntities(); entities.Entry <Tb_Conferences>(conferences).State = System.Data.Entity.EntityState.Modified; if (entities.SaveChanges() > 0) { MessageBox.Show("The conferance has been edited", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); SelectData(entities); } } else { foreach (var item in list) { MessageBox.Show(item.ErrorMessage, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void SelectData(VibesDataSourceEntities entities) { var select = from i in entities.Tb_Conferences.ToList() select new { i.ID, i.Name , i.Persident_of_Conferences , i.@from, i.to , i.introdaction , i.Note }; dataGridView1.DataSource = select.ToList(); dataGridView1.Columns[0].Visible = false; }
private void Add() { VibesDataSourceEntities entities = new VibesDataSourceEntities(); Tb_Conferences tb_Conferences = new Tb_Conferences() { Name = txtname.Text, Persident_of_Conferences = txtpersident.Text, from = datefrom.Value, to = dateto.Value, introdaction = txtinroduced.Text, customerid = Convert.ToInt32(comboBox1.SelectedValue), hotelid = Convert.ToInt32(comboBox2.SelectedValue), Note = txtNote.Text }; ValidationContext context = new ValidationContext(tb_Conferences); List <ValidationResult> list = new List <ValidationResult>(); if (Validator.TryValidateObject(tb_Conferences, context, list, true)) { entities.Tb_Conferences.Add(tb_Conferences); } else { foreach (var item in list) { MessageBox.Show(item.ErrorMessage, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } if (entities.SaveChanges() > 0) { MessageBox.Show("the Conferance has been added ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); SelectData(entities); } }