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