public static void SetLists(System.Web.UI.WebControls.ListControl myListControl, ParameterSP parameter) { string sp = "dbo.tcdsb_PLF_ListDDL2New @Operate,@UserID,@UserRole,@SchoolYear"; List <List2Item> myList = GeneralDataAccess.GetObjectList <List2Item>(sp, parameter); AssemblingMyList(myListControl, myList); }
public static void SetLists2(System.Web.UI.WebControls.DropDownList myListControl, System.Web.UI.WebControls.DropDownList myListControl2, ParameterSP parameter) { string sp = "dbo.tcdsb_PLF_ListSchoolsNew @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode"; List <List2Item> myList = GeneralDataAccess.GetObjectList <List2Item>(sp, parameter); AssemblingMyList(myListControl, myList, "myValue", "myValue"); // school Code DDL AssemblingMyList(myListControl2, myList, "myValue", "myText"); // School Name DDL }
public static void BindGridView(ref GridView myGridView, string listPage, string method, string userID, string schoolYear, string schoolCode) { try { ParameterSP parameter = new ParameterSP { Operate = method, UserID = userID, SchoolYear = schoolYear, SchoolCode = schoolCode }; // List<SiteTeams> teams = GeneralDataAccess.GetTeamList(sp, parameter); List <SiteTeams> teams = GeneralDataAccess.GetObjectList <SiteTeams>(sp, parameter); myGridView.DataSource = teams; myGridView.DataBind(); } catch (System.Exception ex) { string em = ex.Message; } }
public static List <FormContent> ListofContent(string schoolYear, string schoolCode) { try { string sp = "dbo.tcdsb_PLF_FormData_WebAPI @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode"; ParameterSP0 parameter = new ParameterSP0 { Operate = "Content", UserID = "", SchoolYear = schoolYear, SchoolCode = schoolCode }; // List<FormContent> myList = GeneralDataAccess.GetFormContentList(sp, parameter); List <FormContent> myList = GeneralDataAccess.GetObjectList <FormContent>(sp, parameter); return(myList); } catch (Exception ex) { var exm = ex.Message; return(null); } }