public List <SalesGroups> SelectG() { string query = "SELECT * FROM 0_groups"; List <SalesGroups> sGps = new List <SalesGroups>(); //Open connection if (this.OpenConnection() == true) { MySqlDataAdapter adapter = new MySqlDataAdapter(query, connection); DataSet ds = new DataSet(); adapter.Fill(ds, "0_groups"); this.CloseConnection(); //return list to be displayed foreach (DataRow pRow in ds.Tables["0_groups"].Rows) { SalesGroups s = new SalesGroups(); s.id = Convert.ToInt32(pRow["id"]); s.description = pRow["description"].ToString(); s.inactive = (bool)pRow["inactive"]; sGps.Add(s); } return(sGps); } return(null); }
public ActionResult DeleteConfirmed(int id) { SalesGroups salesGroups = db.SalesGroups.Find(id); db.SalesGroups.Remove(salesGroups); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,description,inactive")] SalesGroups salesGroups) { if (ModelState.IsValid) { db.Entry(salesGroups).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(salesGroups)); }
public ActionResult Create([Bind(Include = "id,description,inactive")] SalesGroups salesGroups) { if (ModelState.IsValid) { db.SalesGroups.Add(salesGroups); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(salesGroups)); }
// GET: SalesGroups/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SalesGroups salesGroups = db.SalesGroups.Find(id); if (salesGroups == null) { return(HttpNotFound()); } return(View(salesGroups)); }