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); }