private void Button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(textBox_UNP_Update_Delete.Text) && string.IsNullOrWhiteSpace(textBox_UNP_Update_Delete.Text))
{
ORG.UNP_Org = null;
}
else
{
ORG.UNP_Org = textBox_UNP_Update_Delete.Text;
}
if (string.IsNullOrEmpty(textBox_Short_Name_Org_Update_Delete.Text))
{
ORG.Short_Name_Org = null;
}
else
{
ORG.Short_Name_Org = textBox_Short_Name_Org_Update_Delete.Text;
}
if (string.IsNullOrEmpty(textBox_Full_Name_Org_Update_Delete.Text))
{
ORG.Full_Name_Org = null;
}
else
{
ORG.Full_Name_Org = textBox_Full_Name_Org_Update_Delete.Text;
}
SQL_ADD_Parametrs sQL_Parametrs_Apdate = new SQL_ADD_Parametrs();
sQL_Parametrs_Apdate.Find_For_Update_ORG(oRG);
textBox_UNP_Update_Delete.Text = ORG.UNP_Org;
textBox_Short_Name_Org_Update_Delete.Text = ORG.Short_Name_Org;
textBox_Full_Name_Org_Update_Delete.Text = ORG.Full_Name_Org;
maskedTextBox_Create_date_Org.Text = Convert.ToString(ORG.Create_date_Org);
comboBox_Countyr_Org.Text = ORG.Countyr_Org;
comboBox_Section.Text = ORG.Name_Section;
Description_ORG.Text = ORG.Description_ORG;
comboBox_Countyr_Pers.Text = ORG.Country_Pers;
Name_Owner.Text = ORG.Owner_Name;
if (ORG.Ownership_Org == 1)
{
checkBox_Ownership_Org.Checked = true;
}
else
{
checkBox_Ownership_Org.Checked = false;
}
if (ORG.Tax_Debt == 1)
{
Tax_Debt.Checked = true;
}
else
{
Tax_Debt.Checked = false;
}
if (ORG.Debts_Enforcement_Documents == 1)
{
Debts_Enforcement_Documents.Checked = false;
}
else
{
Debts_Enforcement_Documents.Checked = false;
}
if (ORG.Debts_Enforcement_Documents == 1)
{
Debts_Enforcement_Documents.Checked = true;
}
else
{
Debts_Enforcement_Documents.Checked = false;
}
if (ORG.False_Business == 1)
{
False_Business.Checked = true;
}
else
{
False_Business.Checked = false;
}
if (ORG.Special_Risc == 1)
{
Special_Risc.Checked = true;
}
else
{
Special_Risc.Checked = false;
}
if (ORG.Special_Risc == 1)
{
Special_Risc.Checked = true;
}
else
{
Special_Risc.Checked = false;
}
if (ORG.Execute_Proc == 1)
{
Execute_Proc.Checked = true;
}
else
{
Execute_Proc.Checked = false;
}
if (ORG.Bankruptcy_Proc == 1)
{
Bankruptcy_Proc.Checked = true;
}
else
{
Bankruptcy_Proc.Checked = false;
}
if (ORG.Liquidation_Proc == 1)
{
Liquidation_Proc.Checked = true;
}
else
{
Liquidation_Proc.Checked = false;
}
if (ORG.Resident == 1)
{
Resident.Checked = true;
}
else
{
Resident.Checked = false;
}
if (ORG.Broker_Client == 1)
{
Broker_Client.Checked = true;
}
else
{
Broker_Client.Checked = false;
}
if (ORG.Prev_Broker_Client == 1)
{
Prev_Broker_Client.Checked = true;
}
else
{
Prev_Broker_Client.Checked = false;
}
if (ORG.Trading_experience == 1)
{
Trading_experience.Checked = true;
}
else
{
Trading_experience.Checked = false;
}
if (ORG.Trader == 1)
{
Trader.Checked = true;
}
else
{
Trader.Checked = false;
}
if (ORG.Manufacturer == 1)
{
Manufacturer.Checked = true;
}
else
{
Manufacturer.Checked = false;
}
if (ORG.First_Accred == 1)
{
First_Accred.Checked = true;
}
else
{
First_Accred.Checked = false;
}
if (ORG.Second_Accred == 1)
{
Second_Accred.Checked = true;
}
else
{
Second_Accred.Checked = false;
}
if (ORG.Exchenge_Trading_Disorders == 1)
{
Exchenge_Trading_Disorders.Checked = true;
}
else
{
Exchenge_Trading_Disorders.Checked = false;
}
if (ORG.Negativ_Data == 1)
{
Negativ_Data.Checked = true;
}
else
{
Negativ_Data.Checked = false;
}
if (ORG.Negativ_Data_Pers == 1)
{
Negativ_Data_Pers.Checked = true;
}
else
{
Negativ_Data_Pers.Checked = false;
}
if (ORG.Reputation == 1)
{
Reputation.Checked = true;
}
else
{
Reputation.Checked = false;
}
if (ORG.Prev_Liquidated == 1)
{
Prev_Liquidated.Checked = true;
}
else
{
Prev_Liquidated.Checked = false;
}
if (ORG.Prev_Bankruptcy == 1)
{
Prev_Bankruptcy.Checked = true;
}
else
{
Prev_Bankruptcy.Checked = false;
}
if (ORG.Prev_State_Debt == 1)
{
Prev_State_Debt.Checked = true;
}
else
{
Prev_State_Debt.Checked = false;
}
if (ORG.Prev_Tax_Debt == 1)
{
Prev_Tax_Debt.Checked = true;
}
else
{
Prev_Tax_Debt.Checked = false;
}
if (ORG.Prev_Execute_Proc == 1)
{
Prev_Execute_Proc.Checked = true;
}
else
{
Prev_Execute_Proc.Checked = false;
}
if (ORG.Broker_Opinion == "нет")
{
textBox_BrokerOpinion.Clear();
}
else
{
textBox_BrokerOpinion.Text = ORG.Broker_Opinion;
}
if (ORG.Section_Head_Opinion == "нет")
{
textBox_Section_Head_Opinion.Clear();
}
else
{
textBox_Section_Head_Opinion.Text = ORG.Section_Head_Opinion;
}
if (ORG.Auditor_Opinion == "нет")
{
textBox_Auditor_Opinion.Clear();
}
else
{
textBox_Auditor_Opinion.Text = ORG.Auditor_Opinion;
}
if (ORG.Head_Name == "нет")
{
TextBox_Name_Head.Clear();
}
else
{
TextBox_Name_Head.Text = ORG.Head_Name;
}
if (ORG.Description_Pers == "нет")
{
Description_Pers.Clear();
}
else
{
Description_Pers.Text = ORG.Description_Pers;
}
if (ORG.Forced_Deposite_Small == 1)
{
checkBox_Forced_Deposite_Small.Checked = true;
}
else
{
checkBox_Forced_Deposite_Small.Checked = false;
}
if (ORG.Forced_Deposite_Large == 1)
{
checkBox_Forced_Deposite_Large.Checked = true;
}
else
{
checkBox_Forced_Deposite_Large.Checked = false;
}
Risc_Level.Text = Convert.ToString(ORG.Risc_Level);
Risc_Level.Visible = true;
}
private void Button2_Click(object sender, EventArgs e)
{
label_Not_Two_Depos_Small.Visible = false;
label_Not_Two_Depos_Largw.Visible = false;
if (checkBox_Forced_Deposite_Small.Checked && checkBox_Forced_Deposite_Large.Checked)
{
MessageBox.Show("Не возможно одновременно применить два вида задатка!!!");
label_Not_Two_Depos_Small.Visible = true;
label_Not_Two_Depos_Largw.Visible = true;
return;
}
CHECK_class cHECK_Class = new CHECK_class();
#region проверка УНП
//проверка УНП на пустое поле
if (!string.IsNullOrEmpty(textBox_UNP_Update_Delete.Text) && !string.IsNullOrWhiteSpace(textBox_UNP_Update_Delete.Text))
{ //Проверка УНП на идентичность
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
if (!cHECK_Class.Check_UNP(textBox_UNP_Update_Delete.Text) == true)
{
ORG.UNP_Org = textBox_UNP_Update_Delete.Text;
label_err_UNP.Visible = false;
}
if (cHECK_Class.Check_UNP(textBox_UNP_Update_Delete.Text) == true)
{
ORG.UNP_Org_New = textBox_UNP_Update_Delete.Text;
label_err_UNP.Visible = false;
}
}
}
else
{
label_err_UNP.Visible = true;
label_UNP.Visible = true;
return;
}
#endregion
#region Проверка краткого имени
//Проверка на пустое поле Кр. имени
if (!string.IsNullOrEmpty(textBox_Short_Name_Org_Update_Delete.Text) && !string.IsNullOrWhiteSpace(textBox_Short_Name_Org_Update_Delete.Text))
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
if (!cHECK_Class.Check_Short_Name_Org(textBox_Short_Name_Org_Update_Delete.Text) == true)
{
label_err_Short_Name.Visible = false;
label_Short_Name.Visible = true;
ORG.Short_Name_Org = textBox_Short_Name_Org_Update_Delete.Text;
}
if (cHECK_Class.Check_Short_Name_Org(textBox_Short_Name_Org_Update_Delete.Text) == true)
{
label_err_Short_Name.Visible = false;
label_Short_Name.Visible = true;
ORG.Short_Name_Org_New = textBox_Short_Name_Org_Update_Delete.Text;
}
}
}
else
{
label_Short_Name.Visible = false;
label_err_Short_Name.Visible = true;
return;
}
#endregion
#region проверка полного имени
//Проверка полного имени на идентичность
if (!string.IsNullOrEmpty(textBox_Full_Name_Org_Update_Delete.Text) && !string.IsNullOrWhiteSpace(textBox_Full_Name_Org_Update_Delete.Text))
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
if (!cHECK_Class.Check_Full_Name_Org(textBox_UNP_Update_Delete.Text) == true)
{
label_err_Full_Name.Visible = false;
label_Full_Name_Org.Visible = true;
ORG.Full_Name_Org = textBox_Full_Name_Org_Update_Delete.Text;
}
if (cHECK_Class.Check_Full_Name_Org(textBox_UNP_Update_Delete.Text) == true)
{
label_err_Full_Name.Visible = false;
label_Full_Name_Org.Visible = true;
ORG.Full_Name_Org_New = textBox_Full_Name_Org_Update_Delete.Text;
}
}
}
else
{
label_Full_Name_Org.Visible = false;
label_err_Full_Name.Visible = true;
return;
}
#endregion
#region Проверка даты
// Проверка корректности вводимой даты
if (cHECK_Class.Check_Create_date_Org(maskedTextBox_Create_date_Org.Text) == true)
{
label_Incorrect_Date.Visible = false;
Age_Org_1.Visible = true;
//DateTime dateTime = DateTime.ParseExact(maskedTextBox_Create_date_Org.Text, "dd/MM/yyyy", CultureInfo.GetCultureInfo("en-GB"), DateTimeStyles.None);
DateTime dateTime = Convert.ToDateTime(maskedTextBox_Create_date_Org.Text);
ORG.Create_date_Org = dateTime;
}
else
{
Age_Org_1.Visible = false;
label_Incorrect_Date.Visible = true;
return;
}
#endregion
#region проверка страны
//Проверка ввода страны
if (cHECK_Class.Check_Country(comboBox_Countyr_Org.Text) == true)
{
label_Country_Org_Err.Visible = false;
label_Country_Org.Visible = true;
ORG.Countyr_Org = comboBox_Countyr_Org.Text;
}
else
{
label_Country_Org.Visible = false;
label_Country_Org_Err.Visible = true;
return;
}
#endregion
#region проверка секции
//Проверка секции
if (cHECK_Class.Check_Section(comboBox_Section.Text) == true)
{
label_err_Section.Visible = false;
label_Section.Visible = true;
ORG.Name_Section = comboBox_Section.Text;
}
else
{
label_Section.Visible = false;
label_err_Section.Visible = true;
return;
}
#endregion
#region проверка страны руководителч
//Проверка страны руководителя
if (cHECK_Class.Check_Country_Pers(comboBox_Countyr_Pers.Text) == true)
{
label_err_Country_Pers.Visible = false;
label1_Country_Pers.Visible = true;
ORG.Country_Pers = comboBox_Countyr_Pers.Text;
}
else
{
label1_Country_Pers.Visible = false;
label_err_Country_Pers.Visible = true;
return;
}
#endregion
#region проверка данных собственноика
//Проверка данных собственника
if (!string.IsNullOrEmpty(Name_Owner.Text) && !string.IsNullOrWhiteSpace(Name_Owner.Text))
{
label_err_Owneer_Name.Visible = false;
label_Name_Head.Visible = true;
ORG.Owner_Name = Name_Owner.Text;
}
else
{
label_Name_Head.Visible = false;
label_err_Owneer_Name.Visible = true;
return;
}
#endregion
#region проверка данных руководителя
// Проверка данных руководителя
if (!string.IsNullOrEmpty(TextBox_Name_Head.Text) && !string.IsNullOrWhiteSpace(TextBox_Name_Head.Text))
{
label_err_Head_Name.Visible = false;
label_Name_Owner.Visible = true;
ORG.Head_Name = TextBox_Name_Head.Text;
}
else
{
label_Name_Owner.Visible = false;
label_err_Head_Name.Visible = true;
return;
}
#endregion
#region мнение брокера
if (string.IsNullOrEmpty(textBox_BrokerOpinion.Text) && string.IsNullOrWhiteSpace(textBox_BrokerOpinion.Text))
{
ORG.Broker_Opinion = "нет";
}
else
{
ORG.Broker_Opinion = textBox_BrokerOpinion.Text;
}
#endregion
#region мнение профильного управления
if (string.IsNullOrEmpty(textBox_Section_Head_Opinion.Text) && string.IsNullOrWhiteSpace(textBox_Section_Head_Opinion.Text))
{
ORG.Section_Head_Opinion = "нет";
}
else
{
ORG.Section_Head_Opinion = textBox_Section_Head_Opinion.Text;
}
#endregion
#region мнение проверяющего
if (string.IsNullOrEmpty(textBox_Auditor_Opinion.Text) && string.IsNullOrWhiteSpace(textBox_Auditor_Opinion.Text))
{
ORG.Auditor_Opinion = "нет";
}
else
{
ORG.Auditor_Opinion = textBox_Auditor_Opinion.Text;
}
#endregion
#region описание организации
if (string.IsNullOrEmpty(Description_ORG.Text) && string.IsNullOrWhiteSpace(Description_ORG.Text))
{
ORG.Description_ORG = "нет";
}
else
{
ORG.Description_ORG = Description_ORG.Text;
}
#endregion
#region описание руководителей
if (string.IsNullOrEmpty(Description_Pers.Text) && string.IsNullOrWhiteSpace(Description_Pers.Text))
{
ORG.Description_Pers = "нет";
}
else
{
ORG.Description_Pers = Description_Pers.Text;
}
#endregion
if (checkBox_Ownership_Org.Checked)
{
ORG.Ownership_Org = 1;
}
if (!checkBox_Ownership_Org.Checked)
{
ORG.Ownership_Org = 0;
}
if (Tax_Debt.Checked)
{
ORG.Tax_Debt = 1;
}
if (!Tax_Debt.Checked)
{
ORG.Tax_Debt = 0;
}
if (Debts_Enforcement_Documents.Checked)
{
ORG.Debts_Enforcement_Documents = 1;
}
if (!Debts_Enforcement_Documents.Checked)
{
ORG.Debts_Enforcement_Documents = 0;
}
if (False_Business.Checked)
{
ORG.False_Business = 1;
}
if (!False_Business.Checked)
{
ORG.False_Business = 0;
}
if (Special_Risc.Checked)
{
ORG.Special_Risc = 1;
}
if (!Special_Risc.Checked)
{
ORG.Special_Risc = 0;
}
if (Execute_Proc.Checked)
{
ORG.Execute_Proc = 1;
}
if (!Execute_Proc.Checked)
{
ORG.Execute_Proc = 0;
}
if (Bankruptcy_Proc.Checked)
{
ORG.Bankruptcy_Proc = 1;
}
if (!Bankruptcy_Proc.Checked)
{
ORG.Bankruptcy_Proc = 0;
}
if (Liquidation_Proc.Checked)
{
ORG.Liquidation_Proc = 1;
}
if (!Liquidation_Proc.Checked)
{
ORG.Liquidation_Proc = 0;
}
if (Resident.Checked)
{
ORG.Resident = 1;
}
if (!Resident.Checked)
{
ORG.Resident = 0;
}
if (Broker_Client.Checked)
{
ORG.Broker_Client = 1;
}
if (!Broker_Client.Checked)
{
ORG.Broker_Client = 0;
}
if (Prev_Broker_Client.Checked)
{
ORG.Prev_Broker_Client = 1;
}
if (!Prev_Broker_Client.Checked)
{
ORG.Prev_Broker_Client = 0;
}
if (Trading_experience.Checked)
{
ORG.Trading_experience = 1;
}
if (!Trading_experience.Checked)
{
ORG.Trading_experience = 0;
}
if (Trader.Checked)
{
ORG.Trader = 1;
}
if (!Trader.Checked)
{
ORG.Trader = 0;
}
if (Manufacturer.Checked)
{
ORG.Manufacturer = 1;
}
if (!Manufacturer.Checked)
{
ORG.Manufacturer = 0;
}
if (First_Accred.Checked)
{
ORG.First_Accred = 1;
}
if (!First_Accred.Checked)
{
ORG.First_Accred = 0;
}
if (Second_Accred.Checked)
{
ORG.Second_Accred = 1;
}
if (!Second_Accred.Checked)
{
ORG.Second_Accred = 0;
}
if (Exchenge_Trading_Disorders.Checked)
{
ORG.Exchenge_Trading_Disorders = 1;
}
if (!Exchenge_Trading_Disorders.Checked)
{
ORG.Exchenge_Trading_Disorders = 0;
}
if (Negativ_Data.Checked)
{
ORG.Negativ_Data = 1;
}
if (!Negativ_Data.Checked)
{
ORG.Negativ_Data = 0;
}
if (Reputation.Checked)
{
ORG.Reputation = 1;
}
if (!Reputation.Checked)
{
ORG.Reputation = 0;
}
if (Prev_Liquidated.Checked)
{
ORG.Prev_Liquidated = 1;
}
if (!Prev_Liquidated.Checked)
{
ORG.Prev_Liquidated = 0;
}
if (Prev_Bankruptcy.Checked)
{
ORG.Prev_Bankruptcy = 1;
}
if (!Prev_Bankruptcy.Checked)
{
ORG.Prev_Bankruptcy = 0;
}
if (Prev_Execute_Proc.Checked)
{
ORG.Prev_Execute_Proc = 1;
}
if (!Prev_Execute_Proc.Checked)
{
ORG.Prev_Execute_Proc = 0;
}
if (Negativ_Data_Pers.Checked)
{
ORG.Negativ_Data_Pers = 1;
}
if (!Negativ_Data_Pers.Checked)
{
ORG.Negativ_Data_Pers = 0;
}
if (Prev_Tax_Debt.Checked)
{
ORG.Prev_Tax_Debt = 1;
}
if (!Prev_Tax_Debt.Checked)
{
ORG.Prev_Tax_Debt = 0;
}
if (Prev_State_Debt.Checked)
{
ORG.Prev_State_Debt = 1;
}
if (!Prev_State_Debt.Checked)
{
ORG.Prev_State_Debt = 0;
}
if (checkBox_Forced_Deposite_Small.Checked)
{
ORG.Forced_Deposite_Small = 1;
}
else
{
ORG.Forced_Deposite_Small = 0;
}
if (checkBox_Forced_Deposite_Large.Checked)
{
ORG.Forced_Deposite_Large = 1;
}
else
{
ORG.Forced_Deposite_Large = 0;
}
SQL_ADD_Parametrs aDD_Parametrs_Update = new SQL_ADD_Parametrs();
DialogResult dialogResult = MessageBox.Show($"Господин {ORG.Login_User}, Вы действительно правильно заполнили поля?", "Контрольный выстрел!", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
aDD_Parametrs_Update.Update_ORG(oRG);
MessageBox.Show($"Изменнения приянты!");
this.Close();
}
else if (dialogResult == DialogResult.No)
{
return;
}
}