protected void Page_Load(object sender, EventArgs e) { connection = new MySqlConnection("Server=localhost;Uid=root;Pwd=dadalus123;Database=pf;"); connection.Open(); command = new MySqlCommand(); command.Connection = connection; command.CommandText = "SELECT * FROM locationptpl"; reader = command.ExecuteReader(); while (reader.Read()) { campus ca = new campus(); ca.CamName = reader.GetString("CampusName"); ca.Ad1 = reader.GetString("AddressLine1"); ca.Ad2 = reader.GetString("AddressLine2"); ca.Ad3 = reader.GetString("AddressLine3"); ca.Teln = reader.GetString("Tel"); ca.Faxn = reader.GetString("Fax"); ca.MapIP = reader.GetString("MapAddress"); Arl.Add(ca); ca = null; } reader.Close(); reader.Dispose(); connection.Close(); connection.Dispose(); connection = null; }
public ActionResult DeleteConfirmed(int id) { campus campus = db.campuses.Find(id); db.campuses.Remove(campus); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "c_id,c_name,c_address,c_phone")] campus campus) { if (ModelState.IsValid) { db.Entry(campus).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(campus)); }
public ActionResult Edit([Bind(Include = "id,descripcion,estado")] campus campus) { if (ModelState.IsValid) { db.Entry(campus).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(campus)); }
public ActionResult Create([Bind(Include = "c_id,c_name,c_address,c_phone")] campus campus) { if (ModelState.IsValid) { db.campuses.Add(campus); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(campus)); }
public ActionResult Create([Bind(Include = "id,descripcion,estado")] campus campus) { if (ModelState.IsValid) { db.campus.Add(campus); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(campus)); }
// GET: campus/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } campus campus = db.campuses.Find(id); if (campus == null) { return(HttpNotFound()); } return(View(campus)); }
public campus getUserCoreCampus(users author) { campus campus = author.campus.Count() > 0 ? author.campus[0] : ActiveRecordBase <campus> .FindAllByProperty("name", "Pullman")[0]; return(campus); }