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