public static void SetupBaseParameters(ref MyADO.MyParameterDB[] myPara, string userID, string _aID, string _cID, string _pID, string _iID)
{
SetSQLParameter.setParameterArray(myPara, DbType.String, 0, 30, "@UserID", userID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 1, 30, "@ApplID", _aID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 2, 30, "@CategoryID", _cID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 3, 30, "@PageID", _pID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 30, "@ItemID", _iID);
}
private static void SetupThisParameters(ref myCommon.MyParameterDB[] myPara, string action, string userID, string category, string area, string IDs, string code, string name, string comments, string active)
{
myBaseParametersB.SetupBaseParameters(ref myPara, action, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 10, "@IDs", IDs);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 20, "@Code", code);
SetSQLParameter.setParameterArray(myPara, DbType.String, 6, 100, "@Name", name);
SetSQLParameter.setParameterArray(myPara, DbType.String, 7, 250, "@Comments", comments);
SetSQLParameter.setParameterArray(myPara, DbType.String, 8, 1, "@Active", active);
}
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 string SchoolInformation(string operate, string userID, string category, string area, string IDs, string code)
{
string SP = "dbo.EPA_ORG_SchoolsList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[6];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 10, "@IDs", IDs);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 20, "@Code", code);
return(SetSQLParameter.getMyDataValue(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 string UsersManagement(string operate, string userID, string category, string area, string IDs, string userCode, string userName, string userRole, string comments, string active)
{
string SP = "dbo.EPA_sys_ApplicationUsers";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[10];
SetupThisParameters(ref myPara, operate, userID, category, area, IDs, userCode, userName, comments, active);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 100, "@UserRole", userRole);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
private static void SetupThisParameters(ref MyADO.MyParameterDB[] myPara, string operate, string userID, string category, string noticType, string noticArea, string noticeGo, string noticeFrom, string purpose)
{
myBaseParameters.SetupBaseParameters(ref myPara, operate, userID);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 2, 10, "@Category", category);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 3, 30, "@NoticeType", noticType);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 4, 10, "@NoticeArea", noticArea);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 5, 15, "@NoticeGo", noticeGo);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 6, 15, "@NoticeFrom", noticeFrom);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 7, 10, "@Purpose", purpose);
}
private static void SetupThisParameters(ref MyADO.MyParameterDB[] myPara, string _UserID, string _aID, string _mID, string _Type, string _cID, string _gID, string _iID, string _tID)
{
SetSQLParameter.setParameterArray(myPara, DbType.String, 0, 50, "@UserID", _UserID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 1, 20, "@AppCode", _aID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 2, 20, "@Model", _mID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 3, 20, "@Type", _Type);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 20, "@CategoryID", _cID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 20, "@GroupID", _gID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 6, 20, "@ItemID", _iID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 7, 30, "@TitleID", _tID);
}
public static string SystemItems(string operate, string userID, string category, string itemType, string IDs, string code, string name, string comments, string active, string steps, string keyPoint)
{
string SP = "dbo.EPA_sys_SystemItemsList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[11];
SetupThisParameters(ref myPara, operate, userID, category, itemType, IDs, code, name, comments, active);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 50, "@Orders", steps);
SetSQLParameter.setParameterArray(myPara, DbType.String, 10, 50, "@KeyPoint", keyPoint);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string Statements(string action, string userID, string schoolyear, string schoolcode, string category, string area, string IDs, string statement, string topic, string startDate, string endDate)
{
string SP = "dbo.EPA_sys_Statement";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[11];
myBaseParametersC.SetupBaseParameters(ref myPara, action, userID, category, area, schoolyear, schoolcode, IDs);
SetSQLParameter.setParameterArray(myPara, DbType.String, 7, 2500, "@Statement", statement);
SetSQLParameter.setParameterArray(myPara, DbType.String, 8, 250, "@Subject", topic);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 10, "@StartDate", startDate);
SetSQLParameter.setParameterArray(myPara, DbType.String, 10, 10, "@EndDate", endDate);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string Competency(string operate, string userID, string category, string area, string IDs, string code, string name, string comments, string active, string TPA, string NTP, string LTO)
{
string SP = "dbo.EPA_sys_DomainCompetencyList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[12];
SetupThisParameters(ref myPara, operate, userID, category, area, IDs, code, name, comments, active);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 1, "@TPA", TPA);
SetSQLParameter.setParameterArray(myPara, DbType.String, 10, 1, "@NTP", NTP);
SetSQLParameter.setParameterArray(myPara, DbType.String, 11, 1, "@LTO", LTO);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string UsersManagementMultipleSchool(string operate, string userID, string category, string area, string schoolyear, string IDs, string principalID, string schoolcode, string comments, string active)
{
string SP = "dbo.EPA_sys_ApplicationUsersMultipleSchool";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[10];
myBaseParametersC.SetupBaseParameters(ref myPara, operate, userID, category, area, schoolyear, schoolcode, IDs);
SetSQLParameter.setParameterArray(myPara, DbType.String, 7, 30, "@PrincipalID", principalID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 8, 250, "@Comments", comments);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 1, "@Active", active);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string RegionAreaList(string operate, string userID, string category, string area, string IDs, string regionCode, string regionName, string comments, string active, string district, string superID, string officer)
{
string SP = "dbo.EPA_ORG_RegionAreaList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[12];
SetupThisParameters(ref myPara, operate, userID, category, area, IDs, regionCode, regionName, comments, active);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 30, "@District", district);
SetSQLParameter.setParameterArray(myPara, DbType.String, 10, 30, "@SuperID", superID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 11, 30, "@Officer", officer);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
private static void LastValue(string operate, string value)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[3];
myBaseParameters.SetupBaseParameters(ref myPara, operate, HttpContext.Current.User.Identity.Name);
SetSQLParameter.setParameterArray(myPara, DbType.String, 2, 50, "@Value", value);
SetSQLParameter.getMyDataValue(SP, myPara);
}
catch (Exception ex)
{ var em = ex.Message; }
finally
{ }
}
public static string LookFors(string operate, string userID, string category, string area, string competencyID, string IDs, string code, string name, string comments, string active)
{
string SP = "dbo.EPA_sys_DomainCompetencyLookForsList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[10];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 10, "@competencyID", competencyID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 10, "@IDs", IDs);
SetSQLParameter.setParameterArray(myPara, DbType.String, 6, 20, "@Code", code);
SetSQLParameter.setParameterArray(myPara, DbType.String, 7, 100, "@Name", name);
SetSQLParameter.setParameterArray(myPara, DbType.String, 8, 250, "@Comments", comments);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 1, "@Active", active);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string Content(string operate, string userID, string categoryID, string areaID, string itemCode, string title, string subTitle)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[7];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, categoryID, areaID, itemCode);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 5, 200, "@Title", HttpContext.Current.Server.HtmlDecode(title));
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 6, 500, "@SubTitle", HttpContext.Current.Server.HtmlDecode(subTitle));
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{ var em = ex.Message;
return(""); }
}
public static string CommentsBank(string operate, string userID, string category, string area, string type, string owner, string IDs, string domainID, string shared, string comments, string active)
{
string SP = "dbo.EPA_sys_CommentsBankList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[11];
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);
SetSQLParameter.setParameterArray(myPara, DbType.String, 6, 10, "@IDs", IDs);
SetSQLParameter.setParameterArray(myPara, DbType.String, 7, 10, "@DomainID", domainID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 8, 50, "@Shared", shared);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 250, "@Comments", comments);
SetSQLParameter.setParameterArray(myPara, DbType.String, 10, 1, "@Active", active);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static void Message(string _UserID, string _aID, string _cID, string _pID, string _iID, string _value)
{
try
{
string _SP = "dbo.EPA_sys_TitleM";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[6];
myBaseParametersA.SetupBaseParameters(ref myPara, _UserID, _aID, _cID, _pID, _iID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 200, "@Value", _value);
SetSQLParameter.getMyDataValue(_SP, myPara);
}
catch (Exception ex)
{ var em = ex.Message; }
finally
{ }
}
public static string TextValue1(string operate, string userID, string schoolYear, string schoolCode, string itemCode)
{
try
{
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[5];
SetupThisParameters(ref myPara, operate, userID, schoolYear, schoolCode);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 4, 10, "@ItemCode", itemCode);
return(SetSQLParameter.getMyDataValue("sp", myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return(null);
}
}
public static string FeedBackeMail(string operate, string userID, string noticType)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[3];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 2, 30, "@NoticeType", noticType);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static string Tips(string _UserID, string _aID, string _cID, string _pID, string _iID, string _value)
{
try
{
string _SP = "dbo.EPA_sys_TitleTips";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[6];
myBaseParametersA.SetupBaseParameters(ref myPara, _UserID, _aID, _cID, _pID, _iID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 200, "@Value", _value);
return(SetSQLParameter.getMyDataValue(_SP, myPara));
}
catch (Exception ex)
{ return("Fail - " + ex.Message); }
finally
{ }
}
public static string Content(string operate, string userID, string categoryID, string areaID, string itemCode, string helpType)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[6];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, categoryID, areaID, itemCode);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 5, 10, "@HelpType", helpType);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static void Items(string _UserID, string _aID, string _mID, string _Type, string _cID, string _gID, string _iID, string _tID, string _value)
{
try
{
string _SP = "dbo.EPA_sys_Menus";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[9];
SetupThisParameters(ref myPara, _UserID, _aID, _mID, _Type, _cID, _gID, _iID, _tID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 8, 500, "@Value", HttpContext.Current.Server.HtmlDecode(_value));
SetSQLParameter.getMyDataValue(_SP, myPara);
}
catch (Exception ex)
{ var em = ex.Message; }
finally
{ }
}
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);
}
}
public static string Content(string operate, string userID, string categoryID, string areaID, string itemCode, string helpType, string value)
{
try
{
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[7];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, categoryID, areaID, itemCode);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 5, 10, "@HelpType", helpType);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 6, 2000, "@Value", HttpContext.Current.Server.HtmlDecode(value));
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static string Title(string userID, string itemCode)
{
try
{
string sp = "dbo.tcdsb_PLF_GetItemLabel";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[2];
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 0, 30, "@UserID", userID);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 1, 10, "@ItemCode", itemCode);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return(null);
}
}
public static string SignOff(string operate, string userID, string schoolYear, string schoolCode, string actionType)
{
try
{
string sp = "dbo.tcdsb_PLF_Form_SignOff";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[5];
SetupThisParameters(ref myPara, operate, userID, schoolYear, schoolCode);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 4, 20, "@ActionType", actionType);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return(null);
}
}
public static string NotificationeTemplatePersonal(string operate, string userID, string category, string noticType, string noticeArea, string noticeGo, string noticeFrom, string purpose, string templateType)
{
try
{
string sp = "dbo.EPA_Appr_AppraisalProcess_NotificationTemplatePersonal";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[9];
SetupThisParameters(ref myPara, operate, userID, category, noticType, noticeArea, noticeGo, noticeFrom, purpose);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 8, 20, "@TemplateType", templateType);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static string SchoolInformation(string operate, string userID, string category, string area, string IDs, string schoolCode, string schoolName, string comments, string active, string district, string header, string areacode, string panel, string tpa, string ppa)
{
string SP = "dbo.EPA_ORG_SchoolsList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[15];
SetupThisParameters(ref myPara, operate, userID, category, area, IDs, schoolCode, schoolName, comments, active);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 30, "@District", district);
SetSQLParameter.setParameterArray(myPara, DbType.String, 10, 30, "@Header", header);
SetSQLParameter.setParameterArray(myPara, DbType.String, 11, 30, "@AreaCode", areacode);
SetSQLParameter.setParameterArray(myPara, DbType.String, 12, 10, "@Panel", panel);
SetSQLParameter.setParameterArray(myPara, DbType.String, 13, 1, "@TPA", tpa);
SetSQLParameter.setParameterArray(myPara, DbType.String, 14, 1, "@PPA", ppa);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
