public ActionResult DeleteConfirmed(int id)
{
ConfigCorreo configCorreo = db.ConfigCorreos.Find(id);
db.ConfigCorreos.Remove(configCorreo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "IDConfig,correo,contrasena,host,puerto,hora,minutos")] ConfigCorreo configCorreo)
{
if (ModelState.IsValid)
{
db.Entry(configCorreo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(configCorreo));
}
public ActionResult Create([Bind(Include = "IDConfig,correo,contrasena,host,puerto,hora,minutos")] ConfigCorreo configCorreo)
{
if (ModelState.IsValid)
{
db.ConfigCorreos.Add(configCorreo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(configCorreo));
}
// GET: ConfigCorreos/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ConfigCorreo configCorreo = db.ConfigCorreos.Find(id);
if (configCorreo == null)
{
return(HttpNotFound());
}
return(View(configCorreo));
}
public List <ConfigCorreo> GetAllConfigCorreo()
{
string cadena = "SELECT remitente ,"
+ " password,"
+ " puerto ,"
+ " id,"
+ " host "
+ " FROM CONFIG_CORREO ";
try
{
List <ConfigCorreo> listaConfigCorreo = new List <ConfigCorreo>();
//using (NpgsqlConnection con = new NpgsqlConnection(connectionString))
{
NpgsqlCommand cmd = new NpgsqlCommand(cadena.Trim(), con);
con.Open();
NpgsqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ConfigCorreo configCorreo = new ConfigCorreo();
configCorreo.id = Convert.ToInt32(rdr["id"]);
configCorreo.remitente = rdr["remitente"].ToString().Trim();
configCorreo.password = rdr["password"].ToString().Trim();
configCorreo.puerto = Convert.ToInt32(rdr["puerto"]);
configCorreo.host = rdr["host"].ToString().Trim();
listaConfigCorreo.Add(configCorreo);
}
con.Close();
}
return(listaConfigCorreo);
}
catch (Exception ex)
{
con.Close();
throw ex;
}
finally
{
con.Close();
}
}
