private bool AddNewApplication()
{
if (F_Name.Text.Length <= 0)
{
MessageBox.Show("Впишите название для компонента");
return(false);
}
try
{
if (F_Count.Text.Length <= 0)
{
MessageBox.Show("Введите количество компонентов");
return(false);
}
Convert.ToInt32(F_Count.Text);
}
catch
{
MessageBox.Show("В поле количество присутсвуют лишние символы");
return(false);
}
if (F_Postav.SelectedItem.ToString() == "---")
{
MessageBox.Show("Поставщик не выбран");
return(false);
}
string ID_Postavchik = UsAc.Execute($@"SELECT ID_Postavchik FROM Postavchiki WHERE Nazvanie_Postavchik = ""{F_Postav.SelectedItem.ToString()}""").Table.Rows[0]["ID_Postavchik"].ToString();
UsAc.ExecuteNonQuery($@"INSERT INTO TMC (Nazvanie_TMC, Kolichestvo_TMC, Postavchik_TMC) VALUES (""{F_Name.Text}"", {F_Count.Text}, {ID_Postavchik})");
return(true);
}
private void Enter(object sender, RoutedEventArgs e)
{
//Проверка длины
if (F_Pas1.Password.Length < 4)
{
MessageBox.Show("Пароль должен содежать не менее 4 символов");
return;
}
if (F_Pas1.Password != F_Pas2.Password)
{
MessageBox.Show("Пароли не совпадают");
return;
}
UsAc.ExecuteNonQuery($@"UPDATE Users SET Password_User = ""{F_Pas1.Password}"" WHERE Login_User = ""{login}""");
MessageBox.Show("Пароль был создан");
this.DialogResult = true;
}
/// <summary>
/// Создает запись о том, что пользователь вошел в то или иное время
/// </summary>
/// <param name="InOut">1 - вход. 0 - выход</param>
private void AddLogToAutorization(int InOut)
{
if (UserID == null)
{
return;
}
try
{
if (InOut == 1)
{
var time = DateTime.Now.ToString();
UsAc.ExecuteNonQuery($@"INSERT INTO Log_avtorizatcii (ID_User, Time_in) VALUES ({UserID}, ""{time}"")");
TimeIn = time;
}
else if (InOut == 0)
{
UsAc.ExecuteNonQuery($@"UPDATE Log_avtorizatcii SET Time_out = ""{DateTime.Now.ToString()}"" WHERE Time_in = ""{TimeIn}""");
TimeIn = null;
}
}
catch { }
}
private bool AddNewUser()
{
//Проверка длины логина
if (F_Login.Text.Length < 4)
{
MessageBox.Show("Длина логина не может быть короче 4 символов");
return(false);
}
//Добавление как пользователя
UsAc.ExecuteNonQuery($@"INSERT INTO Users (Login_User, Password_User, Role) VALUES (""{F_Login.Text}"","""", 2)");
//Получение ID пользователя
string ID = null;
var table = UsAc.Execute("SELECT Max(Users.ID_User) AS [ID] FROM Users");
ID = table.Table.Rows[0]["ID"].ToString();
//Добавление как сотрдуника
string value = null;
string From = null;
string Values = null;
value = F_FIO.Text;
if (value.Length != 0)
{
From += "FIO_Master";
Values += $@"""{F_FIO.Text}""";
}
value = F_Doljnost.Text;
if (value != "---")
{
From += ",Doljnost_Master";
Values += "," + GetId("Doljnosti", "ID_Doljnost", F_Doljnost.SelectedItem.ToString(), "Nazvanie_Doljnost");
}
value = F_Birthday.Text;
if (value.Length != 0)
{
From += ",DateOfBirth_Master";
Values += $@",""{F_Birthday.Text}""";
}
value = F_Phone.Text;
if (value.Length != 0)
{
From += ",Phone_Master";
Values += $@",""{F_Phone.Text}""";
}
value = F_Address.Text;
if (value.Length != 0)
{
From += ",Adress_Master";
Values += $@",""{F_Address.Text}""";
}
value = F_Email.Text;
if (value.Length != 0)
{
From += ",Email_Master";
Values += $@",""{F_Email.Text}""";
}
From += ",IDUsera";
Values += $@",{ID}";
UsAc.ExecuteNonQuery($@"INSERT INTO Sotrudniki ({From}) VALUES ({Values})");
return(true);
}
/// <summary>
/// Метод добавления новой записи
/// </summary>
private void AddNewApplication()
{
string value = null;
string From = null;
string Values = null;
value = F_DataZayavki.Text;
if (value.Length != 0)
{
From += "Date_Zayavki";
Values += $@"""{F_DataZayavki.Text}""";
}
value = F_FIO_Master.Text;
if (value != "---")
{
From += ",Master";
Values += "," + GetId("Sotrudniki", "ID_Master", F_FIO_Master.SelectedItem.ToString(), "FIO_Master");
}
value = F_FIO_Client.Text;
if (value != "---")
{
From += ",Client";
Values += "," + GetId("Clients", "ID_Client", F_FIO_Client.SelectedItem.ToString(), "FIO_Client");
}
value = F_Type_neispravnosti.Text;
if (value != "---")
{
From += ",Neispravnost_Zayavki";
Values += "," + GetId("Neispravnosti", "ID_Neispravnosti", F_Type_neispravnosti.SelectedItem.ToString(), "Naimenovanie");
}
value = F_Type_tehniki.Text;
if (value != "---")
{
From += ",Type_Tehniki_Zayavki";
Values += "," + GetId("TypeTehniki", "ID_TypeTehniki", F_Type_tehniki.SelectedItem.ToString(), "Type_TypeTehniki");
}
value = F_Producer.Text;
if (value != "---")
{
From += ",Izgotovitel";
Values += "," + GetId("Izgotovitel", "ID_Izgotovitel", F_Producer.SelectedItem.ToString(), "Nazvanie_Izgotovitel");
;
}
value = F_Model.Text;
if (value != "---")
{
From += ",ID_Oborudovaniya";
Values += "," + GetId("Oborudovanie", "ID_Oborudovaniya", F_Model.SelectedItem.ToString(), "Model");
}
value = F_NameUsligu.Text;
if (value != "---")
{
From += ",Services";
Values += "," + GetId("Services", "ID_Services", F_NameUsligu.SelectedItem.ToString(), "Nazvanie_Services");
}
value = F_DetalCount.Text;
if (value.Length != 0)
{
From += ",KolvoServ";
Values += "," + F_DetalCount.Text;
}
value = F_DetalName.Text;
if (value != "---")
{
From += ",Materiali";
Values += "," + GetId("TMC", "ID_TMC", F_DetalName.SelectedItem.ToString(), "Nazvanie_TMC");
}
value = F_Statys.Text;
if (value != "---")
{
From += ",Statys";
Values += "," + GetId("Statys", "ID_Statys", F_Statys.SelectedItem.ToString(), "Statys_Statys");
}
value = F_DataFinished.Text;
if (value.Length != 0)
{
From += ",Date_okonchaniya_Zayavki";
Values += "," + $@"""{F_DataFinished.Text}""";
}
value = F_Summ.Text;
if (value.Length != 0)
{
From += ",Summa";
Values += "," + $@"""{F_Summ.Text}""";
}
UsAc.ExecuteNonQuery($@"INSERT INTO Zayavki ({From}) VALUES ({Values})");
}