Exemple #1
0
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        lblEMsg.Visible = false;
        Profile pro = new Profile();

        try
        {
            if (lstid.SelectedItem.Text == "")
            {
                lblEMsg.Text = "Please select Supplier ID";
                lblEMsg.Visible = true;
            }
            else
            {
                bool status;
                status = pro.DeleteSupplier(lstid.SelectedItem.Text);

                if (status == false)
                {
                    lblEMsg.Visible = true;
                    lblEMsg.Text = "Supplier deletion Failed";
                }
                lblEMsg.Visible = true;
                lblEMsg.Text = "Supplier deleted.";
                lstid.Items.Clear();

                //Load all the Category First.
                string sql = "SELECT Supplier_ID FROM Supplier Where Status ='A'";
                SqlDataReader sdr;

                sdr = pro.ReturnMDetails(sql);

                while (sdr.Read())
                {
                    lstid.Items.Add(sdr["Supplier_ID"].ToString().Trim());
                }
                sdr.Close();
                txtSName.Text = "";
                txtAdd.Text = "";
                txtPhone.Text = "";
                txtFax.Text = "";
                txtEmail.Text = "";
                chkStatus.Checked = false;
                return;

            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }