protected void btnUpdate_Click(object sender, EventArgs e)
{
lblEMsg.Visible = false;
string[] Pub;
Profile pro = new Profile();
try
{
if (lstid.SelectedItem.Text == "")
{
lblEMsg.Text = "Please select Publisher ID";
lblEMsg.Visible = true;
}
else
{
Pub = new string[15];
Pub[0] = lstid.Text;
Pub[1] = txtPName.Text;
Pub[2] = txtPYear.Text;
Pub[3] = txtPHouse.Text;
Pub[4] = txtPEdition.Text;
Pub[5] = txtAdd.Text;
Pub[6] = txtPhone.Text;
Pub[7] = txtFax.Text;
Pub[8] = txtemail.Text;
if (chkStatus.Checked == true)
{
Pub[9] = "A";
}
else
{
Pub[9] = "D";
}
bool status;
status = pro.UpdatePublisher(Pub);
if (status == false)
{
lblEMsg.Visible = true;
lblEMsg.Text = "Publisher updation Failed";
}
lblEMsg.Visible = true;
lblEMsg.Text = "Publisher updated.";
//Load all the Category First.
string sql = "SELECT Publisher_ID FROM Publisher";
SqlDataReader sdr;
sdr = pro.ReturnMDetails(sql);
lstid.Items.Clear();
while (sdr.Read())
{
lstid.Items.Add(sdr["Publisher_ID"].ToString().Trim());
}
sdr.Close();
return;
//txtCName.Text = "";
//txtcDesc.Text = "";
}
}
catch (Exception ex)
{
throw ex;
}
}
