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 размерыКостюмовToolStripMenuItem_Click(object sender, EventArgs e)
{
costumeSizeForm = new CostumeSizeForm(this);
costumeSizeForm.Show();
}
