public static DataSet GetSTD_CampusByCampusID(long CampusID) { DataSet sTD_Rooms = new DataSet(); SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider(); sTD_Rooms = sqlSTD_RoomProvider.GetSTD_RoomByCampusID(CampusID); return sTD_Rooms; }
public static STD_Room GetSTD_RoomByRoomID(int RoomID) { STD_Room sTD_Room = new STD_Room(); SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider(); sTD_Room = sqlSTD_RoomProvider.GetSTD_RoomByRoomID(RoomID); return sTD_Room; }
public static STD_Room GetSTD_CampusByCampusID(int CampusID) { STD_Room sTD_Room = new STD_Room(); SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider(); sTD_Room = sqlSTD_RoomProvider.GetSTD_RoomByCampusID(CampusID); return sTD_Room; }
public static DataSet GetDropDownListAllSTD_Room() { DataSet sTD_Rooms = new DataSet(); SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider(); sTD_Rooms = sqlSTD_RoomProvider.GetDropDownListAllSTD_Room(); return sTD_Rooms; }
public static DataSet GetAllSTD_RoomsWithRelation() { DataSet sTD_Rooms = new DataSet(); SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider(); sTD_Rooms = sqlSTD_RoomProvider.GetAllSTD_Rooms(); return sTD_Rooms; }
public static void LoadSTD_RoomPage(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); SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider(); DataSet ds = sqlSTD_RoomProvider.GetSTD_RoomPageWise(pageIndex, PageSize, out recordCount); gv.DataSource = ds; gv.DataBind(); sTD_RoomsPaggination(rptPager,recordCount, pageIndex, PageSize); }
public static int InsertSTD_Room(STD_Room sTD_Room) { SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider(); return sqlSTD_RoomProvider.InsertSTD_Room(sTD_Room); }
public static bool DeleteSTD_Room(int sTD_RoomID) { SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider(); return sqlSTD_RoomProvider.DeleteSTD_Room(sTD_RoomID); }
public static bool UpdateSTD_Room(STD_Room sTD_Room) { SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider(); return sqlSTD_RoomProvider.UpdateSTD_Room(sTD_Room); }