public static MySqlConnection GetMySqlConnection()
{
if (connectionQueue.Count > 0)
{
lock (connectionQueue)
{
if (connectionQueue.Count > 0)
{
return(connectionQueue.Dequeue());
}
else
{
MySqlConnection conection = (MySqlConnection)baseConnection.Clone();
conection.Open();
return(conection);
}
}
}
else
{
MySqlConnection conection = (MySqlConnection)baseConnection.Clone();
conection.Open();
return(conection);
}
}
/// <summary>
/// تغییر وضعیت لیستی از رکوردها در مای اس کیو ال
/// </summary>
/// <param name="listDisabel">لیست شناسه ها</param>
/// <returns></returns>
public static bool UpdateTagRecordList(List <int> listDisabel)
{
string cs = @"server=localhost;port=3306;userid=ard;password=Ss987654;database=schooldb;SSL Mode = None";
using (var conn = new MySqlConnection(cs))
{
try
{
conn.Open();
foreach (var id in listDisabel)
{
var cmdString = $"update schooldb.tagrecive set Registered = '0' where ID = '{id}' ;";
var cmd = new MySqlCommand(cmdString, conn);
var result = cmd.ExecuteNonQuery();
}
conn.Clone();
return(true);
}
catch (Exception e)
{
Logger.WriteErrorLog(e, "UpdateTagRecordList");
conn.Clone();
return(false);
}
}
}
private static MySqlConnection GetMySqlConnection()
{
if (baseConnection == null)
{
baseConnection = new MySqlConnection(ConnectionString);
}
if (connectionQueue.Count > 0)
{
lock (connectionQueue)
{
if (connectionQueue.Count > 0)
{
return(connectionQueue.Dequeue());
}
else
{
MySqlConnection conection = (MySqlConnection)baseConnection.Clone();
conection.Open();
return(conection);
}
}
}
else
{
MySqlConnection conection = (MySqlConnection)baseConnection.Clone();
conection.Open();
return(conection);
}
}
public void Insert(DataSet dataSet)
{
var insertQuery = $"INSERT INTO {_dbName}.{_tableName} ({String.Join(",", _columns.Select(c => c.Name))})";
var values = String.Join(",", dataSet.Rows.Select(row =>
{
var rowStr = "";
for (var i = 0; i < row.Columns.Length; i++)
{
rowStr += ToMySqlValue(row.Values[i], row.Columns[i]);
if (i < row.Columns.Length - 1)
{
rowStr += ",";
}
}
return($"({rowStr})");
}));
insertQuery += $"VALUES {values};";
using (var connection = (MySqlConnection)_connection.Clone())
{
connection.Open();
var cmd = new MySqlCommand(insertQuery, connection);
cmd.ExecuteNonQuery();
}
}
/// <summary>
/// خواندن ثبت جدید از بانک مای اس کیوال
/// </summary>
/// <returns></returns>
public static List <View_TagList> ReaderSQL()
{
string cs = @"server=localhost;port=3306;userid=ard;password=Ss987654;database=schooldb;SSL Mode = None";
var list = new List <View_TagList>();
using (var conn = new MySqlConnection(cs))
{
try
{
conn.Open();
var cmdString = "SELECT * FROM schooldb.tagrecive where Registered = '1'";
var cmd = new MySqlCommand(cmdString, conn);
var result = cmd.ExecuteReader();
while (result.Read())
{
list.Add(new View_TagList()
{
ID = result.GetInt32(0),
Tag = result.GetString(1),
dateRegister = result.GetDateTime(2),
Reg = result.GetInt32(3),
TypeImport = result.GetInt32(4),
});
}
conn.Clone();
return(list);
}
catch (Exception e)
{
Logger.WriteErrorLog(e, "ReaderSQL");
conn.Clone();
return(null);
}
}
}
public async Task <DbGuild> FetchDbGuildAsync(ulong id)
{
var cached = DbGuild.GuildCache.GetCached(id);
if (cached != null)
{
return(cached);
}
var con = (MySqlConnection)_baseConnection.Clone();
await con.OpenAsync();
var cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Guilds WHERE guildId=@Id;";
cmd.Parameters.AddWithValue("Id", id);
var reader = await cmd.ExecuteReaderAsync();
if (!reader.HasRows)
{
return(null);
}
await reader.ReadAsync();
return(DbGuild.GuildCache.AddToCache(new DbGuild(reader)));
}
public static void AddMaintenance(Maintenance maintenance)
{
MySqlConnection currentBDD = new MySqlConnection(ConfigurationManager.ConnectionStrings["connexionString"].ConnectionString);
string sqlinsert = "INSERT INTO maintenance (incident_id, start_date, planned_date) VALUES (@incident_id, @dateDebut, @dateEstimee);";
using (MySqlCommand cmd = new MySqlCommand(sqlinsert, currentBDD))
{
cmd.Parameters.AddWithValue("@incident_id", maintenance.Incident.Id);
cmd.Parameters.AddWithValue("@dateDebut", maintenance.start_date);
cmd.Parameters.AddWithValue("@dateEstimee", maintenance.planned_date);
currentBDD.Open();
int result = cmd.ExecuteNonQuery();
currentBDD.Close();
}
string sqlinsert2 = "UPDATE `plane` SET `state_id`= (Select id from state where libelle = \"En maintenance\") WHERE id = @plane_id;";
using (MySqlCommand cmd = new MySqlCommand(sqlinsert2, currentBDD))
{
cmd.Parameters.AddWithValue("@plane_id", maintenance.Plane.Id);
currentBDD.Open();
int result = cmd.ExecuteNonQuery();
currentBDD.Clone();
}
int id;
string sqlinsert3 = "SELECT id FROM maintenance WHERE end_date is NULL Order by id desc LIMIT 1";
MySqlCommand cmd3 = new MySqlCommand(sqlinsert3, currentBDD);
using (MySqlDataReader rdr = cmd3.ExecuteReader())
{
rdr.Read();
id = Convert.ToInt32(rdr[0]);
}
foreach (Employee employee in maintenance.Employees)
{
string sqlinsert4 = "INSERT INTO maintenance_employee (employee_id, maintenance_id, responsible) VALUES (@idEmploye, @id, @responsable);";
using (MySqlCommand cmd2 = new MySqlCommand(sqlinsert4, currentBDD))
{
cmd2.Parameters.AddWithValue("@idEmploye", employee.Id);
cmd2.Parameters.AddWithValue("@id", id);
if (maintenance.Responsible.Id == employee.Id)
{
cmd2.Parameters.AddWithValue("@responsable", 1);
}
else
{
cmd2.Parameters.AddWithValue("@responsable", 0);
}
int result = cmd2.ExecuteNonQuery();
currentBDD.Clone();
}
}
}
public DataTable leerDatosEmpleado()
{
DataTable datos = new DataTable();
conexion();
MySqlCommand comando = new MySqlCommand("Select * from empleado", conectar);
MySqlDataAdapter adaptador = new MySqlDataAdapter(comando);
DataSet ds = new DataSet();
adaptador.Fill(ds, "empleado");
datos = ds.Tables["empleado"];
conectar.Clone();
return(datos);
}
public Herbaceous Create(Herbaceous t)
{
MySqlConnection conn = DB.DBUtils.GetDBConnection();
conn.OpenAsync();
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText =
"INSERT INTO warehouse.herbaceous(HerbaceousType,DealerCountry,Price,Count) VALUES(?Herbaceous,?DealerCountry,?Price,?Count)";
cmd.Connection = conn;
cmd.Parameters.Add("?Price", MySqlDbType.VarChar).Value = t.Price;
cmd.Parameters.Add("?Count", MySqlDbType.VarChar).Value = t.Count;
cmd.Parameters.Add("?Herbaceous", MySqlDbType.VarChar).Value = t.Type;
cmd.Parameters.Add("?DealerCountry", MySqlDbType.VarChar).Value = t.Country;
cmd.ExecuteNonQueryAsync();
conn.Clone();
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(t);
}
//*******************************************************************************************************//
// //
// //
// Metodo //
// //
// //
//*******************************************************************************************************//
//*******************************************************************************************************//
// //
// //
// Excluir //
// //
// //
//*******************************************************************************************************//
#region Exclir
private void excluiID()
{
try
{
//abrindo servirdor
conexao = new MySqlConnection("Server=localhost;Database=loja;User Id=root;");
//comando mySQL com parametros
stringSQL = "DELETE FROM dados WHERE email = @email";
comando = new MySqlCommand(stringSQL, conexao);
comando.Parameters.AddWithValue("@email", txtEmail.Text);
//abrindo servidor
conexao.Open();
//executando o comando
comando.ExecuteNonQuery();
}
catch (Exception ex)
{
//mensagem de erro
MessageBox.Show(ex.Message);
}
finally
{
//fechando servidor
conexao.Clone();
conexao = null;
comando = null;
}
}
private void button2_Click(object sender, EventArgs e)
{
if (ad.Text.Trim() == "" || soyad.Text.Trim() == "")
{
MessageBox.Show("Lütfen ad ve soyad kısmını boş bırakmayınız");
}
else
{
try
{
MySqlConnection baglanti = new MySqlConnection(Sinif_cek.baglan());
string Query = "UPDATE uyeler SET ad = '" + ad.Text + "',soyad='" + soyad.Text + "' WHERE ogrenci_no = " + ogr_no.Text + "";
MySqlCommand MyCommand2 = new MySqlCommand(Query, baglanti);
MySqlDataReader MyReader2;
baglanti.Open();
MyReader2 = MyCommand2.ExecuteReader();
baglanti.Close();
MessageBox.Show("Bilgiler Güncellendi.");
sifre.Text = "";
ad.Text = "";
soyad.Text = "";
ogr_no.Text = "";
sifre_tekrar.Text = "";
baglanti.Clone();
ogrencileri_cek();
textBox1.Text = "";
textBox1.Focus();
}
catch
{
MessageBox.Show("Hata!");
}
}
}
//*******************************************************************************************************//
// //
// //
// Excluir //
// //
// //
//*******************************************************************************************************//
#region Excluir
private void ExcluirDados()
{
InformaID();
exibir();
try
{
conexao = new MySqlConnection("Server=localhost;Database=loja;User Id=root;");
stringSQL = "DELETE FROM produtos WHERE id_produto = @id_produto";
comando = new MySqlCommand(stringSQL, conexao);
comando.Parameters.AddWithValue("@id_produto", NumUDID2.Value);
conexao.Open();
comando.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conexao.Clone();
conexao = null;
comando = null;
}
}
//méthode qui vérifie l'identifiant et le mot de passe
public bool VerifUser(string id, string mdp)
{
string req = "SELECT * FROM utilisateur;";
List <string> identifiants = new List <string>();
List <string> mdps = new List <string>();
conn = new MySqlConnection(cs);
MySqlCommand cmd = new MySqlCommand(req, conn);
//ouverture de la connexion de l'objet portant les attributs contenu dans la variable cs (string)
conn.Open();
//on stocke dans un objet MySqlReader les resultats de la requete
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
//liste.Add(reader[0].ToString());//on affecte dynamiquement l'élément pointé dans la liste
identifiants.Add(reader["adresse_mail"].ToString());
mdps.Add(reader["password"].ToString());
}
for (int i = 0; i < identifiants.Count; i++)
{
if (identifiants[i] == id && mdps[i] == mdp)
{
conn.Clone();
return(true);
}
}
conn.Close();
return(false);
}
//*******************************************************************************************************//
// //
// //
// Exibir //
// //
// //
//*******************************************************************************************************//
#region Exibir
//exibe as informações dos clientes no datagridview
private void exibir()
{
try
{
conexao = new MySqlConnection("Server=localhost;Database=loja;User Id=root;");
conexaoSQL.PagamentosExibirConSQL();
MySqlCommand comando = new MySqlCommand(conexaoSQL.PagamentosExibirConSQL(), conexao);
DataTable dt = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter(comando);
da.Fill(dt);
dgvCaixa.DataSource = dt;
conexao.Open();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conexao.Clone();
conexao = null;
comando = null;
}
}
internal static void SetUserInfo(int ID)
{
//create connection and open it
MySqlConnection connection = DbInfo.Connection();
//try to connect to database
try
{
//Build Mysql command
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText =
"SELECT `ID`, `Firstname`, `Middlename`, `Lastname`, `Email`, `Password`, `Pin` FROM `users` WHERE `ID`=" + ID;
MySqlDataReader reader = cmd.ExecuteReader();
//if match is found
if (reader.Read())
{
//MessageBox.Show(reader["Firstname"] + " "+ reader["Middlename"].ToString());
Userinformation = new userinf(ID, reader["Firstname"].ToString(), reader["Middlename"].ToString(), reader["Lastname"].ToString(), reader["Email"].ToString());
}
}
//finally
finally
{
//check state and clone
if (connection.State == ConnectionState.Open)
{
connection.Clone();
}
}
}
public void InsertListwa(string symbol, string material, string kolor, bool ornament, string okleina, float kosztMb)
{
MySqlConnection connection = new MySqlConnection(MyConnectionString);
MySqlCommand cmd;
connection.Open();
try
{
cmd = connection.CreateCommand();
cmd.CommandText = "INSERT INTO listwa(symbol,material,kolor,ornament,okleina,kosztMb)VALUES(@symbol,@material,@kolor,@ornament,@okleina,@kosztMb)";
cmd.Parameters.AddWithValue("@symbol", symbol);
cmd.Parameters.AddWithValue("@material", material);
cmd.Parameters.AddWithValue("@kolor", kolor);
cmd.Parameters.AddWithValue("@ornament", ornament);
cmd.Parameters.AddWithValue("@okleina", okleina);
cmd.Parameters.AddWithValue("@kosztMb", kosztMb);
//cmd.Parameters.AddWithValue("@ornament");
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Clone();
}
}
}
public static Boolean HasOnDatabase(Int32 Id)
{
String connectionString = DatabaseControl.GetConnectionString();
MySqlConnection conn = new MySqlConnection(connectionString);
try
{
var command = conn.CreateCommand();
MySqlDataReader rdr = null;
conn.Open();
string stm = String.Format("SELECT * FROM md_propertydetails WHERE ID={0}", Id);
MySqlCommand cmd = new MySqlCommand(stm, conn);
rdr = cmd.ExecuteReader();
Int32 count = 0;
while (rdr.Read())
{
count++;
break;
}
return(count > 0);
}catch (Exception ex)
{
}
finally
{
conn.Clone();
}
return(false);
}
//*******************************************************************************************************//
// //
// //
// Editar //
// //
// //
//*******************************************************************************************************//
#region Editar
private void edit()
{
InformaID();
exibir();
try
{
conexao = new MySqlConnection("Server=localhost;Database=loja;User Id=root;");
stringSQL = "UPDATE produtos SET destribuidor = @destribuidor, marca = @marca, descricao_produto = @descricao_produto, tamanho_produto = @tamanho_produto" +
", sexo = @sexo, quantidade = @quantidade, preco = @preco, precoCliente = @precoCliente WHERE id_produto = @id_produto";
comando = new MySqlCommand(stringSQL, conexao);
parametros();
conexao.Open();
comando.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conexao.Clone();
conexao = null;
comando = null;
}
}
private void BotonAgregar_Click(object sender, EventArgs e)
{
//try
//{
//varialbes para iinsertar en la base de datos
int numero = Convert.ToInt32(ComboNumero1.Text);
string tipos = ComboTipo1.Text;
int numerocamas = Convert.ToInt32(ComboNumeroCama.Text);
string tipocama = ComboTipoCama1.Text;
int capcadidad = Convert.ToInt32(ComboCapacidad1.Text);
decimal tarifa = Convert.ToDecimal(TxtTarifa1.Text);
// conexion con la base de datos
MySql.Data.MySqlClient.MySqlConnection conexion = new MySqlConnection(); //objeto
string cadenaConexion = "server=192.168.1.50; uid=daviduxotto; pwd=daviduxotto; Port=3306; database=BDHotel";
conexion.ConnectionString = cadenaConexion;
conexion.Open(); // abrimos conezion
String consulta = "update Habitacion set Tipo='" +tipos + "', NumeroCamas=" + numerocamas + ",TipoCama='" + tipocama + "', Capacidad=" + capcadidad + ", Tarifa=" + tarifa + " where Id="+numero; // realizamos consulta
MySqlCommand comando = new MySqlCommand(consulta, conexion);
comando.ExecuteReader();
conexion.Clone();
MessageBox.Show("se ha actualizado con exito");
habitaciones habitacion = new habitaciones();
habitacion.Show();
this.Close();
// }
//catch (Exception ex)
// {
// MessageBox.Show("se ha producido un error: " + ex);
//}
}
//guarda la nueva tela en la base de datos
private void btn_guardar_Click(object sender, EventArgs e)
{
if (validarcampos() == true)
{
limpiariconos();
try
{
conectar.Open();
costo = Convert.ToInt32(tex_valor.Text);
codigo = "INSERT INTO telas (Nombre,Metros,Costo) VALUES ('" + tex_nombre_tela.Text + "','" + tex_metros.Text + "','" + costo + "')";
MySqlCommand insertar = new MySqlCommand(codigo, conectar);
insertar.ExecuteNonQuery();
}
catch (Exception er)
{
MessageBox.Show("Hubo un Error " + er.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
conectar.Clone();
MessageBox.Show("Se Creo La Tela con Exito", "Creación Exitosa", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Limpiar();
}
else
{
MessageBox.Show("Por favor Diligenciar Los Campos Requeridos ", "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void BotonAgregar_Click(object sender, EventArgs e)
{
//try
//{
//varialbes para iinsertar en la base de datos
int numero = Convert.ToInt32(ComboCodigo2.Text);
string nombre = ComboTipo.Text;
decimal precio = Convert.ToDecimal(TxtTarifa.Text);
// conexion con la base de datos
MySql.Data.MySqlClient.MySqlConnection conexion = new MySqlConnection(); //objeto
string cadenaConexion = "server=192.168.1.50; uid=daviduxotto; pwd=daviduxotto; Port=3306; database=BDHotel";
conexion.ConnectionString = cadenaConexion;
conexion.Open(); // abrimos conezion
String consulta = "update Comida set Nombre='" + nombre + "', Precio=" + precio + " where Id=" + numero; // realizamos consulta
MySqlCommand comando = new MySqlCommand(consulta, conexion);
comando.ExecuteReader();
conexion.Clone();
MessageBox.Show("se ha actualizado con exito");
ComidasPrincipal comida = new ComidasPrincipal();
comida.Show();
this.Close();
// }
//catch (Exception ex)
// {
// MessageBox.Show("se ha producido un error: " + ex);
//}
}
//*******************************************************************************************************//
// //
// //
// Metodo //
// //
// //
//*******************************************************************************************************//
//*******************************************************************************************************//
// //
// //
// Excluir //
// //
// //
//*******************************************************************************************************//
#region Exclir
//Exclui pedido realizado apartir do email
private void excluiID()
{
try
{
conexao = new MySqlConnection("Server=localhost;Database=loja;User Id=root;");
conexaoSQL.PagamentosExcluiConSQL();
comando = new MySqlCommand(conexaoSQL.PagamentosExcluiConSQL(), conexao);
comando.Parameters.AddWithValue("@email", txtEmail.Text);
conexao.Open();
comando.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conexao.Clone();
conexao = null;
comando = null;
}
}
void ConsultarID()
{
try
{
conexao = new MySqlConnection("Server=localhost;Database=Server=localhost;Database=Alunos;User Id=root;User Id=root;");
consql.StringNota();
comando = new MySqlCommand(consql.StringNota(), conexao);
comando.Parameters.AddWithValue("@nome", txtNomeAluno.Text);
conexao.Open();
Dr = comando.ExecuteReader();
while (Dr.Read())
{
numUDAdobe.Value = Convert.ToInt32(Dr["notaAdobe"]);
numUDCisco.Value = Convert.ToInt32(Dr["notaCisco"]);
numUDLinux.Value = Convert.ToInt32(Dr["notaLinux"]);
numUDMicrosoft.Value = Convert.ToInt32(Dr["notaMicrosoft"]);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conexao.Clone();
conexao = null;
comando = null;
}
}
private void buttonEx1_Click(object sender, EventArgs e)
{
MySqlConnection connection = new MySqlConnection(MyConnectionString);
connection.Open();
try
{
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT EMPLOYEE_ID,NAME FROM hr_employee";
MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds);
dataGridViewEx1.DataSource = ds.Tables[0].DefaultView;
Mes.Core.Service.MessageService.ShowMessage("show message");
Mes.Core.Utility.BindDataUtil.comboBoxBindData(Mes.Core.ApplicationObject.ComboBoxInitType.SQL, "SELECT NAME FROM hr_employee", this.comboBoxEx1);
Mes.Core.Utility.BindDataUtil.comboBoxBindData(Mes.Core.ApplicationObject.ComboBoxInitType.FASTWITHNULL, "SYS_LANGUAGE", this.comboBoxEx1);
}
catch (Exception)
{
throw;
}
finally {
if (connection.State == ConnectionState.Open)
{
connection.Clone();
}
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
//Execute 执行
using (var connection = new MySqlConnection(conn))
{
var result = connection.Execute("insert into admin set FUserName=@FUserName,ApiUrl=@ApiUrl", new[] { new { FUserName = "******", ApiUrl = "222" }, new { FUserName = "******", ApiUrl = "2" } });
}
//WithTran 事务
string sql1 = "delete from admin where FUserName<>'000000'";
string sql2 = "ErrorSQL delete from admin where FUserName<>'000000'";
using (var connection = new MySqlConnection(conn))
{
connection.Open();
MySqlTransaction transaction = connection.BeginTransaction();
try
{
connection.Execute(sql1, null, transaction);
connection.Execute(sql2, null, transaction);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
finally
{
transaction.Dispose();
connection.Clone();
}
}
}
public DataTable SelectFuncionario(string campo)
{
try
{
conexao = new MySqlConnection();
string cs = "server=localhost;User id=root;password='';database=db_lojaRoupa";
conexao.ConnectionString = cs;
conexao.Open();
string query = "select * from tb_funcionario where cpfFunc ='" + campo + "'";
MySqlDataAdapter adapter = new MySqlDataAdapter(query, conexao);
DataSet ds = new DataSet();
adapter.Fill(ds);
conexao.Clone();
return(ds.Tables[0]);
}
catch (Exception erro)
{
throw erro;
}
}
public Pork Create(Pork t)
{
MySqlConnection conn = DB.DBUtils.GetDBConnection();
conn.OpenAsync();
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "INSERT INTO warehouse.pork(MeatFactoryName,MeatProductType,Price,Count) VALUES(?MeatProductType,?MeatFactoryName,?Price,?Count)";
cmd.Connection = conn;
cmd.Parameters.Add("?Price", MySqlDbType.VarChar).Value = t.Price;
cmd.Parameters.Add("?Count", MySqlDbType.VarChar).Value = t.Count;
cmd.Parameters.Add("?MeatFactoryName", MySqlDbType.VarChar).Value = t.MeatFactoryName;
cmd.Parameters.Add("?MeatProductType", MySqlDbType.VarChar).Value = t.MeatProductType;
cmd.ExecuteNonQueryAsync();
conn.Clone();
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(t);
}