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(); }