// POST api/values public string Post([FromBody] createstudent value) { student grdeclc = new student(); con = new MySqlConnection(" data source = localhost; initial catalog =practice311; userid = root; password ='' "); var query = "INSERT INTO `studentinfo`(`ID`, `fn`, `ln`, `course`) VALUES (@ID, @fn, @ln, @course)"; MySqlCommand com = new MySqlCommand(query, con); com.Parameters.AddWithValue("ID", value.ID); com.Parameters.AddWithValue("fn", value.fn); com.Parameters.AddWithValue("ln", value.ln); com.Parameters.AddWithValue("course", value.course); //com.Parameters.AddWithValue("year",value.yea); con.Open(); int result = com.ExecuteNonQuery(); if (result > 0) { return("Inserted"); } else { return("failed to insert"); } }
// PUT api/values/5 public string Put(int id, [FromBody] createstudent value) { con = new MySqlConnection(" data source = localhost; initial catalog =practice311; userid = root; password ='' "); var query = "UPDATE studentinfo SET `fn`=@fn, `ln`=@ln, `course`=@course WHERE ID=" + id; MySqlCommand com = new MySqlCommand(query, con); com.Parameters.AddWithValue("fn", value.fn); com.Parameters.AddWithValue("ln", value.ln); com.Parameters.AddWithValue("course", value.course); con.Open(); int result = com.ExecuteNonQuery(); if (result > 0) { return("updated"); } else { return("failed to update"); } }