private void Delete_button_Click(object sender, EventArgs e)
{
if (MetroFramework.MetroMessageBox.Show(this, "Вы точно хотите удалить?", "Сообщения", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
entiteState = EntiteState.Deleted;
try
{
Persons obj = personsBindingSource.Current as Persons;
if (obj != null)
{
using (var db = Db.FromConfig("cn"))
{
db.Sql("delete from Person1 where ID = @ID").WithParameters(new { obj.ID }).AsNonQuery();
personsBindingSource.RemoveCurrent();
PanelConteiner.Enabled = false;
ClearInput();
entiteState = EntiteState.Unchanged;
}
}
}
catch (Exception ex)
{
MetroFramework.MetroMessageBox.Show(this, ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void Save_button_Click(object sender, EventArgs e)
{
try
{
personsBindingSource.EndEdit();
Persons obj = personsBindingSource.Current as Persons;
if (obj != null)
{
using (var db = Db.FromConfig("cn"))
{
if (entiteState == EntiteState.Add)
{
obj.ID = db.Sql("insert into Person1(FullName,LastName,Gender,Bithday,Email,Addres,PhotoURL) values(@FullName, @LastName, @Gender, @Birthday, @Email, @Adress, @PhotoURL); select SCOPE_IDENTITY()").WithParameters(new { FullName = obj.FullName, LastName = obj.LastName, Email = obj.Email, Addres = obj.Addres, Gender = obj.Gender, Bithday = obj.Birthday, PhotoPic = obj.PhotoURL }).AsScalar <int>();
}
else if (entiteState == EntiteState.Changed)
{
db.StoredProcedure("Sp_Person1_Update").WithParameters(new { ID = obj.ID, FullName = obj.FullName, LastName = obj.LastName, Email = obj.Email, Addres = obj.Addres, Gender = obj.Gender, Bithday = obj.Birthday, PhotoPic = obj.PhotoURL }).AsNonQuery();
}
dataGrid.Refresh();
PanelConteiner.Enabled = false;
entiteState = EntiteState.Unchanged;
}
}
}
catch (Exception ex)
{
MetroFramework.MetroMessageBox.Show(this, ex.Message, "Сообщения", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Add_button_Click(object sender, EventArgs e)
{
entiteState = EntiteState.Add;
PhotoPic.Image = null;
PanelConteiner.Enabled = true;
personsBindingSource.Add(new Persons());
personsBindingSource.MoveLast();
FullName_textBox.Focus();
}
private void Edit_button_Click(object sender, EventArgs e)
{
entiteState = EntiteState.Changed;
PanelConteiner.Enabled = true;
FullName_textBox.Focus();
}
