private void EMP_ISERT_CANCEL_Click(object sender, EventArgs e)
{
NameSet.Clear();
AgeSet.Value = 20;
SalarySet.Value = 5000;
PremiumSet.Value = 0;
PhoneSet.Clear();
EmailSet.Clear();
Dep_IdSET.Value = 0;
label22.Visible = false;
}
private async void EMP_UPDATE_OK_Click(object sender, EventArgs e)
{
if (label25.Visible)
{
label25.Visible = false;
}
if (!string.IsNullOrEmpty(Name_Update.Text) && !string.IsNullOrWhiteSpace(Name_Update.Text) &&
!string.IsNullOrEmpty(ID_UPDATE.Text) && !string.IsNullOrWhiteSpace(ID_UPDATE.Text))
{
SqlCommand command = new SqlCommand("UPDATE [Employees] SET [Name]=@Name, " +
"[Age]=@Age,[Salary]=@Salary,[Premium]=@Premium,[PhoneNumber]=@phoneNumber," +
"[Email]=@Email,[Dep_Id]=@Dep_Id WHERE [Id]=@Id", sqlconnection);
command.Parameters.AddWithValue("Id", ID_UPDATE.Text);
command.Parameters.AddWithValue("Name", Name_Update.Text);
command.Parameters.AddWithValue("Age", Age_Update.Value);
command.Parameters.AddWithValue("Salary", Salary_Update.Value);
command.Parameters.AddWithValue("Premium", Premium_Update.Value);
command.Parameters.AddWithValue("PhoneNumber", PhoneNumber_Update.Text);
command.Parameters.AddWithValue("Email", Email_Update.Text);
command.Parameters.AddWithValue("Dep_Id", DepID_Update.Text);
await command.ExecuteNonQueryAsync();
ID_UPDATE.Clear();
NameSet.Clear();
Age_Update.Value = 20;
Salary_Update.Value = 5000;
Premium_Update.Value = 0;
PhoneNumber_Update.Clear();
Email_Update.Clear();
DepID_Update.Value = 1;
}
else if (string.IsNullOrEmpty(ID_UPDATE.Text) && string.IsNullOrWhiteSpace(ID_UPDATE.Text))
{
label25.Visible = true;
label25.Text = "идентификатор должен быть заполнен ";
}
else
{
label25.Visible = true;
label25.Text = "поля введены не коректно";
}
}
private async void EMP_INSERT_OK_Click(object sender, EventArgs e)
{
if (label22.Visible)
{
label22.Visible = false;
}
if (!string.IsNullOrEmpty(NameSet.Text) && !string.IsNullOrWhiteSpace(NameSet.Text) &&
!string.IsNullOrEmpty(PhoneSet.Text) && !string.IsNullOrWhiteSpace(PhoneSet.Text) &&
!string.IsNullOrEmpty(EmailSet.Text) && !string.IsNullOrWhiteSpace(EmailSet.Text) &&
Dep_IdSET.Value != 0)
{
SqlCommand command = new SqlCommand("INSERT INTO [Employees](Name,Age,Salary,Premium,PhoneNumber,Email,Dep_Id)" +
"Values(@Name,@Age,@Salary,@Premium,@PhoneNumber,@Email,@Dep_Id)", sqlconnection);
command.Parameters.AddWithValue("Name", NameSet.Text);
command.Parameters.AddWithValue("Age", AgeSet.Value);
command.Parameters.AddWithValue("Salary", SalarySet.Value);
command.Parameters.AddWithValue("Premium", PremiumSet.Value);
command.Parameters.AddWithValue("PhoneNumber", PhoneSet.Text);
command.Parameters.AddWithValue("Email", EmailSet.Text);
command.Parameters.AddWithValue("Dep_Id", Dep_IdSET.Value);
await command.ExecuteNonQueryAsync();
NameSet.Clear();
AgeSet.Value = 20;
SalarySet.Value = 5000;
PremiumSet.Value = 0;
PhoneSet.Clear();
EmailSet.Clear();
Dep_IdSET.Value = 0;
}
else
{
label22.Visible = true;
label22.Text = "поля введены не коректно";
}
}