private void Button2_Click(object sender, EventArgs e)
{
if (ValidateController.validateItem(labelIDCity.Text))
{
sqlConnection = new SqlConnection(con);
commandString = $@"DELETE FROM [dbo].[City]
WHERE IdCity = '{labelIDCity.Text}'" ;
try
{
sqlConnection.Open();
}
catch (Exception)
{
MessageBox.Show("Не удалось подключиться");
}
command = new SqlCommand(commandString, sqlConnection);
command.ExecuteNonQuery();
this.cityTableAdapter.Fill(this.phoneCallDataSet19.City);
labelIDCity.Text = "";
ValidateController.CleanerTextBox(textBoxCity);
ValidateController.CleanerNumeric(numericDiscount, numericRateDay, numericRateNight);
}
else
{
MessageBox.Show("Выберите строку для удаления");
}
}
private void Button2_Click(object sender, EventArgs e)
{
if (ValidateController.validateItem(idSubscriber.Text))
{
sqlConnection = new SqlConnection(con);
commandString = $@"DELETE FROM [dbo].[Subscribers]
WHERE IdSubscriber = '{idSubscriber.Text}'" ;
try
{
sqlConnection.Open();
}
catch (Exception)
{
MessageBox.Show("Не удалось подключиться");
}
command = new SqlCommand(commandString, sqlConnection);
command.ExecuteNonQuery();
this.subscribersTableAdapter2.Fill(this.phoneCallDataSet15.Subscribers);
idSubscriber.Text = "";
ValidateController.CleanerTextBox(textBoxAddress, textBoxInn, textBoxNumber);
Cursor.Current = Cursors.Default;
}
else
{
MessageBox.Show("Выберите строку для удаления");
}
}
public bool validate(Label city, Label subscriber, Label minutes)
{
bool result = ValidateController.validateItem(IDCity.ToString(), city) &&
ValidateController.validateItem(IDSubscriber.ToString(), subscriber) &&
ValidateController.validateItem(CountMinutes.ToString(), minutes) &&
ValidateController.validateItem(PriceConverstation.ToString());
return(result);
}
private void Button1_Click(object sender, EventArgs e)
{
subscribeModel = new SubscribeModel(textBoxNumber.Text, textBoxInn.Text, textBoxAddress.Text);
if (subscribeModel.validate(errorNumber, errorINN, errorAddress))
{
Cursor.Current = Cursors.WaitCursor;
sqlConnection = new SqlConnection(con);
if (ValidateController.validateItem(idSubscriber.Text))
{
commandString = $@"UPDATE [dbo].[Subscribers]
SET [NumberPhone] = '{subscribeModel.MobilePhone}'
,[INN] = '{subscribeModel.INN}'
,[Address] = '{subscribeModel.Address}'
WHERE IdSubscriber = '{idSubscriber.Text}'" ;
}
else
{
commandString = $@"INSERT INTO [dbo].[Subscribers]
([NumberPhone]
,[INN]
,[Address])
VALUES(
'{subscribeModel.MobilePhone}',
'{subscribeModel.INN}',
'{subscribeModel.Address}')" ;
}
try
{
sqlConnection.Open();
}
catch (Exception)
{
MessageBox.Show("Не удалось подключиться");
}
command = new SqlCommand(commandString, sqlConnection);
command.ExecuteNonQuery();
this.subscribersTableAdapter2.Fill(this.phoneCallDataSet15.Subscribers);
idSubscriber.Text = "";
ValidateController.CleanerTextBox(textBoxAddress, textBoxInn, textBoxNumber);
Cursor.Current = Cursors.Default;
}
else
{
MessageBox.Show("Заполните данные");
}
}
private void Button1_Click(object sender, EventArgs e)
{
cityModel = new CityModel(textBoxCity.Text, numericRateDay.Value, numericRateNight.Value, numericDiscount.Value);
if (cityModel.validate(errorCity, errorRDay, errorRNight))
{
Cursor.Current = Cursors.WaitCursor;
sqlConnection = new SqlConnection(con);
if (ValidateController.validateItem(labelIDCity.Text))
{
commandString = $@"UPDATE [dbo].[City]
SET [NameCity] = '{cityModel.CityName}'
,[RateDay] = '{cityModel.RateDay}'
,[RateNigth] = '{cityModel.RateNight}'
,[Discount] = '{cityModel.Discount}'
WHERE IdCity = '{labelIDCity.Text}'" ;
}
else
{
commandString = $@"INSERT INTO [dbo].[City]
([NameCity]
,[RateDay]
,[RateNigth]
,[Discount])
VALUES(
'{cityModel.CityName}',
'{cityModel.RateDay.ToString()}',
'{cityModel.RateNight}',
'{cityModel.Discount}')" ;
}
try
{
sqlConnection.Open();
}
catch (Exception)
{
MessageBox.Show("Не удалось подключиться");
}
command = new SqlCommand(commandString, sqlConnection);
command.ExecuteNonQuery();
this.cityTableAdapter.Fill(this.phoneCallDataSet19.City);
labelIDCity.Text = "";
ValidateController.CleanerTextBox(textBoxCity);
ValidateController.CleanerNumeric(numericDiscount, numericRateDay, numericRateNight);
}
}
private double?CalculationPriceMinutes(string rDay, string rNight, decimal countMIn)
{
if (ValidateController.validateItem(rDay) && ValidateController.validateItem(rNight))
{
if (date.TimeOfDay.Hours > 12)
{
return(Convert.ToDouble(rDay) * Convert.ToDouble(countMIn));
}
else
{
return(Convert.ToDouble(rNight) * Convert.ToDouble(countMIn));
}
}
return(null);
}
public bool validate(Label labelMob, Label labelInn, Label labelAddress)
{
bool result = ValidateController.validateItem(MobilePhone, labelMob) && ValidateController.validateItem(INN, labelInn) && ValidateController.validateItem(Address, labelAddress);
return(result);
}