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";
MyADO.MyParameterDB[] myPara = new MyADO.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 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";
MyADO.MyParameterDB[] myPara = new MyADO.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 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";
MyADO.MyParameterDB[] myPara = new MyADO.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));
}
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)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[5];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, categoryID, areaID, itemCode);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static string Tips(string _aID, string _cID, string _pID, string _iID)
{
try
{
string _SP = "dbo.EPA_sys_TitleTips";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[5];
myBaseParametersA.SetupBaseParameters(ref myPara, "UPA", _aID, _cID, _pID, _iID);
return(SetSQLParameter.getMyDataValue(_SP, myPara));
}
catch (Exception ex)
{ return("" + ex.Message); }
finally
{ }
}
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
{ }
}
private static string LastValue(string operate)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[2];
myBaseParameters.SetupBaseParameters(ref myPara, operate, HttpContext.Current.User.Identity.Name);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
catch (Exception ex)
{ var em = ex.Message;
return(""); }
finally
{ }
}
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 NameHelpShow(string _UserID, string _aID, string _cID, string _pID, string _iID)
{
try
{
string _SP = "dbo.EPA_sys_TitleHelpShow";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[5];
myBaseParametersA.SetupBaseParameters(ref myPara, _UserID, _aID, _cID, _pID, _iID);
return(SetSQLParameter.getMyDataValue(_SP, myPara));
}
catch (Exception ex)
{ return("" + ex.Message); }
finally
{ }
}
public static string TeamSetup(string operate, string userID, string schoolYear, string schoolCode)
{
try
{
string sp = "dbo.tcdsb_PLF_SchoolSiteTeam";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[4];
SetupThisParameters(ref myPara, operate, userID, schoolYear, schoolCode);
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)
{
try
{
string sp = "dbo.EPA_Appr_AppraisalProcess_NotificationTemplatePersonal";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[8];
SetupThisParameters(ref myPara, operate, userID, category, noticType, noticeArea, noticeGo, noticeFrom, purpose);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
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 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 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 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 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 string NameLong(string _UserID, string _aID, string _cID, string _pID, string _iID)
{
try
{
string _SP = "dbo.EPA_sys_Title2";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[5];
myBaseParametersA.SetupBaseParameters(ref myPara, _UserID, _aID, _cID, _pID, _iID);
return(SetSQLParameter.getMyDataValue(_SP, myPara));
}
catch (Exception ex)
{ var em = ex.Message;
return(""); }
finally
{ }
}
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 string ItemNamebyCode(string operate, string userID, string categoryID, string areaID)
{
string sp = "dbo.EPA_sys_MenuItemName";
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, categoryID, areaID);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
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 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));
}
public static string NotificationeTemplate(string operate, string userID, string category, string noticType, string noticeArea, string noticeGo, string noticeFrom, string purpose, string subject)
{
try
{
string sp = "dbo.EPA_Appr_AppraisalProcess_NotificationTemplate";
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, 250, "@Subject", subject);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static string Items(string _UserID, string _aID, string _mID, string _Type, string _cID, string _gID, string _iID, string _tID)
{
try
{
string _SP = "dbo.EPA_sys_Menus";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[8];
SetupThisParameters(ref myPara, _UserID, _aID, _mID, _Type, _cID, _gID, _iID, _tID);
return(SetSQLParameter.getMyDataValue(_SP, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
finally
{ }
}
public static string NotificationeMail(string operate, string userID, string schoolyear, string schoolcode, string employeeid, string sessionID, string noticeType, string noticeArea)
{
try
{
string sp = "dbo.EPA_Appr_AppraisalProcess_Notification";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[8];
myBaseParameters.SetupBaseParameters(ref myPara, operate, userID, schoolyear, schoolcode, employeeid, sessionID);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 6, 30, "@NoticeType", noticeType);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 7, 10, "@NoticeArea", noticeArea);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static string Content(string operate, string userID, string categoryID, string areaID, string itemCode, string userRole, string schoolyear, string subject, string feedBack)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[9];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, categoryID, areaID, itemCode);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 5, 10, "@UserRole", userRole);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 6, 10, "@SchoolYear", schoolyear);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 7, 100, "@Subject", subject);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 8, 2000, "@Feedback", HttpContext.Current.Server.HtmlDecode(feedBack));
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}