public string updateStudentByID(StudentDTO student)
{
try
{
MySqlConnection co = MConnect.getConnection();
co.Open();
string query = "update stud set fname=@a1 where sid=@a2";
MySqlCommand com = new MySqlCommand(query, co);
com.Parameters.AddWithValue("@a1", student.fname);
com.Parameters.AddWithValue("@a2", student.sid);
System.Console.WriteLine(com.ExecuteNonQuery());
}
catch (System.Exception e)
{
throw new System.Exception(e.Message);
}
finally{
}
return("Updated!");
}
public string InsertStudent(StudentDTO student)
{
try
{
MySqlConnection co = MConnect.getConnection();
co.Open();
string query = "insert into stud values(@a1,@a2,@a3)";
MySqlCommand com = new MySqlCommand(query, co);
com.Parameters.AddWithValue("@a1", student.sid);
com.Parameters.AddWithValue("@a2", student.fname);
com.Parameters.AddWithValue("@a3", student.dob);
com.ExecuteNonQuery();
}
catch (System.Exception e)
{
throw new System.Exception(e.Message);
}
finally{
}
return("inserted!");
}
static void Main(string[] args)
{
StudentDAO studentDAO = new StudentDAO();
// List<StudentDTO> students = studentDAO.GetStudentByID("1005");
// foreach (var item in students)
// {
// System.Console.WriteLine(item.fname + " " + item.sid + " " + item.dob);
// }
System.Console.WriteLine("Enter student details: sid fname dob");
StudentDTO student = new StudentDTO();
student.sid = Console.ReadLine();
student.fname = Console.ReadLine();
student.dob = Console.ReadLine();
// System.Console.WriteLine(studentDAO.InsertStudent(student));
// System.Console.WriteLine(studentDAO.InsertStudentUsingProcedure(student));
// System.Console.WriteLine(studentDAO.deleteStudentByID("1010"));
System.Console.WriteLine(studentDAO.updateStudentByID(student));
}
public string InsertStudentUsingProcedure(StudentDTO student)
{
try
{
MySqlConnection co = MConnect.getConnection();
co.Open();
string query = "p2";
MySqlCommand com = new MySqlCommand(query, co);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("a1", student.sid);
com.Parameters.AddWithValue("a2", student.fname);
com.Parameters.AddWithValue("a3", student.dob);
com.ExecuteNonQuery();
}
catch (System.Exception e)
{
throw new System.Exception(e.Message);
}
finally{
}
return("inserted!");
}