// GET: Previouseradications/Create public ActionResult Create(int?id, string phone, int refid) { Previouseradication previouseradication = new Previouseradication(); previouseradication.Phone = phone; previouseradication.RefId = refid; return(View()); }
// GET: Previouseradications/Edit/5 public ActionResult Edit(int?id, int RfId) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Previouseradication previouseradication = new Previouseradication(); MySqlConnection mysql = getMySqlConnection(); MySqlCommand mySqlCommand = getSqlCommand("select * from previouseradication where id=" + id, mysql); mysql.Open(); MySqlDataReader reader = mySqlCommand.ExecuteReader(); try { while (reader.Read()) { if (reader.HasRows) { previouseradication.RefId = RfId; previouseradication.Id = reader.GetInt32("id"); previouseradication.Phone = reader.GetString("phone"); previouseradication.Radicationtime = reader.GetString("radicationtime"); previouseradication.Radicationdate = reader.GetDateTime("radicationdate"); previouseradication.Radicationcase = reader.GetString("radicationcase"); previouseradication.Course = reader.GetString("course"); previouseradication.Result = reader.GetString("result"); } } reader.Close(); } catch { return(HttpNotFound()); } finally { reader.Close(); } if (previouseradication == null) { return(HttpNotFound()); } return(View(previouseradication)); }
public ActionResult Edit([Bind(Include = "RefId,Id,Radicationtime,Radicationdate,Radicationcase,Course,Result")] Previouseradication previouseradication) { if (ModelState.IsValid) { string a = Request.Form["RefId"]; int b = Convert.ToInt32(a); MySqlConnection mysql = getMySqlConnection(); MySqlCommand mySqlCommand = getSqlCommand("UPDATE previouseradication set radicationtime=" + "'" + previouseradication.Radicationtime + "',radicationdate='" + previouseradication.Radicationdate + "',radicationcase='" + previouseradication.Radicationcase + "',course='" + previouseradication.Course + "',result='" + previouseradication.Result + "'" + "where id=" + previouseradication.Id, mysql); mysql.Open(); MySqlDataAdapter adapter = new MySqlDataAdapter(mySqlCommand); mySqlCommand.ExecuteNonQuery(); mysql.Close(); return(RedirectToAction("Details/" + b, "UserMangers")); } return(View(previouseradication)); }
public ActionResult Create([Bind(Include = "RefId,Id,Radicationtime,Radicationdate,Radicationcase,Course,Result")] Previouseradication previouseradication) { if (ModelState.IsValid) { string a = Request.Form["RefId"]; int b = Convert.ToInt32(a); previouseradication.Phone = Request.Form["Phone"]; MySqlConnection mysql = getMySqlConnection(); MySqlCommand mySqlCommand = getSqlCommand("INSERT INTO previouseradication(phone,radicationtime,radicationdate,radicationcase,course,result)VALUES" + "(" + "'" + previouseradication.Phone + "','" + previouseradication.Radicationtime + "','" + previouseradication.Radicationdate + "','" + previouseradication.Radicationcase + "','" + previouseradication.Course + "','" + previouseradication.Result + "'" + ")", mysql); mysql.Open(); MySqlDataAdapter adapter = new MySqlDataAdapter(mySqlCommand); mySqlCommand.ExecuteNonQuery(); mysql.Close(); return(RedirectToAction("Details/" + b, "UserMangers")); } return(View(previouseradication)); }