protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int Result = 0;
int bid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
List <Publication> _PubicationList = new List <Publication>();
List <Book> _BookList = new List <Book>();
_publicationBL = new PublicationBL();
_PubicationList = _publicationBL.BL_Publication_Select_BY_PID(bid);
_BookList = _publicationBL.BL_BOOK_Select_BY_PNAME(_PubicationList[0].PublicationName.ToString());
if (_BookList.Count > 0)
{
lblmsg.Text = "Please, delete all books of this publication.";
}
else
{
Result = _publicationBL.BL_Publication_Delete(bid);
if (Result != 0)
{
lblmsg.Text = "Record Deleted !!";
_PubicationList = _publicationBL.BL_Publication_Select();
GridView1.DataSource = _PubicationList;
GridView1.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblmsg.Text = "";
if (Page.IsPostBack == false)
{
List <Branch> _BranchList = new List <Branch>();
_BranchBL = new BranchBL();
_BranchList = _BranchBL.BL_Branch_Select();
drpbranch.DataSource = _BranchList;
drpbranch.DataTextField = "BranchName";
drpbranch.DataValueField = "BranchID";
drpbranch.DataBind();
drpbranch.Items.Insert(0, "SELECT");
List <Publication> _PublicationList = new List <Publication>();
_PublicationBLL = new PublicationBL();
_PublicationList = _PublicationBLL.BL_Publication_Select();
drppublication.DataSource = _PublicationList;
drppublication.DataTextField = "PublicationName";
drppublication.DataValueField = "PID";
drppublication.DataBind();
drppublication.Items.Insert(0, "SELECT");
}
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
List <Publication> _PubicationList = new List <Publication>();
_publicationBL = new PublicationBL();
GridView1.EditIndex = -1;
_PubicationList = _publicationBL.BL_Publication_Select();
GridView1.DataSource = _PubicationList;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
lblmsg.Text = "";
if (Page.IsPostBack == false)
{
List <Publication> _PubicationList = new List <Publication>();
_publicationBL = new PublicationBL();
_PubicationList = _publicationBL.BL_Publication_Select();
GridView1.DataSource = _PubicationList;
GridView1.DataBind();
}
}
protected void btnadd_Click(object sender, EventArgs e)
{
int result = 0;
List <Publication> _PubicationList = new List <Publication>();
_publicationBL = new PublicationBL();
result = _publicationBL.BL_Publication_Insert(txtpub.Text);
if (result != 0)
{
lblmsg.Text = "Publication Added Successfully !!";
_PubicationList = _publicationBL.BL_Publication_Select();
GridView1.DataSource = _PubicationList;
GridView1.DataBind();
txtpub.Text = "";
txtpub.Focus();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int result = 0;
List <Publication> _PubicationList = new List <Publication>();
_publicationBL = new PublicationBL();
int pid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
TextBox pname = GridView1.Rows[e.RowIndex].Cells[2].Controls[0] as TextBox;
result = _publicationBL.BL_Publication_Update(pid, pname.Text);
if (result != 0)
{
lblmsg.Text = "Record Updated !!";
GridView1.EditIndex = -1;
_PubicationList = _publicationBL.BL_Publication_Select();
GridView1.DataSource = _PubicationList;
GridView1.DataBind();
}
}
protected void btnviewpublication_Click(object sender, EventArgs e)
{
if (drppublication.SelectedIndex == 0)
{
GridView1.DataSource = null;
GridView1.DataBind();
lblmsg.Text = "Select Publication !!";
lblmsg.ForeColor = System.Drawing.Color.Red; MultiView1.ActiveViewIndex = -1;
}
else
{
MultiView1.ActiveViewIndex = 0;
List <Book> _BookList = new List <Book>();
_PublicationBLL = new PublicationBL();
_BookList = _PublicationBLL.BL_BOOK_Select_BY_PNAME(drppublication.SelectedItem.Text);
GridView1.DataSource = _BookList;
GridView1.DataBind();
lblmsg0.Text = GridView1.Rows.Count.ToString() + " - Records Found.";
}
}
