public ActionResult DeleteConfirmed(int id)
{
WebManger webManger = new WebManger();
MySqlConnection mysql = getMySqlConnection();
MySqlCommand mySqlCommand = getSqlCommand("DELETE FROM webmanger where id=" + id, mysql);
mysql.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter(mySqlCommand);
mySqlCommand.ExecuteNonQuery();
mysql.Close();
return(RedirectToAction("Index"));
}
// GET: WebMangers
public ActionResult Index(int page = 1)
{
List <WebManger> listwebManger = new List <WebManger>();
MySqlConnection mysql = getMySqlConnection();
MySqlCommand mySqlCommand = getSqlCommand("select * from webmanger", mysql);
mysql.Open();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
var i = 0;
try
{
while (reader.Read())
{
if (reader.HasRows)
{
WebManger webmanger = new WebManger();
webmanger.Id = reader.GetInt32("id");
webmanger.Account = reader.GetString("account");
webmanger.Password = reader.GetString("password");
webmanger.Name = reader.GetString("name");
webmanger.webkind = reader.GetInt32("webkind");
webmanger.modify = reader.GetInt32("modif");
webmanger.delete = reader.GetInt32("delet");
webmanger.insert = reader.GetInt32("inser");
webmanger.daochu = reader.GetInt32("daochu");
listwebManger.Add(webmanger);
//db.WebMangers.Add(webmanger);
i = i + 1;
}
}
}
catch
{
return(HttpNotFound());
}
finally
{
mysql.Close();
}
const int pagesize = 5;
var data = listwebManger
.OrderBy(p => p.Id).ToPagedList(page, pagesize);
return(View(data));
}
// GET: WebMangers/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
WebManger webManger = new WebManger();
MySqlConnection mysql = getMySqlConnection();
MySqlCommand mySqlCommand = getSqlCommand("select * from webmanger where id=" + id, mysql);
mysql.Open();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
webManger.Id = reader.GetInt32("id");
webManger.Account = reader.GetString("account");
webManger.Password = reader.GetString("password");
webManger.Name = reader.GetString("name");
webManger.webkind = reader.GetInt32("webkind");
webManger.modify = reader.GetInt32("modif");
webManger.delete = reader.GetInt32("delet");
webManger.insert = reader.GetInt32("inser");
webManger.daochu = reader.GetInt32("daochu");
}
}
reader.Close();
}
catch
{
return(HttpNotFound());
}
finally
{
reader.Close();
}
if (webManger == null)
{
return(HttpNotFound());
}
return(View(webManger));
}
public ActionResult Edit(WebManger webManger)
{
if (ModelState.IsValid)
{
MySqlConnection mysql = getMySqlConnection();
MySqlCommand mySqlCommand = getSqlCommand("UPDATE webmanger set account=" +
"'" + webManger.Account + "'" + ",password="******"'" + webManger.Password + "'" + ",name=" +
"'" + webManger.Name + "',webkind=" + webManger.webkind + ",modif=" + webManger.modify +
",delet=" + webManger.delete + ",inser=" + webManger.insert + ",daochu=" + webManger.daochu
+ " where id=" + webManger.Id, mysql);
mysql.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter(mySqlCommand);
mySqlCommand.ExecuteNonQuery();
mysql.Close();
return(RedirectToAction("Index"));
}
return(View(webManger));
}
public ActionResult Create(WebManger webManger)
{
if (ModelState.IsValid)
{
MySqlConnection mysql = getMySqlConnection();
MySqlCommand mySqlCommand = getSqlCommand("INSERT INTO webmanger(account,password,name,webkind,modif,delet,inser,daochu)" +
"VALUES" + "('" + webManger.Account + "','" + webManger.Password + "','" +
webManger.Name + "'," + webManger.webkind + "," + webManger.modify + "," +
webManger.delete + "," + webManger.insert + "," + webManger.daochu + ")", mysql);
mysql.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter(mySqlCommand);
mySqlCommand.ExecuteNonQuery();
mysql.Close();
return(RedirectToAction("Index"));
}
return(View(webManger));
}
public ActionResult Index(string Account, string Name, int page = 1)
{
List <WebManger> listwebManger1 = new List <WebManger>();
MySqlConnection mysql = getMySqlConnection();
string con;
if (Account == "" && Name == "")
{
con = "select * from webmanger";
}
else if (Account != "" && Name != "")
{
con = "select * from webmanger where (account " +
"like" + "'%" + Account + "%'" + "and name like " + "'%" + Name + "%')";
}
else if (Account != "" && Name == "")
{
con = "select * from webmanger where account " +
"like" + "'%" + Account + "%'";
}
else
{
con = "select * from webmanger where " +
" Name like " + "'%" + Name + "%'";
}
MySqlCommand mySqlCommand = getSqlCommand(con, mysql);
mysql.Open();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
var i = 0;
try
{
while (reader.Read())
{
if (reader.HasRows)
{
WebManger webmanger1 = new WebManger();
webmanger1.Id = reader.GetInt32("id");
webmanger1.Account = reader.GetString("account");
webmanger1.Password = reader.GetString("password");
webmanger1.Name = reader.GetString("name");
webmanger1.webkind = reader.GetInt32("webkind");
webmanger1.modify = reader.GetInt32("modif");
webmanger1.delete = reader.GetInt32("delet");
webmanger1.insert = reader.GetInt32("inser");
webmanger1.daochu = reader.GetInt32("daochu");
listwebManger1.Add(webmanger1);
//db.WebMangers.Add(webmanger);
i = i + 1;
}
}
}
catch
{
return(HttpNotFound());
}
finally
{
mysql.Close();
}
const int pagesize = 5;
var data = listwebManger1
.OrderBy(p => p.Id).ToPagedList(page, pagesize);
return(View(data));
//return View(listwebManger1);
}
