private void toolStripMenuItem2_Click(object sender, EventArgs e)
{
int id_order = Convert.ToInt32(InfoWorks.CurrentRow.Cells[0].Value); //ID_order
string queryDelOrder = "DELETE from orders WHERE orders.id_order =" + id_order;
DialogResult result = MessageBox.Show(
"Вы действительно хотите удалить выбранный заказ?",
"Подтверждение",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
// Проверяем какая кнопка нажата ...
if (result == DialogResult.Yes)
{
QueriesClass.QuerytoTable(queryDelOrder);
QueriesClass.SelectQuery(querySelectOrders, InfoWorks);
}
else
{
this.TopMost = true;
}// Ставим нашу форму по верх всех окон
this.TopMost = true;
}
private void LoadChartCount()
{
string nameMS = "", surnameMS = "", patronymicMS = "";
string queryMasters = "SELECT Concat_ws(' ',surname,name,patronymic) FROM masters";
string queryCountWorks;
masters = QueriesClass.SelectCombo(queryMasters); //list of FIO masters
int count = 0;
for (int i = 0; i < masters.Count; i++)
{
//string text = masters[i].ToString();
//MessageBox.Show(text);
string[] FIO = masters[i].ToString().Split(' ');
surnameMS = FIO[0];
//MessageBox.Show(surnameMS);
nameMS = FIO[1];
//MessageBox.Show(nameMS);
patronymicMS = FIO[2];
// MessageBox.Show(patronymicMS);
queryCountWorks = "SELECT count(*) FROM orders INNER JOIN masters ON orders.id_master=masters.id_master Where masters.surname = '" + surnameMS + "' and masters.Name = '" + nameMS + "' and masters.Patronymic = '" + patronymicMS + "'";
count = QueriesClass.SelectOne(queryCountWorks);
chartCount.Series["Количество работ"].Points.AddXY(masters[i], count);
chartCount.ChartAreas["ChartArea1"].AxisX.Interval = 1;
chartCount.ChartAreas[0].AxisX.LabelStyle.Angle = -30;
}
}
/// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//private void Filter()
//{
// try
// {
// string FIO = comboFIO.SelectedItem.ToString();
// string[] arrFIO = FIO.Split(' ');
// string surname = arrFIO[0];
// string name = arrFIO[1];
// string patronymic = arrFIO[2];
// string date1 = dateTimePicker1.Value.Year.ToString() + dateTimePicker1.Value.Month.ToString() + dateTimePicker1.Value.Day.ToString();
// string date2 = dateTimePicker2.Value.Year.ToString() + dateTimePicker2.Value.Month.ToString() + dateTimePicker2.Value.Day.ToString();
// if (comboService.SelectedIndex > -1 && comboFIO.SelectedIndex > -1 && firstPrice.Text != "" && secondPrice.Text != "")
// {
// // comboFIO.SelectedIndex = -1;
// string querySelService = "SELECT orders.id_order,masters.Surname,masters.Name,masters.Patronymic,Group_concat(service.name_service SEPARATOR ', '), " +
// "sum(service.price) ,concat_ws('-',day(orders.Date),month(orders.Date),year(orders.Date))" +
// " FROM service INNER JOIN order_service ON service.id_service=order_service.id_service " +
// " INNER JOIN orders ON orders.id_order= order_service.id_order " +
// " INNER JOIN masters ON masters.id_master = orders.id_master" +
// " WHERE (orders.Date BETWEEN '" + date1 + "' AND '" + date2 + "') AND masters.Surname = '" + surname + "'AND masters.Name = '" + name + "'AND masters.Patronymic = '" + patronymic + "'" +
// " GROUP BY order_service.id_order" + //sosat
// " having INSTR(Group_concat(service.name_service SEPARATOR ', '), '" + comboService.Text + "') > 0 AND " +
// " (sum(service.Price) BETWEEN " + int.Parse(firstPrice.Text) + " AND " + int.Parse(secondPrice.Text)+")";
// QueriesClass.SelectQuery(querySelService, InfoWorks);
// }
// else
// {
// QueriesClass.SelectQuery(querySelectOrders, InfoWorks);
// }
// }
// catch { }
//}
/// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
private void comboFIO_SelectedIndexChanged(object sender, EventArgs e)
{
// Filter();
if (comboFIO.SelectedIndex > -1)
{
comboService.SelectedIndex = -1;
string FIO = comboFIO.SelectedItem.ToString();
string[] arrFIO = FIO.Split(' ');
string surname = arrFIO[0];
string name = arrFIO[1];
string patronymic = arrFIO[2];
// MessageBox.Show(FIO);
string querySelMaster = "SELECT orders.id_order,masters.Surname,masters.Name,masters.Patronymic,Group_concat(service.name_service SEPARATOR ', ')," +
" sum(service.price) ,concat_ws('-',day(orders.Date),month(orders.Date),year(orders.Date))" +
" FROM service INNER JOIN order_service ON service.id_service=order_service.id_service " +
" INNER JOIN orders ON orders.id_order= order_service.id_order" +
" INNER JOIN masters ON masters.id_master = orders.id_master" +
" WHERE masters.Surname = '" + surname + "'AND masters.Name = '" + name + "'AND masters.Patronymic = '" + patronymic + "' " +
" GROUP BY order_service.id_order";
QueriesClass.SelectQuery(querySelMaster, InfoWorks);
}
else
{
QueriesClass.SelectQuery(querySelectOrders, InfoWorks);
}
countWorks.Text = "Количество выполненных работ: " + (InfoWorks.RowCount - 1);
summLine.Text = "Сумма: " + Total() + "BYN";
}
private void DeleteOrders_Click(object sender, EventArgs e)
{
string deleteOrders = "DELETE from orders";
if (InfoWorks.Rows.Count > 1)
{
DialogResult result = MessageBox.Show(
"Вы действительно хотите очистить весь список выполненных заказов?",
"Attention",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
// Проверяем какая кнопка нажата ...
if (result == DialogResult.Yes)
{
QueriesClass.QuerytoTable(deleteOrders);
InfoWorks.Rows.Clear();
}
else
{
this.TopMost = true;
}// Ставим нашу форму по верх всех окон
this.TopMost = true;
}
else
{
MessageBox.Show("В таблице нет заказов", "Information");
return;
}
}
private void LoadChartSum(string queryDate)
{
string nameMS = "", surnameMS = "", patronymicMS = "";
string queryMasters = "SELECT Concat_ws(' ',surname,name,patronymic) FROM masters";
string querySumCurMaster;
masters = QueriesClass.SelectCombo(queryMasters); //list of FIO masters
int Sum = 0;
for (int i = 0; i < masters.Count; i++)
{
//string text = masters[i].ToString();
//MessageBox.Show(i + "ый " + text);
string[] FIO = masters[i].ToString().Split(' ');
surnameMS = FIO[0];
//MessageBox.Show(surnameMS);
nameMS = FIO[1];
//MessageBox.Show(nameMS);
patronymicMS = FIO[2];
// MessageBox.Show(patronymicMS);
querySumCurMaster = querySum + " Where masters.surname = '" + surnameMS + "' and masters.Name = '"
+ nameMS + "' and masters.Patronymic = '" + patronymicMS + "'" + queryDate;
Sum = QueriesClass.SelectOne(querySumCurMaster);
chartSum.Series["Выручка"].Points.AddXY(masters[i], Sum);
chartSum.ChartAreas["ChartArea1"].AxisX.Interval = 1;
chartSum.ChartAreas[0].AxisX.LabelStyle.Angle = -30;
}
}
private void DoneWorks_Load(object sender, EventArgs e)
{
QueriesClass.SelectQuery(querySelectOrders, InfoWorks);
countWorks.Text = "Количество выполненных работ: " + (InfoWorks.RowCount - 1);
summLine.Text = "Сумма: " + Total() + "BYN";
//////////////////////////////////////////////////////////////////////////// WELL, MY BRAIN IS BROKEN
string querycount = "Select count(*) FROM masters";
string querycountser = "Select count(*) FROM service";
string querySelFIO = "SELECT Concat_ws(' ',surname,name,patronymic ) FROM masters";
string querySelService = "SELECT name_service FROM service";
int count = QueriesClass.SelectOne(querycount);
int countser = QueriesClass.SelectOne(querycountser);
List <string> pamagite = new List <string>();
List <string> pamagi = new List <string>();
///
pamagite.Clear();
pamagite = QueriesClass.SelectCombo(querySelFIO);
for (int i = 0; i < count; i++)
{
comboFIO.Items.Add(pamagite[i].ToString());
}
///
pamagi.Clear();
pamagi = QueriesClass.SelectCombo(querySelService);
for (int i = 0; i < countser; i++)
{
comboService.Items.Add(pamagi[i].ToString());
}
}
private void toolStripMenuItem2_Click(object sender, EventArgs e)
{
int id_service = Convert.ToInt32(tableService.CurrentRow.Cells[0].Value); //ID_service
string queryDeleteMaster = "DELETE from service WHERE service.id_service =" + id_service;
DialogResult result = MessageBox.Show(
"Вы действительно хотите удалить эту услугу?",
"Подтверждение",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
// Проверяем какая кнопка нажата ...
if (result == DialogResult.Yes)
{
QueriesClass.QuerytoTable(queryDeleteMaster);
QueriesClass.SelectQuery(querySelectService, tableService);
}
else
{
this.TopMost = true;
}// Ставим нашу форму по верх всех окон
this.TopMost = true;
}
public void GetProductsWithNRecentReviewsTest()
{
List <Product> list = QueriesClass.GetProductsWithNRecentReviews(1);
Assert.AreEqual(list.Count, 2);
Assert.AreEqual(list[0].ProductID, 709);
Assert.AreEqual(list[1].ProductID, 798);
}
private void resetFilters_Click(object sender, EventArgs e)
{
comboFIO.SelectedIndex = -1;
comboService.SelectedIndex = -1;
dateTimePicker2.Value = dateTimePicker1.Value;
QueriesClass.SelectQuery(querySelectOrders, InfoWorks);
firstPrice.Text = "";
secondPrice.Text = "";
}
public void GetNRecentlyReviewedProducts()
{
List <Product> list = QueriesClass.GetNRecentlyReviewedProducts(3);
Assert.AreEqual(list.Count, 3);
Assert.AreEqual(list[0].ProductID, 937);
Assert.AreEqual(list[1].ProductID, 798);
Assert.AreEqual(list[2].ProductID, 709);
}
/// <summary>
/// queries
/// </summary>
private void AddOrder_Load(object sender, EventArgs e)
{
string querySelMasters = "SELECT id_master, Concat_ws(' ',surname,name,patronymic ) FROM masters";
QueriesClass.SelectQuery(querySelMasters, TableSelectMasters);
string querySelService = "SELECT id_service, name_service, service.price FROM service";
QueriesClass.SelectQuery(querySelService, TableSelectService);
Reset();
}
public void GetTotalStandardCostByCategoryTest()
{
ProductCategory category = new ProductCategory
{
Name = "Clothing"
};
int suma = QueriesClass.GetTotalStandardCostByCategory(category);
Assert.AreEqual(suma, 868);
}
private void save_Click(object sender, EventArgs e)
{
string ser = nameService.Text;
int pr = int.Parse(price.Text);
string queryUpdate = "UPDATE service SET name_service = '" + ser + "', price = " + pr + " WHERE (id_service = " + id_service + ");";
QueriesClass.QuerytoTable(queryUpdate);
MessageBox.Show("Изменения сохранены!");
this.Hide();
MastersServices mas = new MastersServices();
mas.Show();
}
public void GetProductNamesByVendorNameTest()
{
List <string> list = QueriesClass.GetProductNamesByVendorName("SUPERSALES INC.");
List <string> productNames = new List <string> {
"Decal 2", "Decal 1"
};
Assert.AreEqual(list.Count, 2);
for (int i = 0; i < list.Count; i++)
{
Assert.AreEqual(productNames[i], list[i]);
}
}
private void save_Click(object sender, EventArgs e)
{
string sur = surname.Text;
string name = nameTB.Text;
string patro = patronymic.Text;
string adr = adress.Text;
string ph = phoneNumber.Text;
string queryUpdate = "UPDATE masters SET Surname = '" + sur + "', Name = '" + name + "', Patronymic = '" + patro + "', Adress = '" +
adr + "', Phone = '" + ph + "' WHERE (id_master = " + id_master + ");";
QueriesClass.QuerytoTable(queryUpdate);
MessageBox.Show("Изменения сохранены!");
this.Hide();
MastersServices mas = new MastersServices();
mas.Show();
}
private void ChangeSum()
{
string service_name;
//MessageBox.Show(listBox.Items.Count.ToString());
string query;
int[] price = new int[listBox.Items.Count];
int sum = 0;
for (int i = 0; i < listBox.Items.Count; i++)
{
service_name = listBox.Items[i].ToString();
query = "SELECT price FROM service WHERE service.name_service = '" + service_name + "';";
price[i] = QueriesClass.SelectOne(query);
sum += price[i];
}
OrderSum.Text = sum + "BYN";
}
private void InsService_Click(object sender, EventArgs e)
{
string queryInsertService;
if (nameService.Text != "")
{
if (price.Text != "")
{
if (!price.Text.Contains("."))
{
queryInsertService = "Insert into service VALUES(0,'" + nameService.Text + "'," + int.Parse(price.Text) + ");";
QueriesClass.QuerytoTable(queryInsertService);
DialogResult result = MessageBox.Show(
"Услуга добавлена!",
"Well",
MessageBoxButtons.OK,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
this.TopMost = true;
Reset();
}
else
{
MessageBox.Show("Цена должна быть целочисленным значением!", "Ошибка!");
price.Focus();
return;
}
}
else
{
MessageBox.Show("Введите цену за услугу!", "Ошибка!");
price.Focus();
return;
}
}
else
{
MessageBox.Show("Введите название услуги!", "Ошибка!");
nameService.Focus();
return;
}
}
public void GetProductsByNameTest()
{
List <Product> list = QueriesClass.GetProductsByName("lov");
List <int> productIDs = new List <int>()
{
863, 862, 861, 860, 859, 858
};
List <string> productNames = new List <string> {
"Full-Finger Gloves, L", "Full-Finger Gloves, M",
"Full-Finger Gloves, S", "Half-Finger Gloves, L", "Half-Finger Gloves, M", "Half-Finger Gloves, S"
};
Assert.AreEqual(list.Count, 6);
for (int i = 0; i < list.Count; i++)
{
Assert.AreEqual(productIDs[i], list[i].ProductID);
Assert.AreEqual(productNames[i], list[i].Name);
}
}
public void GetNProductsFromCategoryTest()
{
List <Product> list = QueriesClass.GetNProductsFromCategory("Accessories", 7);
List <int> productIDs = new List <int>()
{
879, 877, 843, 878, 847, 848, 876
};
List <string> productNames = new List <string> {
"All-Purpose Bike Stand", "Bike Wash - Dissolver", "Cable Lock",
"Fender Set - Mountain", "Headlights - Dual-Beam", "Headlights - Weatherproof", "Hitch Rack - 4-Bike"
};
Assert.AreEqual(list.Count, 7);
for (int i = 0; i < list.Count; i++)
{
Assert.AreEqual(productIDs[i], list[i].ProductID);
Assert.AreEqual(productNames[i], list[i].Name);
}
}
private void comboService_SelectedIndexChanged(object sender, EventArgs e)
{
// Filter();
if (comboService.SelectedIndex > -1)
{
comboFIO.SelectedIndex = -1;
string querySelService = "SELECT orders.id_order,masters.Surname,masters.Name,masters.Patronymic,Group_concat(service.name_service SEPARATOR ', '), " +
"sum(service.price) ,concat_ws('-',day(orders.Date),month(orders.Date),year(orders.Date))" +
" FROM service INNER JOIN order_service ON service.id_service=order_service.id_service " +
" INNER JOIN orders ON orders.id_order= order_service.id_order " +
" INNER JOIN masters ON masters.id_master = orders.id_master" +
" GROUP BY order_service.id_order" + //sosat
" having INSTR(Group_concat(service.name_service SEPARATOR ', '), '" + comboService.Text + "') > 0 ";
QueriesClass.SelectQuery(querySelService, InfoWorks);
}
else
{
QueriesClass.SelectQuery(querySelectOrders, InfoWorks);
}
countWorks.Text = "Количество выполненных работ: " + (InfoWorks.RowCount - 1);
summLine.Text = "Сумма: " + Total() + "BYN";
}
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
comboFIO.SelectedIndex = -1;
comboService.SelectedIndex = -1;
firstPrice.Text = "";
secondPrice.Text = "";
string date1 = dateTimePicker1.Value.Year.ToString() + "-" + dateTimePicker1.Value.Month.ToString() + "-" + dateTimePicker1.Value.Day.ToString();
string date2 = dateTimePicker2.Value.Year.ToString() + "-" + dateTimePicker2.Value.Month.ToString() + "-" + dateTimePicker2.Value.Day.ToString();
//MessageBox.Show(date1 + " " + date2);
string querySeldate = "SELECT orders.id_order,masters.Surname,masters.Name,masters.Patronymic,Group_concat(service.name_service SEPARATOR ', ')," +
" sum(service.price) ,concat_ws('-',day(orders.Date),month(orders.Date),year(orders.Date))" +
" FROM service INNER JOIN order_service ON service.id_service=order_service.id_service " +
" INNER JOIN orders ON orders.id_order= order_service.id_order" +
" INNER JOIN masters ON masters.id_master = orders.id_master" +
" WHERE orders.Date BETWEEN '" + date1 + "' AND '" + date2 + "'" +
" GROUP BY order_service.id_order";
QueriesClass.SelectQuery(querySeldate, InfoWorks);
// Filter();
countWorks.Text = "Количество выполненных работ: " + (InfoWorks.RowCount - 1);
summLine.Text = "Сумма: " + Total() + "BYN";
}
private void InsOrder_Click(object sender, EventArgs e)
{
DateTime day = monthCalendar1.SelectionStart;
int IdMaster = 0;
int IdOrder;
string queryIDorder;
foreach (DataGridViewRow dr in TableSelectMasters.SelectedRows)
{
IdMaster = Convert.ToInt32(dr.Cells[0].Value); //ID_master
}
// MessageBox.Show("id мастера " + IdMaster.ToString());
string InsertOrder = "INSERT INTO orders VALUES (0,concat_ws('-', " + day.Year + ", " + day.Month + "," + day.Day + ")," + IdMaster + ")";
QueriesClass.QuerytoTable(InsertOrder);
queryIDorder = "SELECT last_insert_id(orders.id_order) FROM orders ORDER BY orders.id_order desc LIMIT 1"; // Get ID of last order
//MessageBox.Show("Сейчас кину ошибку");
IdOrder = QueriesClass.SelectOne(queryIDorder); //ID_order
string InsertOrder_Service;
string queryIDservice, service_name; //field for queries
int IdService;
if (listBox.Items.Count > 0 && TableSelectService.CurrentRow.Index != -1 && TableSelectMasters.CurrentRow.Index != -1)
{
for (int i = 0; i < listBox.Items.Count; i++)
{
service_name = listBox.Items[i].ToString();
queryIDservice = "SELECT service.id_service FROM service WHERE service.name_service = '" + service_name + "';"; //Get service ID
IdService = QueriesClass.SelectOne(queryIDservice); //ID_service
// MessageBox.Show("id услуги "+IdService.ToString());
// MessageBox.Show("id заказа " + IdOrder.ToString());
InsertOrder_Service = "INSERT INTO order_service VALUES (0," + IdOrder + "," + IdService + ")"; //Add fields in Order_service table
QueriesClass.QuerytoTable(InsertOrder_Service);
}
DialogResult result = MessageBox.Show(
"Заказ добавлен!",
"Well",
MessageBoxButtons.OK,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
this.TopMost = true;
Reset();
}
else
{
DialogResult result = MessageBox.Show(
"Для оформления заказа выберите услуги, мастера и дату проведения!",
"Attention",
MessageBoxButtons.OK,
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
this.TopMost = true;
return;
}
}
private void SearchField_TextChanged(object sender, EventArgs e)
{
string querySearhM = "SELECT * FROM masters WHERE masters.Surname like '%" + SearchField.Text + "%' or masters.Name like '%" + SearchField.Text + "%' or masters.Patronymic like '%" + SearchField.Text + "%' or masters.Phone like '%" + SearchField.Text + "%'";
QueriesClass.SelectQuery(querySearhM, MastersTable);
}
private void searchService_TextChanged(object sender, EventArgs e)
{
string querySearhS = "SELECT * FROM service WHERE service.name_service like '%" + searchService.Text + "%'";
QueriesClass.SelectQuery(querySearhS, tableService);
}
public void GetProductVendorByProductNameTest()
{
string vendorName = QueriesClass.GetProductVendorByProductName("Thin-Jam Hex Nut 1");
Assert.AreEqual(vendorName, "Advanced Bicycles");
}
private void firstSecondPrice_TextChanged(object sender, EventArgs e)
{
//Filter();
try
{
if (firstPrice.Text != "" && secondPrice.Text != "")
{
string AllPrice = "SELECT orders.id_order,masters.Surname,masters.Name,masters.Patronymic,Group_concat(service.name_service SEPARATOR ', ')," +
" sum(service.price) ,concat_ws('-',day(orders.Date),month(orders.Date),year(orders.Date))" +
" FROM service INNER JOIN order_service ON service.id_service=order_service.id_service " +
" INNER JOIN orders ON orders.id_order= order_service.id_order" +
" INNER JOIN masters ON masters.id_master = orders.id_master" +
" GROUP BY order_service.id_order" +
" HAVING sum(service.Price) BETWEEN " + int.Parse(firstPrice.Text) + " AND " + int.Parse(secondPrice.Text);
QueriesClass.SelectQuery(AllPrice, InfoWorks);
}
else
{
QueriesClass.SelectQuery(querySelectOrders, InfoWorks);
}
if (firstPrice.Text != "" && secondPrice.Text == "")
{
string fromPrice = "SELECT orders.id_order,masters.Surname,masters.Name,masters.Patronymic,Group_concat(service.name_service SEPARATOR ', ')," +
" sum(service.price) ,concat_ws('-',day(orders.Date),month(orders.Date),year(orders.Date))" +
" FROM service INNER JOIN order_service ON service.id_service=order_service.id_service " +
" INNER JOIN orders ON orders.id_order= order_service.id_order" +
" INNER JOIN masters ON masters.id_master = orders.id_master" +
" GROUP BY order_service.id_order" +
" HAVING sum(service.Price)> " + int.Parse(firstPrice.Text);
QueriesClass.SelectQuery(fromPrice, InfoWorks);
}
else
if (firstPrice.Text == "" && secondPrice.Text != "")
{
string toPrice = "SELECT orders.id_order,masters.Surname,masters.Name,masters.Patronymic,Group_concat(service.name_service SEPARATOR ', ')," +
" sum(service.price) ,concat_ws('-',day(orders.Date),month(orders.Date),year(orders.Date))" +
" FROM service INNER JOIN order_service ON service.id_service=order_service.id_service " +
" INNER JOIN orders ON orders.id_order= order_service.id_order" +
" INNER JOIN masters ON masters.id_master = orders.id_master" +
" GROUP BY order_service.id_order" +
" HAVING sum(service.Price)< " + int.Parse(secondPrice.Text);
QueriesClass.SelectQuery(toPrice, InfoWorks);
}
}
catch
{
DialogResult result = MessageBox.Show(
"Цена должна быть целочисленного формата",
"Attention",
MessageBoxButtons.OK,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
if (firstPrice.Text.Contains("."))
{
firstPrice.Text = "";
}
else
{
secondPrice.Text = "";
}
this.TopMost = true;
}
countWorks.Text = "Количество выполненных работ: " + (InfoWorks.RowCount - 1);
summLine.Text = "Сумма: " + Total() + "BYN";
}
private void Masters_Load(object sender, EventArgs e)
{
QueriesClass.SelectQuery(querySelectMasters, MastersTable);
QueriesClass.SelectQuery(querySelectService, tableService);
count.Text = "Количество мастеров: " + (MastersTable.RowCount - 1);
}
private void InsMaster_Click(object sender, EventArgs e)
{
string phone;
string queryInsertMaster;
if (surname.Text != "")
{
if (nameTB.Text != "")
{
if (patronymic.Text != "")
{
if (adress.Text != "")
{
if (phoneNumber.Text != "" && PhoneKod.SelectedIndex != -1)
{
if (!phoneNumber.Text.Contains("."))
{
phone = PhoneKod.SelectedItem.ToString() + phoneNumber.Text;
queryInsertMaster = "Insert into masters VALUES(0,'" + surname.Text + "','" + nameTB.Text + "','" + patronymic.Text + "','" +
adress.Text + "','" + phone + "');";
QueriesClass.QuerytoTable(queryInsertMaster);
DialogResult result = MessageBox.Show(
"Мастер добавлен!",
"Well",
MessageBoxButtons.OK,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
this.TopMost = true;
Reset();
}
else
{
MessageBox.Show("Номер телефона не должен содержать '.'!", "Ошибка!");
phoneNumber.Focus();
return;
}
}
else
{
MessageBox.Show("Введите номер телефона!", "Ошибка!");
phoneNumber.Focus();
return;
}
}
else
{
MessageBox.Show("Введите адрес!", "Ошибка!");
adress.Focus();
return;
}
}
else
{
MessageBox.Show("Введите отчество!", "Ошибка!");
patronymic.Focus();
return;
}
}
else
{
MessageBox.Show("Введите имя!", "Ошибка!");
nameTB.Focus();
return;
}
}
else
{
MessageBox.Show("Введите фамилию!", "Ошибка!");
surname.Focus();
return;
}
}