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 dataGridView1_Click(object sender, EventArgs e)
{
Tb_Conferences conferences = new Tb_Conferences();
conferences.ID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
conferences.Name = dataGridView1.CurrentRow.Cells[1].Value.ToString();
conferences.Persident_of_Conferences = dataGridView1.CurrentRow.Cells[2].Value.ToString();
conferences.from = Convert.ToDateTime(dataGridView1.CurrentRow.Cells[3].Value);
conferences.to = Convert.ToDateTime(dataGridView1.CurrentRow.Cells[4].Value);
conferences.introdaction = dataGridView1.CurrentRow.Cells[5].Value.ToString();
if (dataGridView1.CurrentRow.Cells[6].Value != null)
{
conferences.Note = dataGridView1.CurrentRow.Cells[6].Value.ToString();
}
labid.Text = conferences.ID.ToString();
txtname.Text = conferences.Name;
txtpersident.Text = conferences.Persident_of_Conferences;
datefrom.Value = conferences.from;
dateto.Value = conferences.to;
txtinroduced.Text = conferences.introdaction;
txtNote.Text = conferences.Note;
}
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);
}
}
