public static DataSet UsersManagementMultipleSchool(string operate, string userID, string category, string area, string schoolyear)
{
string SP = "dbo.EPA_sys_ApplicationUsersMultipleSchool";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[5];
myBaseParametersC.SetupBaseParameters(ref myPara, operate, userID, category, area, schoolyear);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet Competency(string operate, string userID, string category, string area)
{
string SP = "dbo.EPA_sys_DomainCompetencyList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet SchoolList(string operate, string userID, string category, string area)
{
string SP = "dbo.EPA_ORG_SchoolsList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet UserRoleManagement(string operate, string userID, string category, string area)
{
string SP = "dbo.EPA_sys_ApplicationRole";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet Category(string operate, string userID)
{
string SP = "dbo.EPA_sys_CategoryList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, "", "");
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet SystemItems(string operate, string userID, string category, string itemType)
{
string SP = "dbo.EPA_sys_SystemItemsList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, itemType);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet RegionAreaList(string operate, string userID, string category, string area)
{
string SP = "dbo.EPA_ORG_RegionAreaList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet Statements(string action, string userID, string schoolyear, string schoolcode, string category, string area, string IDs)
{
string SP = "dbo.EPA_sys_Statement";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[7];
myBaseParametersC.SetupBaseParameters(ref myPara, action, userID, category, area, schoolyear, schoolcode, IDs);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet SchoolInformation(string operate, string userID, string category, string area, string IDs)
{
string SP = "dbo.EPA_ORG_SchoolsList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[5];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 10, "@IDs", IDs);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet LookFors(string operate, string userID, string category, string area, string competencyID)
{
string SP = "dbo.EPA_sys_DomainCompetencyLookForsList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[5];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 10, "@competencyID", competencyID);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet CommentsBank(string operate, string userID, string category, string area, string type, string owner)
{
string SP = "dbo.EPA_sys_CommentsBankList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[6];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 30, "@Type", type);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 30, "@Owner", owner);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet History(string operate, string userID, string schoolYear, string schoolCode)
{
try
{
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[4];
SetupThisParameters(ref myPara, operate, userID, schoolYear, schoolCode);
return(SetSQLParameter.getMyDataSet(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return(null);
}
}
private static DataSet myListReader(string operate, string userID)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[2];
myBaseParametersL.SetupBaseParameters(ref myPara, operate, userID);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return(null);
}
}
private static DataSet myListReader2(string operate, string userID, string vPara1)
{
try
{
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[3];
myBaseParametersL.SetupBaseParameters(ref myPara, operate, userID, vPara1);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return(null);
}
}
public static DataSet SchoolListByArea(string operate, string userID, string schoolYear, string schoolCode, string schoolArea)
{
try
{
string sp = "dbo.tcdsb_PLF_SchoolListbyArea";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[5];
SetupThisParameters(ref myPara, operate, userID, schoolYear, schoolCode);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 4, 10, "@SchoolArea", schoolArea);
return(SetSQLParameter.getMyDataSet(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return(null);
}
}
private static DataSet myListReader2(string operate, string userID, string vPara1, string vPara2)
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[4];
myBaseParametersL.SetupBaseParameters(ref myPara, operate, userID, vPara1, vPara2);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
private static DataSet myListReader2(string operate, string userID, string vPara1, string vPara2, string vPara3)
{
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[5];
myBaseParametersL.SetupBaseParameters(ref myPara, operate, userID, vPara1, vPara2, vPara3);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}