/// <summary>
/// Update the student details
/// </summary>
/// <param name="intStudentId"></param>
/// <param name="strStudentName"></param>
/// <param name="strGender"></param>
/// <param name="intAge"></param>
/// <returns></returns>
public int UpdateStudent(int intStudentId, string strStudentName, string strGender, int intAge)
{
using (MySqlConnection con = MyConnection.GetConnection())
{
con.Open();
string query = "UPDATE Students SET StudentName = @studname, StudentAge = @studage, " +
"StudentGender = @gender WHERE StudentId = @studid";
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@studname", strStudentName);
cmd.Parameters.AddWithValue("@studage", intAge);
cmd.Parameters.AddWithValue("@gender", strGender);
cmd.Parameters.AddWithValue("@studid", intStudentId);
return(cmd.ExecuteNonQuery());
}
}
public int InsertTrackingStates(string ipaddress, long duration, string controller, string action, long createdAt)
{
using (MySqlConnection conn = MyConnection.GetConnection())
{
conn.Open();
string query = "INSERT INTO TrackingList (IpAddress, Duration, Controller, Action, CreatedAt) VALUES(@item1, @item2, @item3, @item4, @item5)";
MySqlCommand cmd = new MySqlCommand(query, conn);
cmd.Parameters.AddWithValue("@item1", ipaddress);
cmd.Parameters.AddWithValue("@item2", duration);
cmd.Parameters.AddWithValue("@item3", controller);
cmd.Parameters.AddWithValue("@item4", action);
cmd.Parameters.AddWithValue("@item5", createdAt);
return(cmd.ExecuteNonQuery());
}
}