private void OKButton_Click(object sender, EventArgs e)
{
if (nameTypeTB.Text.Trim(' ') == "")
{
MessageBox.Show("Заполните все обязательные поля!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
string nameCostumeType = nameTypeTB.Text;
string query = String.Format(@"INSERT INTO `carnaval`.`costume_type`
(`name`)
VALUES
('{0}');", nameCostumeType);
long inserted_id = DB.SetNoResultQuery(query);
if (inserted_id > 0)
{
hide();
refreshData();
}
else
{
MessageBox.Show("При добавлении костюма произошла ошибка, \nобратитесь к системному администратору!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void OKButton_Click(object sender, EventArgs e)
{
if (fioTB.Text.Trim(' ') == "" && phoneTB.Text.Trim(' ') == "")
{
MessageBox.Show("Заполните все обязательные поля!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
string adress, numPass, datePass, departPass, fio = fioTB.Text.Replace("'", "\'"), phone = phoneTB.Text.Replace("'", "\'");
adress = numPass = datePass = departPass = "******";
if (adressTB.Text.Trim(' ') != "")
{
adress = "'" + adressTB.Text + "'";
}
if (passDateDTP.Value != null)
{
datePass = "******" + DB.DateToMysql(passDateDTP.Value, true, false) + "'";
}
if (passNumTB.Text.Trim(' ') != "")
{
numPass = "******" + passNumTB.Text + "'";
}
if (passDepartRTB.Text.Trim(' ') != "")
{
departPass = "******" + passDepartRTB.Text + "'";
}
string query = String.Format(@"INSERT INTO `carnaval`.`client`
(`name`,
`telephone`,
`address`,
`id_passport`,
`passport_issue`,
`passport_depart`)
VALUES
(
'{0}',
'{1}',
{2},
{3},
{4},
{5});", fio, phone, adress, numPass, datePass, departPass);
long inserted_id = DB.SetNoResultQuery(query);
if (inserted_id > 0)
{
hide();
// mainDGV.Rows.Add(fio, phone);
//focusOnRowDGV();
refreshData();
}
else
{
MessageBox.Show("При добавлении клиента произошла ошибка, \nобратитесь к системному администратору!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void notPaidButton_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in mainDGV.SelectedRows)
{
int bill_id = (int)DB.GetRowCol(row, "id_bill");
string query = string.Format("UPDATE `bill` SET `paid` = 0 WHERE `id_bill` = {0}", bill_id);
DB.SetNoResultQuery(query);
}
SetMainDGV(searchTB.Text);
}
private void OKButton_Click(object sender, EventArgs e)
{
if (costumeDT.Rows.Count == 0)
{
MessageBox.Show("Выберите костюмы для выдачи");
return;
}
if ((from DataRow x in costumeDT.Rows where x["vendor"] == "" select x).ToList().Count > 0)
{
MessageBox.Show("Введите артикул для каждого костюма");
return;
}
string date = DB.DateToMysql(dateDTP.Value, true, false);
int client_id = (int)clientCB.SelectedValue;
string query = "";
if (CurState == State.Add)
{
foreach (DataRow x in costumeDT.Rows)
{
query = string.Format("INSERT INTO `order` (`date`, `client_id`, `costume_size_id`, " +
"`vendor`, `costume_price`, `costume_daily_price`, `returndate_shedule`) " +
"VALUES ('{0}', {1}, {2}, '{3}', {4}, {5}, '{6}')",
date, client_id, x["costume_size_id"], x["vendor"],
x["costume_price"], x["costume_daily_price"],
DB.DateToMysql((DateTime)x["returndate_shedule"], true, false));
int order_id = DB.SetNoResultQuery(query);
string bill_query = string.Format("INSERT INTO `bill` (`date`, `bill_type_id`, `order_id`, " +
"`employee_id`, `price`, `paid`) VALUES ('{0}', 1, {1}, {2}, {3}, 1)",
date, order_id, Program.employee_id, x["costume_price"]);
DB.SetNoResultQuery(bill_query);
}
}
else
{
foreach (DataRow x in costumeDT.Rows)
{
query = string.Format("UPDATE `order` SET `date` = '{0}', `client_id` = {1}, " +
"`costume_size_id` = {2}, `vendor` = '{3}', `returndate_shedule` = '{4}', " +
"`costume_price` = {5}, `costume_daily_price` = {6} WHERE `id_order` = {7}",
date, client_id, x["costume_size_id"], x["vendor"],
DB.DateToMysql((DateTime)x["returndate_shedule"], true, false),
x["costume_price"], x["costume_daily_price"], x["id_order"]);
DB.SetNoResultQuery(query);
string bill_query = string.Format("UPDATE `bill` SET `date` = '{0}', `price` = {1} WHERE " +
"`order_id` = {2} AND `bill_type_id` = 1", date, x["rent_price"], x["id_order"]);
DB.SetNoResultQuery(bill_query);
}
}
// -----
SetMainDGV(searchTB.Text);
CurState = State.Table;
}
private void deleteButton_Click(object sender, EventArgs e)
{
DataGridViewSelectedRowCollection rows = mainDGV.SelectedRows;
int n = rows.Count;
string text;
string caption;
if (n == 1)
{
text = string.Format("Вы уверены, что хотите удалить размер костюма \n{0}?",
DB.GetRowCol(rows[0], "costume_name"));
caption = "Удаление размера костюма";
}
else
{
Func <string> GetWordForm = () =>
{
if (n % 100 >= 11 && n % 100 <= 19)
{
return("размеров костюмов");
}
if (n % 10 == 1)
{
return("размер костюма");
}
if (n % 10 >= 2 && n % 10 <= 4)
{
return("размера костюма");
}
return("размеров костюмов");
};
text = string.Format("Вы уверены, что хотите удалить {0} {1}?",
n, GetWordForm());
caption = "Удаление размеров костюмов";
}
DialogResult answer = MessageBox.Show(text, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (answer == DialogResult.No)
{
return;
}
var ids = from DataGridViewRow x in rows
select DB.GetRowCol(x, "id_costume_size");
string query = string.Format("DELETE FROM `costume_size` WHERE `id_costume_size` IN ({0})",
string.Join(", ", ids));
DB.SetNoResultQuery(query);
SetMainDGV(searchTB.Text);
}
private void OKButton_Click(object sender, EventArgs e)
{
if (nameTB.Text.Trim(' ') == "" || priceTB.Text.Trim(' ') == "" || typeCB.SelectedText.ToString() == null || daily_priceTB.Text.Trim(' ') == "")
{
MessageBox.Show("Заполните все обязательные поля!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
string priceCostume = priceTB.Text, daily_priceCostume = daily_priceTB.Text, typeCostume = typeCB.SelectedValue.ToString(), nameCostume = nameTB.Text.Replace("'", "\'");
string query;
if (state == "add")
{
query = String.Format(@"INSERT INTO `carnaval`.`costume`
(`name`,
`costume_type_id`,
`price`,
`daily_price`)
VALUES
('{0}',
{1},
{2},
{3});", nameCostume, typeCostume, priceCostume, daily_priceCostume);
}
else
{
query = String.Format(@"UPDATE `carnaval`.`costume`
SET
`name` = '{0}',
`costume_type_id` = '{1}',
`price` = '{2}',
`daily_price` = '{3}'
WHERE `id_costume` = '{4}';
", nameCostume, typeCostume, priceCostume, daily_priceCostume, DB.GetRowCol(mainDGV.SelectedRows[0], "id_costume").ToString());
}
int inserted_id = DB.SetNoResultQuery(query);
hide();
// mainDGV.Rows.Add(fio, phone);
//focusOnRowDGV();
refreshData();
if (callerForm != null && callerForm.GetType() == typeof(CostumeSizeForm))
{
CostumeSizeForm CSForm = (CostumeSizeForm)callerForm;
DB.FillCB(CSForm.costumeCB, Properties.Resources.CostumeQuery, "id_costume", "name");
if (inserted_id != 0)
{
CSForm.costumeCB.SelectedValue = inserted_id;
}
Close();
}
}
}
private void deleteButton_Click(object sender, EventArgs e) //не доделал
{
DataGridViewSelectedRowCollection rows = mainDGV.SelectedRows;
int n = rows.Count;
string text;
string caption;
if (n == 1)
{
if (MessageBox.Show(String.Format("Вы уверены, что хотите удалить запись о костюме\n{0}?",
mainDGV[0, mainDGV.CurrentRow.Index].Value.ToString()), "Внимание", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == System.Windows.Forms.DialogResult.OK)
{
string query = String.Format(@"
DELETE FROM `carnaval`.`costume`
WHERE id_costume={0};", DB.GetRowCol(mainDGV.Rows[mainDGV.SelectedCells[0].RowIndex], "id_costume"));
DB.SetNoResultQuery(query);
}
refreshData();
}
else
{
Func <string> GetWordForm = () =>
{
if (n % 100 >= 11 && n % 100 <= 19)
{
return("записей");
}
if (n % 10 == 1)
{
return("запись");
}
if (n % 10 >= 2 && n % 10 <= 4)
{
return("записи");
}
return("записей");
};
if (MessageBox.Show(String.Format("Вы уверены, что хотите удалить {0} {1} о клиентах?",
n, GetWordForm()), "Внимание", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == System.Windows.Forms.DialogResult.OK)
{
var ids = from DataGridViewRow x in rows
select DB.GetRowCol(x, "id_costume");
string query = string.Format("DELETE FROM `costume` WHERE `id_costume` IN ({0})", string.Join(", ", ids));
DB.SetNoResultQuery(query);
refreshData();
}
}
}
private void OKButton_Click(object sender, EventArgs e)
{
returndateDTP.Value = new DateTime
(returndateDTP.Value.Year, returndateDTP.Value.Month, returndateDTP.Value.Day);
int dept;
if (!Int32.TryParse(deptTB.Text, out dept))
{
MessageBox.Show("Поля заполнены некорректно");
return;
}
string dt = DB.DateToMysql(returndateDTP.Value, true, false);
var return_filter = from DataGridViewRow x in rows
select(int) DB.GetRowCol(x, "id_order");
string return_query = string.Format("UPDATE `order` SET `returndate_actual` = '{0}' " +
"WHERE `id_order` IN ({1})", dt, string.Join(", ", return_filter));
DB.SetNoResultQuery(return_query);
// ИСПРАВИТЬ ВЫЧИСЛЕНИЕ СЧЕТА НА ВОЗВРАТ ДЕПОЗИТА
var bill_return_filter =
from DataGridViewRow x in rows
select string.Format("('{0}', 2, {1}, {2}, {3}, 0)",
dt, DB.GetRowCol(x, "id_order"), Program.employee_id,
DB.GetRowCol(x, "costume_price"));
string bill_return_query = string.Format("INSERT INTO `bill` (`date`, `bill_type_id`, `order_id`, " +
"`employee_id`, `price`, `paid`) VALUES {0}", string.Join(", ", bill_return_filter));
DB.SetNoResultQuery(bill_return_query);
var bill_filter =
from DataGridViewRow x in rows
where returndateDTP.Value > (DateTime)DB.GetRowCol(x, "returndate_shedule")
select string.Format("('{0}', 3, {1}, {2}, {3}, 0)",
dt, DB.GetRowCol(x, "id_order"), Program.employee_id,
Controller.GetRentPrice((DateTime)DB.GetRowCol(x, "returndate_shedule"), returndateDTP.Value, dept));
if (bill_filter.Count() > 0)
{
string bill_query = string.Format("INSERT INTO `bill` (`date`, `bill_type_id`, `order_id`, " +
"`employee_id`, `price`, `paid`) VALUES {0}", string.Join(", ", bill_filter));
DB.SetNoResultQuery(bill_query);
}
new BillForm(DB.GetRowCol(rows[0], "client_name").ToString()).Show();
Close();
}
private void OKButton_Click(object sender, EventArgs e)
{
string query;
int amount;
try
{
amount = Convert.ToInt32(amountTB.Text);
}
catch
{
MessageBox.Show("Заполните поля корректно");
return;
}
if (CurState == State.Add)
{
query = string.Format("INSERT INTO `costume_size` (`costume_id`, `size_id`, `amount`) " +
"VALUES ({0}, {1}, {2})", costumeCB.SelectedValue, sizeCB.SelectedValue, amount);
}
else
{
query = string.Format("UPDATE `costume_size` SET `costume_id` = {0}, `size_id` = {1}, " +
"`amount` = {2} WHERE `id_costume_size` = {3}",
costumeCB.SelectedValue, sizeCB.SelectedValue, amount, curCS_id);
}
if (CurState == State.Add)
{
curCS_id = DB.SetNoResultQuery(query);
}
else
{
DB.SetNoResultQuery(query);
}
SetMainDGV(searchTB.Text);
if (orderForm != null && orderForm.CurState == OrderForm.State.Add)
{
AddOrderCostume();
}
CurState = State.Table;
}
private void OKButton_Click(object sender, EventArgs e)
{
if (sizeTB.Text.Trim(' ') == "" || altSizeTB.Text.Trim(' ') == "")
{
MessageBox.Show("Заполните все обязательные поля!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
string query;
string size = sizeTB.Text, altSize = altSizeTB.Text;
if (state == "add")
{
query = String.Format(@"INSERT INTO `carnaval`.`size`
(`name`,
`numeric`)
VALUES
('{0}',
'{1}');", size, altSize);
}
else
{
query = String.Format(@"UPDATE `carnaval`.`size`
SET
`name` = '{0}',
`numeric` = '{1}'
WHERE `id_size` = {2};", size, altSize, DB.GetRowCol(mainDGV.SelectedRows[0], "id_size").ToString());
}
long inserted_id = DB.SetNoResultQuery(query);
if (inserted_id > 0)
{
hide();
refreshData();
}
else
{
MessageBox.Show("При добавлении размера произошла ошибка, \nобратитесь к системному администратору!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
