protected void btnUpdate_Click(object sender, EventArgs e)
{
lblEMsg.Visible = false;
string[] Book;
Profile pro = new Profile();
string Author_ID, Publisher_ID, Category_ID, Supplier_ID;
try
{
if (lstbook.SelectedItem.Text == "")
{
lblEMsg.Text = "Please select Book ID";
lblEMsg.Visible = true;
}
else
{
string sql;
//Retrieve Author ID.
sql = "SELECT Author_ID FROM Author WHERE Author_Name = '" + LstAuthor.SelectedItem.Text + "'";
Author_ID = ReturnData(sql);
//Retrieve Publisher ID.
sql = "SELECT Publisher_ID FROM Publisher WHERE Publisher_Name = '" + LstPublisher.SelectedItem.Text + "'";
Publisher_ID = ReturnData(sql);
//Retrieve Category ID.
sql = "SELECT Category_ID FROM Category WHERE Category_Name = '" + LstCategory.SelectedItem.Text + "'";
Category_ID= ReturnData(sql);
//Retrieve Supplier ID.
sql = "SELECT Supplier_ID FROM Supplier WHERE Supplier_Name = '" + LstSupplier.SelectedItem.Text + "'";
Supplier_ID= ReturnData(sql);
Book = new string[15];
Book[0] = lstbook.SelectedItem.Text;
Book[1] = txtBTitle.Text;
Book[2] = Author_ID;
Book[3] = Publisher_ID;
Book[4] = Category_ID;
Book[5] = Supplier_ID;
Book[6] = txtKey.Text;
Book[7] = txtIsbn.Text;
Book[8] = txtQuantity.Text;
Book[9] = txtPrice.Text;
if (chkStatus.Checked == true)
{
Book[10] = "A";
}
else
{
Book[10] = "D";
}
bool status;
status = pro.Books(Book,"UpdateBook");
if (status == false)
{
lblEMsg.Visible = true;
lblEMsg.Text = "Book updation Failed";
}
lblEMsg.Visible = true;
lblEMsg.Text = "Book updated.";
ReadBook();
lstbook.Text = "";
txtBTitle.Text = "";
LstAuthor.Text = "";
LstCategory.Text = "";
LstPublisher.Text = "";
LstSupplier.Text = "";
txtKey.Text = "";
txtIsbn.Text = "";
txtQuantity.Text = "";
txtPrice.Text = "";
chkStatus.Checked = false;
lblEMsg.Visible = false;
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
lblEMsg.Visible = false;
string[] Book;
string Author_ID, Publisher_ID, Category_ID, Supplier_ID;
try
{
string sql;
SqlDataReader sdr;
Profile pro = new Profile();
//Retrieve Author ID.
sql = "SELECT Author_ID FROM Author WHERE Author_Name = '" + LstAuthor.SelectedItem.Text + "'";
sdr = pro.ReturnMDetails(sql);
if (sdr.Read() == true)
{
Author_ID = sdr["Author_ID"].ToString().Trim();
}
else
{
Author_ID = "";
}
sdr.Close();
//Retrieve Publisher ID.
sql = "SELECT Publisher_ID FROM Publisher WHERE Publisher_Name = '" + LstPublisher.SelectedItem.Text + "'";
sdr = pro.ReturnMDetails(sql);
if (sdr.Read() == true)
{
Publisher_ID = sdr["Publisher_ID"].ToString().Trim();
}
else
{
Publisher_ID = "";
}
sdr.Close();
//Retrieve Category ID.
sql = "SELECT Category_ID FROM Category WHERE Category_Name = '" + LstCategory.SelectedItem.Text + "'";
sdr = pro.ReturnMDetails(sql);
if (sdr.Read() == true)
{
Category_ID = sdr["Category_ID"].ToString().Trim();
}
else
{
Category_ID = "";
}
sdr.Close();
//Retrieve Supplier ID.
sql = "SELECT Supplier_ID FROM Supplier WHERE Supplier_Name = '" + LstSupplier.SelectedItem.Text + "'";
sdr = pro.ReturnMDetails(sql);
if (sdr.Read() == true)
{
Supplier_ID = sdr["Supplier_ID"].ToString().Trim();
}
else
{
Supplier_ID= "";
}
sdr.Close();
sql = "SELECT COUNT(*) FROM Book_Master WHERE Book_Title = '" + txtBTitle.Text + "' And Author_ID ='" + Author_ID + "' And Publisher_ID = '" + Publisher_ID + "' And Status = 'A'";
sdr = pro.ReturnMDetails(sql);
sdr.Read();
int RegNo = (int)sdr[0];
if (RegNo > 0)
{
lblEMsg.Text = "Book Name already exists.";
lblEMsg.Visible = true;
sdr.Close();
return;
}
else
{
Book = new string[15];
Book[0] = txtBook.Text;
Book[1] = txtBTitle.Text;
Book[2] = Author_ID;
Book[3] = Publisher_ID;
Book[4] = Category_ID;
Book[5] = Supplier_ID;
Book[6] = txtKey.Text;
Book[7] = txtIsbn.Text;
Book[8] = txtQuantity.Text;
Book[9] = txtPrice.Text;
if (chkStatus.Checked == true)
{
Book[10] = "A";
}
else
{
Book[10] = "I";
}
bool status;
status = pro.Books(Book,"AddBook");
if (status == false)
{
lblEMsg.Visible = true;
lblEMsg.Text = "Book creation Failed";
}
lblEMsg.Visible = true;
lblEMsg.Text = "Book added.";
ReadBook();
txtBTitle.Text = "";
LstAuthor.Text = "";
LstCategory.Text = "";
LstPublisher.Text = "";
LstSupplier.Text = "";
txtKey.Text = "";
txtIsbn.Text = "";
txtQuantity.Text = "";
txtPrice.Text = "";
chkStatus.Checked = false;
lblEMsg.Visible = false;
}
}
catch (Exception ex)
{
throw ex;
}
}
