public bool ExecuteUpdateQuery(string query, Dictionary <string, object> parameters)
{
bool updated = false;
if (!IsConnectionOpened())
{
return(updated);
}
try {
FbCommand update = new FbCommand(query, connection);
if (parameters.Count > 0)
{
foreach (KeyValuePair <string, object> parameter in parameters)
{
update.Parameters.AddWithValue(parameter.Key, parameter.Value);
}
}
updated = update.ExecuteNonQuery() > 0 ? true : false;
} catch (Exception e) {
string subject = (Program.itemReport is null ? string.Empty : Program.itemReport.Type.ToString()) + " Ошибка выполнения запроса к БД";
string body = e.Message + Environment.NewLine + e.StackTrace;
SystemMail.SendMail(subject, body, Properties.Settings.Default.MailCopy);
Logging.ToLog(subject + " " + body);
connection.Close();
Program.hasError = true;
}
return(updated);
}
public DataTable GetDataTable(string query, Dictionary <string, object> parameters)
{
DataTable dataTable = new DataTable();
if (!IsConnectionOpened())
{
return(dataTable);
}
try {
using (FbCommand command = new FbCommand(query, connection)) {
if (parameters.Count > 0)
{
foreach (KeyValuePair <string, object> parameter in parameters)
{
command.Parameters.AddWithValue(parameter.Key, parameter.Value);
}
}
using (FbDataAdapter fbDataAdapter = new FbDataAdapter(command))
fbDataAdapter.Fill(dataTable);
}
} catch (Exception e) {
string subject = (Program.itemReport is null ? string.Empty : Program.itemReport.Type.ToString()) + " Ошибка выполнения запроса к БД";
string body = e.Message + Environment.NewLine + e.StackTrace;
SystemMail.SendMail(subject, body, Properties.Settings.Default.MailCopy);
Logging.ToLog(subject + " " + body);
connection.Close();
Program.hasError = true;
}
return(dataTable);
}
private bool IsConnectionOpened()
{
if (connection.State != ConnectionState.Open)
{
try {
connection.Open();
} catch (Exception e) {
string subject = "Ошибка подключения к БД";
string body = e.Message + Environment.NewLine + e.StackTrace;
SystemMail.SendMail(subject, body, Properties.Settings.Default.MailCopy);
Logging.ToLog(subject + " " + body);
}
}
return(connection.State == ConnectionState.Open);
}
private bool IsConnectionOpened()
{
if (connection.State != ConnectionState.Open)
{
try {
connection.Open();
} catch (Exception e) {
string subject = (Program.itemReport is null ? string.Empty : Program.itemReport.Type.ToString()) + " Ошибка подключения к БД";
string body = e.Message + Environment.NewLine + e.StackTrace;
SystemMail.SendMail(subject, body, Properties.Settings.Default.MailCopy);
Logging.ToLog(subject + " " + body);
Program.hasError = true;
}
}
return(connection.State == ConnectionState.Open);
}