public void DtgConnect(object Grilla)
{
using (tareasEntities db = new tareasEntities())
{
((DataGridView)Grilla).DataSource = db.tareas.ToList();
}
}
//Metodo para Grabar una nueva Tarea
public string NTarea(object[] Textos, object Date)
{
string rpta = "";
try
{
using (tareasEntities db = new tareasEntities())
{
tareas tarea = new tareas();
tarea.titulo = ((TextBox)Textos[0]).Text;
tarea.descripcion = ((TextBox)Textos[1]).Text;
tarea.fecha = ((DateTimePicker)Date).Value;
tarea.telefono = Convert.ToInt32(((TextBox)Textos[2]).Text);
tarea.estado = "CREADO";
db.tareas.Add(tarea);
db.SaveChanges();
rpta = "OK";
}
return(rpta);
}
//cath para saber sobre error en Entity Framework
catch (DbEntityValidationException ex)
{
StringBuilder sb = new StringBuilder();
foreach (var failure in ex.EntityValidationErrors)
{
sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType());
foreach (var error in failure.ValidationErrors)
{
sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
sb.AppendLine();
}
}
throw new DbEntityValidationException(
"Entity Validation Failed - errors follow:\n" +
sb.ToString(), ex
); // Add the original exception as the innerException
}
catch (Exception e)
{
MessageBox.Show(e.Message);
rpta = e.Message;
return(rpta);
}
}