private void Button2_Click(object sender, EventArgs e)
{
int pid = Convert.ToInt32(comboBox7.SelectedValue);
int sid = Convert.ToInt32(comboBox6.SelectedValue);
int psid = Products_SuppliersDB.GetPSID_By_P_SID(pid, sid);
Products_SuppliersDB.UpdatePS(psid, pid, sid);
}
private void button4_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(textBox7.Text))
{
MessageBox.Show("Please Enter a Package Name !", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (dateTimePicker1.Value >= dateTimePicker2.Value)
{
MessageBox.Show("Package End Date must be later than Package Start Date !",
"Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (string.IsNullOrWhiteSpace(textBox9.Text))
{
MessageBox.Show("Please Enter Package Description !",
"Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (string.IsNullOrWhiteSpace(textBox11.Text))
{
MessageBox.Show("Please Enter Base Price !",
"Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (string.IsNullOrWhiteSpace(textBox10.Text))
{
MessageBox.Show("Please Enter Agency Commission !",
"Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (Convert.ToInt32(textBox10.Text) > Convert.ToInt32(textBox11.Text))
{
MessageBox.Show("Agency Commission cannot be greater than the Base Price !",
"Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (list3_ToDB.Count == 0)
{
MessageBox.Show("Please choose products for this package !",
"Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
int newID = PackagesDB.AddPackageForForm2(textBox7.Text,
dateTimePicker1.Value, dateTimePicker2.Value,
textBox9.Text,
Convert.ToDecimal(textBox11.Text.ToString()),
Convert.ToDecimal(textBox10.Text.ToString()));
if (newID == -1)
{
MessageBox.Show("Error adding Package.");
}
else
{
foreach (var ps in list3_ToDB)
{
int psid = Products_SuppliersDB.GetPSID_By_P_SID(ps.ProductId, ps.SupplierId);
if (!Packages_Products_SuppliersDB.AddPPS(newID, psid))
{
MessageBox.Show("Error adding Packages_Products_Suppliers.");
}
}
}
listBox3.DataSource = null;
list3.Clear();
list3_ToDB.Clear();
textBox7.Text = "";
textBox9.Text = "";
textBox11.Text = "";
textBox10.Text = "";
}
