call produrce mysql

public DataTable CallStoreProcedure(string spName, bool ishptDB)
{
try
{
OpenConnection(ishptDB);
MySqlCommand cmd = new MySqlCommand(spName, ObjCon);
cmd.CommandType = CommandType.StoredProcedure;
MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DataProcess dProcess = new DataProcess();
DataTable tb = dProcess.ConvertDataReaderToDataTable(dr);
Close_con();
return tb;
}
catch (Exception ex)
{
System.Diagnostics.Debug.Write(ex.ToString());
return null;
}
}

public void UpdateEmployee(string connect,string spName,int id,string fisrtName,string lastName,string midName,string mail,string code)
{
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.ExecuteNonQuery();
Close_con();
}
catch (Exception ex)
{
System.Diagnostics.Debug.Write(ex.ToString());
}
}