private void button4_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex == 0) { if (checkBox4.Checked == false) { MessageBox.Show("Please select delete checkbox above for Deleting Package", "Error!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (checkBox4.Enabled) { if (textBox1.Text == "") { MessageBox.Show("Please Fill correctly and do not leave blank" + "\n 1.PackageName to Delete", "Error!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { DomesticPackage pc = new DomesticPackage(); pc.Packagename = textBox1.Text; // pc.Schedule = textBox2.Text; //pc.Amount = int.Parse(textBox3.Text); DBAccess dbp = new DBAccess(); dbp.DeleteDomesticPackage(pc); MessageBox.Show("Package Has Been Deleted", "Success!!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else if (comboBox1.SelectedIndex == 1) { if (checkBox4.Checked == false) { MessageBox.Show("Please select delete checkbox above for Deleting Package", "Error!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (checkBox4.Enabled) { if (textBox1.Text == "") { MessageBox.Show("Please Fill correctly and do not leave blank" + "\n 1.PackageName to Delete", "Error!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { InternationalPackage pc = new InternationalPackage(); pc.Packagename = textBox1.Text; //pc.Schedule = textBox2.Text; //pc.Amount = int.Parse(textBox3.Text); DBAccess dbp = new DBAccess(); dbp.DeleteInternationalPackage(pc); MessageBox.Show("Package Has Been Deleted", "Success!!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else if (comboBox1.SelectedIndex <= 0) { MessageBox.Show("Please Select the Package Category", "Error!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void UpdateDomSchAmo(DomesticPackage dp) { SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=NYIHEINHTET;Initial Catalog=yadanarmyay;Integrated Security=true"; SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "update DomesticPackage set Schedule='" + dp.Schedule + "',Amount=" + dp.Amount + " where PackageName='" + dp.Packagename + "'"; con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void SaveDomesticPackage(DomesticPackage dp) { SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=SC;Initial Catalog=yadanarmyay;Integrated Security=true"; SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "Insert Into DomesticPackage Values('" + dp.Packagename + "','" + dp.Schedule + "'," + dp.Amount + ")"; con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void DeleteDomesticPackage(DomesticPackage dp) { SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=NYIHEINHTET;Initial Catalog=yadanarmyay;Integrated Security=true"; SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "delete from DomesticPackage where PackageName='" + dp.Packagename + "'"; con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
private void button3_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex == 0) { if (checkBox3.Checked == false) { MessageBox.Show("Please select Update Schedule & Amount checkbox above for Updating", "Error!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (checkBox3.Enabled) { if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "") { MessageBox.Show("Please Fill correctly and do not leave blank" + "\n 1. Old PackageName for Updating Schedule & Amount" + "\n 2. New Schedule for Updating" + "\n 3. New Amount for Updating", "Error!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { try { if (int.Parse(textBox3.Text) <= 0) { MessageBox.Show("Please Enter Amount of Package wih at least $100", "Amount Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { DomesticPackage pc = new DomesticPackage(); pc.Packagename = textBox1.Text; pc.Schedule = textBox2.Text; pc.Amount = int.Parse(textBox3.Text); DBAccess dbp = new DBAccess(); dbp.UpdateDomSchAmo(pc); MessageBox.Show("Schedule & Amount Has Been Updated", "Success!!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (FormatException) { MessageBox.Show("Please Enter Correct Number format for Amount of Packages", "Amount Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (OverflowException) { MessageBox.Show("Please Enter Correct Sensible Amount of Package", "Package Amount Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } else if (comboBox1.SelectedIndex == 1) { if (checkBox3.Checked == false) { MessageBox.Show("Please select Update Schedule & Amount checkbox above for Updating", "Error!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (checkBox3.Enabled) { if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "") { MessageBox.Show("Please Fill correctly and do not leave blank" + "\n 1. Old PackageName for Updating Schedule & Amount" + "\n 2. New Schedule for Updating" + "\n 3. New Amount for Updating", "Error!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { try { if (int.Parse(textBox3.Text) <= 0) { MessageBox.Show("Please Enter Amount of Package wih at least $100", "Amount Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { InternationalPackage pc = new InternationalPackage(); pc.Packagename = textBox1.Text; pc.Schedule = textBox2.Text; pc.Amount = int.Parse(textBox3.Text); DBAccess dbp = new DBAccess(); dbp.UpdateInterSchAmo(pc); MessageBox.Show("Schedule & Amount Has Been Updated", "Success!!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (FormatException) { MessageBox.Show("Please Enter Correct Number format for Amount of Packages", "Amount Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (OverflowException) { MessageBox.Show("Please Enter Correct Sensible Amount of Package", "Package Amount Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } else { MessageBox.Show("Please Select the Package Category", "Error!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }