private void Save()
{
//using EF
using (DBPersonEntities db = new DBPersonEntities())
{
//Create a entity
if (id == null)
{
oPerson = new Person();
}
//Acess to data
oPerson.Id = int.Parse(this.txtDNI.Text);
oPerson.FirstName = txtFirstName.Text;
oPerson.LastName = txtLastName.Text;
oPerson.DateOfBirth = dtpDateOfBirth.Value;
oPerson.Age = txtAge.Text;
oPerson.Address = txtAdress.Text;
oPerson.City = txtCity.Text;
//Save in the tPerson
if (id == null)
{
db.People.Add(oPerson);
}
else
{
db.Entry(oPerson).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
Clean();
}
MessageBox.Show("Save Successfull");
}
private void Update()
{
using (DBPersonEntities db = new DBPersonEntities())
{
oPerson = db.People.Find(id);
txtDNI.Text = oPerson.Id.ToString();
txtFirstName.Text = oPerson.FirstName;
txtLastName.Text = oPerson.LastName;
dtpDateOfBirth.Value = oPerson.DateOfBirth;
txtAge.Text = oPerson.Age;
txtAdress.Text = oPerson.Address;
txtCity.Text = oPerson.City;
}
}
private void button3_Click(object sender, EventArgs e)
{
int?id = getId();
if (id != null)
{
using (DBPersonEntities db = new DBPersonEntities())
{
Person oPerson = db.People.Find(id);
db.People.Remove(oPerson);
db.SaveChanges();
}
Refresh();
}
}
private void Refresh()
{
using (DBPersonEntities db = new DBPersonEntities())
{
//Linq
var lst = from d in db.People
select d;
//if (!txtConsulta.Text.Trim().Equals(""))
//{
// lst = lst.Where(d => d.FirstName.Contains(txtConsulta.Text.Trim()));
//}
if (!txtConsulta.Text.Trim().Equals(""))
{
int id = int.Parse(txtConsulta.Text.Trim());
lst = lst.Where(d => d.Id == id);
}
dataGridView1.DataSource = lst.ToList();
}
}
