private void UsingSql(object sender, RoutedEventArgs e)
{
if (SQLQuery.Text.StartsWith("SELECT"))
{
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery.Text, connectStrWithDb);
querySelected = true;
if (result.HasError == false)
{
sqlSelectGrid.ItemsSource = result.ResultData.DefaultView;
tabControl.SelectedIndex = 5;
}
else
{
MessageBox.Show(result.ErrorText);
}
}
else
{
MySqlLib.MySqlDataC.MySqlExecute.MyResult result = new MySqlLib.MySqlDataC.MySqlExecute.MyResult();
result = MySqlLib.MySqlDataC.MySqlExecute.SqlNoneQuery(SQLQuery.Text, connectStrWithDb);
if (result.HasError == false)
{
MessageBox.Show(result.ResultText);
}
else
{
MessageBox.Show(result.ErrorText);
}
}
}
private void AddEmployee()
{
string SQLQuery = "INSERT INTO employees VALUES(";
TextBox[] textBoxes = { ID, FullName, Passport, Organization };
string[] attributesHeaders = { "ID", "Full_Name", "Serial_And_Passport_Number", "Organization" };
for (int i = 0; i < textBoxes.Length; i++)
{
if (textBoxes[i].Text != null && textBoxes[i].Text != "")
{
SQLQuery += "'" + textBoxes[i].Text + "', ";
}
}
if (ConfirmedByTheOrganization.SelectedIndex != -1)
{
SQLQuery += "'" + ConfirmedByTheOrganization.SelectedIndex + "')";
}
MySqlLib.MySqlDataC.MySqlExecute.MyResult result = new MySqlLib.MySqlDataC.MySqlExecute.MyResult();
result = MySqlLib.MySqlDataC.MySqlExecute.SqlNoneQuery(SQLQuery, connectStr);
if (result.HasError == false)
{
Close();
}
else
{
MessageBox.Show(result.ErrorText);
MessageBox.Show(SQLQuery);
}
}
private void Report_Input_SQL(string whichTable, int Session_ID)
{
string Session_ID_str = Session_ID == -1 ? "NULL" : "'" + Session_ID.ToString() + "'";
MySqlLib.MySqlDataC.MySqlExecute.MyResult result = new MySqlLib.MySqlDataC.MySqlExecute.MyResult();
string time = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
result = MySqlLib.MySqlDataC.MySqlExecute.SqlNoneQuery("INSERT INTO report_" + whichTable + " VALUES('" +
currentEmployeeID + "', '" + time + "', " + Session_ID_str + ")", connectStr);
if (result.HasError == false)
{
UpdateGrid("report");
UpdateGrid(currentEmployeeID);
}
else
{
MessageBox.Show(result.ErrorText);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (checkBoxes(comboBox1.SelectedIndex))
{
sourceXFromX.Content = "Формарование ссылки " + ++currentIndex + " из " + totalIndexes;
if (currentIndex > totalIndexes)
{
sourceXFromX.Content = "Формарование ссылки " + totalIndexes + " из " + totalIndexes;
}
FileStream file = new FileStream(@"XML\item.xml", FileMode.Open);
XML = new byte[file.Length];
file.Read(XML, 0, XML.Length);
string tempXML = System.Text.Encoding.UTF8.GetString(XML);
file.Close();
string temp = "";
string SQLQuery = "";
switch (comboBox1.SelectedIndex)
{
case 0:
temp += Name.Text + " [Электронный ресурс]/ Режим доступа: "
+ LinkOrAuthors.Text + ".";
SQLQuery = "INSERT INTO electronic_resource VALUES('" +
Name.Text + "', '" + LinkOrAuthors.Text + "')";
break;
case 1:
temp += LinkOrAuthors.Text;
if (!LinkOrAuthors.Text.EndsWith("."))
{
temp += ". ";
}
temp += " " + Name.Text + " [Текст] / – " +
City.Text + ": " + Publisher.Text + ", " + YearBox.Text + ". – " +
Pages.Text + " с.";
if (Volume.Text != null && Volume.Text != "")
{
temp += " – " + Volume.Text + " т.";
}
SQLQuery = "INSERT INTO literature VALUES(";
SQLQuery += LinkOrAuthors.Text == "" ? "NULL" : "'" + LinkOrAuthors.Text + "'";
SQLQuery += ", '" + Name.Text + "', '" +
City.Text + "', '" + YearBox.Text + "', '" + Publisher.Text + "', ";
SQLQuery += Volume.Text == "" ? "NULL" : "'" + Volume.Text + "'";
SQLQuery += ", '" + Pages.Text + "')";
break;
default: break;
}
MySqlLib.MySqlDataC.MySqlExecute.MyResult SQLResult = new MySqlLib.MySqlDataC.MySqlExecute.MyResult();
SQLResult = MySqlLib.MySqlDataC.MySqlExecute.SqlNoneQuery(SQLQuery, connStr);
tempXML = tempXML.Replace("123456654321", temp);
Name.Text = "";
YearBox.Text = "";
LinkOrAuthors.Text = "";
Pages.Text = "";
Volume.Text = "";
City.Text = "";
Publisher.Text = "";
res += tempXML;
if (currentIndex > totalIndexes)
{
AddLinks();
MessageBoxResult result = MessageBox.Show("Готово", "", MessageBoxButton.OK, MessageBoxImage.Information);
Close();
}
}
}