call produrce mysql 2

public void InsertEmployee(string connect, string spName, int id, string fisrtName, string lastName, string midName, string mail, string code,DateTime date)
{
try
{
OpenConnection(connect);
MySqlCommand cmd = new MySqlCommand(spName, ObjCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("pid", id));
cmd.Parameters.Add(new MySqlParameter("pfirstname", fisrtName));
cmd.Parameters.Add(new MySqlParameter("plastname", lastName));
cmd.Parameters.Add(new MySqlParameter("pmidname", midName));
cmd.Parameters.Add(new MySqlParameter("pemail", mail));
cmd.Parameters.Add(new MySqlParameter("pcode", code));
cmd.Parameters.Add(new MySqlParameter("pdate", date));
cmd.ExecuteNonQuery();
Close_con();
}
catch (Exception ex)
{
System.Diagnostics.Debug.Write(ex.ToString());
}
}

public DataSet sp_get_employee()
{
open_Con();
SQLCommandGeneral s = new SQLCommandGeneral();
MySqlCommand myCommand = s.GenerateCommand(ObjCon, (MethodInfo)MethodBase.GetCurrentMethod(), new Object[] { });
MySqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
DataProcess dprocess = new DataProcess();
return dprocess.ConvertDataReaderToDataSet(result);
}