public ActionResult NuevoRegistro(TablaViewsModels Model)
{
try
{
if (ModelState.IsValid)
{
using (ConectionsDataBase dataBase = new ConectionsDataBase())
{
var persona = new Peoples();
persona.Nombre = Model.Nombre;
persona.Apellido = Model.Apellido;
persona.Edad = Model.Edad;
persona.Sexo = Model.Sexo;
persona.Correo = Model.Correo;
dataBase.Peoples.Add(persona);
dataBase.SaveChanges();
}
return(Redirect("/"));
}
return(View(Model));
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult ActualizarPersona(TablaViewsModels Model)
{
try
{
if (ModelState.IsValid)
{
using (ConectionsDataBase dataBase = new ConectionsDataBase())
{
var tabla = dataBase.Peoples.Find(Model.Id_person);
tabla.Nombre = Model.Nombre;
tabla.Apellido = Model.Apellido;
tabla.Edad = Model.Edad;
tabla.Sexo = Model.Sexo;
tabla.Correo = Model.Correo;
dataBase.Entry(tabla).State = EntityState.Modified;
dataBase.SaveChanges();
}
return(Redirect("/"));
}
return(View(Model));
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult BorrarPersona(int Id)
{
using (ConectionsDataBase dataBase = new ConectionsDataBase())
{
var tabla = dataBase.Peoples.Find(Id);
dataBase.Peoples.Remove(tabla);
dataBase.SaveChanges();
}
return(Redirect("/"));
}
/// <summary>
/// Retorno de por parametro de un registro
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult ActualizarPersona(int Id)
{
TablaViewsModels model = new TablaViewsModels();
using (ConectionsDataBase dataBase = new ConectionsDataBase())
{
var tabla = dataBase.Peoples.Find(Id);
model.Id_person = tabla.Id_person;
model.Nombre = tabla.Nombre;
model.Apellido = tabla.Apellido;
model.Edad = tabla.Edad;
model.Sexo = tabla.Sexo;
model.Correo = tabla.Correo;
}
return(View(model));
}
/// <summary>
/// Metodo para cargar los listados de la base de datos
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
List <ListTablaWievsModels> lst;
using (ConectionsDataBase dataBase = new ConectionsDataBase())
{
lst = (from d in dataBase.Peoples
select new ListTablaWievsModels
{
Id_person = d.Id_person,
Nombre = d.Nombre,
Apellido = d.Apellido,
Edad = d.Edad,
Sexo = d.Sexo,
Correo = d.Correo
}).ToList();
}
return(View(lst));
}
/// <summary>
/// Metodo para Exportar a Excel
/// </summary>
/// <returns></returns>
public FileResult DescargarCsv()
{
ConectionsDataBase dataBase = new ConectionsDataBase();
var fileName = "Listado_personas.csv";
var personas = dataBase.Peoples.ToList();
CsvExport Csv = new CsvExport();
foreach (var persona in personas)
{
Csv.AddRow();
Csv["ID"] = persona.Id_person;
Csv["Nombre"] = persona.Nombre;
Csv["Apellido"] = persona.Apellido;
Csv["Edad"] = persona.Edad;
Csv["Sexo"] = persona.Sexo;
Csv["Correo"] = persona.Correo;
}
return(File(Csv.ExportToBytes(), "application/csv;charset=utf-8", fileName));
}
