private void lblSup_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
this.Hide();
Supplier_Form sp = new Supplier_Form();
sp.ShowDialog();
}
private void txtSupplier_Leave(object sender, EventArgs e)
{
if (txtSupplier.Text == "")
{
MessageBox.Show("Supplier Name Missing", "Pharmacy System");
txtSupplier.Focus();
}
else
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("Select SName from tblSupplier where SName='" + txtSupplier.Text + "'", con);
SqlDataReader rd = cmd.ExecuteReader();
int count = 0;
while (rd.Read())
{
count++;
}
con.Close();
if (count >= 1)
{
supplier(1);
}
else
{
supplier(0);
DialogResult dia = MessageBox.Show("The Supplier with the supplied name is not in the database, do you wish to save?", "Pharmacy System", MessageBoxButtons.YesNo);
if (dia == DialogResult.Yes)
{
Supplier_Form sp = new Supplier_Form();
sp.ShowDialog();
}
else if (dia == DialogResult.No)
{
MessageBox.Show("Kindly Correct The Name Before Proceding", "Pharmacy System");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
con.Close();
}
}
}
