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

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

                if (status == false)
                {
                    lblEMsg.Visible = true;
                    lblEMsg.Text = "Publisher deletion Failed";
                }
                lblEMsg.Visible = true;
                lblEMsg.Text = "Publisher deleted.";

                lstid.Items.Clear();

                //Load all the Publisher First.
                string sql = "SELECT Publisher_ID FROM Publisher where Status = 'A'";
                SqlDataReader sdr;

                sdr = pro.ReturnMDetails(sql);

                while (sdr.Read())
                {
                    lstid.Items.Add(sdr["Publisher_ID"].ToString().Trim());
                }
                sdr.Close();
                txtPName.Text = "";
                txtPYear.Text = "";
                txtPHouse.Text = "";
                txtPEdition.Text = "";
                txtAdd.Text = "";
                txtPhone.Text = "";
                txtFax.Text = "";
                txtemail.Text = "";
                chkStatus.Checked = true;
                return;
                //txtCName.Text = "";
                //txtcDesc.Text = "";
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }