public static List <List2Item> GetLists(string operate, string userID, string userRole, string schoolYear, string schoolCode)
{
using (IDbConnection connection = new SqlConnection(conSTR))
{
string SP = "dbo.tcdsb_PLF_ListSchoolsNew @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode";
ParameterSP2 parameter = new ParameterSP2 {
Operate = operate, UserID = userID, UserRole = userRole, SchoolYear = schoolYear, SchoolCode = schoolCode
};
var mylist = connection.Query <List2Item>(SP, parameter).ToList();
return(mylist);
}
}
public static List <School> GetAreaSchools(string operate, string userID, string userRole, string schoolYear, string schoolCode, string schoolArea)
{
using (IDbConnection connection = new SqlConnection(conSTR))
{
string SP = "dbo.tcdsb_PLF_AreaSchoolList @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode,@SchoolArea";
ParameterSP2 parameter = new ParameterSP2 {
Operate = operate, UserID = userID, UserRole = userRole, SchoolYear = schoolYear, SchoolCode = schoolCode, SchoolArea = schoolArea
};
var schoollist = connection.Query <School>(SP, parameter).ToList();
return(schoollist);
}
}
public static void BindGridView(ref GridView myGridView, string listPage, string method, string userID, string schoolYear, string schoolCode, string schoolArea)
{
try
{
if (listPage == "SchoolListbyArea")
{
string sp = "dbo.tcdsb_PLF_AreaSchoolList @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode,@SchoolArea";
ParameterSP2 parameter = new ParameterSP2 {
Operate = "", UserID = userID, SchoolYear = schoolYear, SchoolCode = schoolCode, SchoolArea = schoolArea
};
List <School> schools = GeneralDataAccess.GetSchoolList(sp, parameter);
// List<School> schools = PublishList.GetAreaSchools("Get", "Role", userID, schoolyear, schoolcode, schoolArea); ;
myGridView.DataSource = schools;
myGridView.DataBind();
}
}
catch (System.Exception ex)
{
string em = ex.Message;
}
}
