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