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(); } }