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