public static DataSet GetLIB_IssueBooksBySearchString(string searchSQLString)
{
DataSet lIB_BookIssues = new DataSet();
SqlLIB_BookIssueProvider sqlLIB_BookIssueProvider = new SqlLIB_BookIssueProvider();
lIB_BookIssues = sqlLIB_BookIssueProvider.GetLIB_IssueBooksBySearchString(searchSQLString);
return lIB_BookIssues;
}
public static LIB_BookIssue GetLIB_BookIssueByBookIssueID(int BookIssueID)
{
LIB_BookIssue lIB_BookIssue = new LIB_BookIssue();
SqlLIB_BookIssueProvider sqlLIB_BookIssueProvider = new SqlLIB_BookIssueProvider();
lIB_BookIssue = sqlLIB_BookIssueProvider.GetLIB_BookIssueByBookIssueID(BookIssueID);
return lIB_BookIssue;
}
public static LIB_BookIssue GetLIB_IssedToByIssedToID(string IssedToID)
{
LIB_BookIssue lIB_BookIssue = new LIB_BookIssue();
SqlLIB_BookIssueProvider sqlLIB_BookIssueProvider = new SqlLIB_BookIssueProvider();
lIB_BookIssue = sqlLIB_BookIssueProvider.GetLIB_BookIssueByIssedToID(IssedToID);
return lIB_BookIssue;
}
public static DataSet GetDropDownListAllLIB_BookIssue()
{
DataSet lIB_BookIssues = new DataSet();
SqlLIB_BookIssueProvider sqlLIB_BookIssueProvider = new SqlLIB_BookIssueProvider();
lIB_BookIssues = sqlLIB_BookIssueProvider.GetDropDownListAllLIB_BookIssue();
return lIB_BookIssues;
}
public static DataSet GetAllLIB_BookIssuesWithRelation()
{
DataSet lIB_BookIssues = new DataSet();
SqlLIB_BookIssueProvider sqlLIB_BookIssueProvider = new SqlLIB_BookIssueProvider();
lIB_BookIssues = sqlLIB_BookIssueProvider.GetAllLIB_BookIssues();
return lIB_BookIssues;
}
public static int InsertLIB_BookReceive(LIB_BookIssue lIB_BookIssue)
{
SqlLIB_BookIssueProvider sqlLIB_BookIssueProvider = new SqlLIB_BookIssueProvider();
return sqlLIB_BookIssueProvider.InsertLIB_BookReceive(lIB_BookIssue);
}
public static bool DeleteLIB_BookIssue(int lIB_BookIssueID)
{
SqlLIB_BookIssueProvider sqlLIB_BookIssueProvider = new SqlLIB_BookIssueProvider();
return sqlLIB_BookIssueProvider.DeleteLIB_BookIssue(lIB_BookIssueID);
}
public static bool UpdateLIB_BookIssue(LIB_BookIssue lIB_BookIssue)
{
SqlLIB_BookIssueProvider sqlLIB_BookIssueProvider = new SqlLIB_BookIssueProvider();
return sqlLIB_BookIssueProvider.UpdateLIB_BookIssue(lIB_BookIssue);
}
public static void LoadLIB_BookIssuePage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount=0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlLIB_BookIssueProvider sqlLIB_BookIssueProvider = new SqlLIB_BookIssueProvider();
DataSet ds = sqlLIB_BookIssueProvider.GetLIB_BookIssuePageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
lIB_BookIssuesPaggination(rptPager,recordCount, pageIndex, PageSize);
}
