public static string UserRole(string userID)
{
string SP = "dbo.tcdsb_LTO_PageUser_Role @UserID";
var wt = new { UserID = userID };
return(CommonExcute <string> .GeneralValue(SP, wt));
}
private static string getSecurityRole(string userID, string type, string role)
{
string SP = "dbo.tcdsb_LTO_PageUser_RoleAndPermission @UserID, @Type, @Role";
var wt = new { UserID = userID, Type = type, Role = role };
return(CommonExcute <string> .GeneralValue(SP, wt));
}
public static void ActionTrack(string userID, string loginServer, string screenSize, string workRole, string workYear, string online, string browser)
{
string SP = "dbo.tcdsb_LTO_PageUser_LoginTrack @UserID, @LoginServer, @ScreenSize, @WorkRole, @WorkYear, @OnLine, @Browser ";
LoginTrack lt = new LoginTrack {
UserID = userID, LoginServer = loginServer, ScreenSize = screenSize, WorkRole = workRole, WorkYear = workYear, OnLine = online, Browser = browser
};
string result = CommonExcute <LoginTrack> .GeneralValue(SP, lt);
}
public static void ContactInfo(string userID, string cpNum, string homePhone, string cellPhone, string eMail, string comments)
{
string SP = "dbo.tcdsb_LTO_PageUser_ApplicantProfile @UserID, @CPNum, @HomePhone, @CellPhone, @Email, @Comments";
ApplicantNotice anotice = new ApplicantNotice {
UserID = userID, CPNum = cpNum, HomePhone = homePhone, CellPhone = cellPhone, Email = eMail, Comments = comments
};
string result = CommonExcute <ApplicantNotice> .GeneralValue(SP, anotice);
}
public static void TrackInfo(string userID, string type, string value)
{
string SP = "dbo.tcdsb_LTO_PageUser_Track @UserID, @Type, @Value";
WorkingTrack wt = new WorkingTrack {
UserID = userID, Type = type, Value = value
};
var result = CommonExcute <WorkingTrack> .GeneralValue(SP, wt);
}
public static string TrackInfo(string userID, string type)
{
string SP = "dbo.tcdsb_LTO_PageUser_Track @UserID, @Type";
WorkingTrack wt = new WorkingTrack {
UserID = userID, Type = type
};
return(CommonExcute <WorkingTrack> .GeneralValue(SP, wt));
}
public static string WorkingTask(string userID, string positionType, string schoolYear, string taskType)
{
string SP = "dbo.tcdsb_LTO_PageUser_TasksCount @UserID, @Type, @SchoolYear, @TaskType";
WorkingTrack wt = new WorkingTrack {
UserID = userID, Type = positionType, SchoolYear = schoolYear, TaskType = taskType
};
return(CommonExcute <WorkingTrack> .GeneralValue(SP, wt));
}
public static string SchoolGeoProfile(string type, string schoolcode)
{
string SP = "dbo.tcdsb_LTO_PageUser_SchoolGeoProfile @Type, @SchoolCode";
WorkingTrack wt = new WorkingTrack {
Type = type, SchoolCode = schoolcode
};
return(CommonExcute <WorkingTrack> .GeneralValue(SP, wt));
}
public static string ValidateDate(object parameter)
{
return(CommonExcute <string> .GeneralValue(GetSP("ValidateDate"), parameter));
}
public static string QualificationSTR(object parameter)
{
string SP = GetSP("QualificationSTR");
return(CommonExcute <string> .GeneralValue(SP, parameter));
}
//public static List<PositionPublish> DefaultDate(object parameter)
//{
// string SP = GetSP("DefaultDate");
// return CommonExcute<PositionPublish>.GeneralList(SP, parameter);
//}
//public static List<PositionPublish> PostingRounds(object parameter)
//{
// string SP = GetSP("PostingRounds");
// return CommonExcute<PositionPublish>.GeneralList(SP, parameter);
//}
public static string Add(object parameter)
{
string SP = GetSP("New");
return(CommonExcute <NewPosition> .GeneralValue(SP, parameter));
}
public static string Operation(string action, object parameter)
{
string SP = GetSP(action);
return(CommonExcute <string> .GeneralValue(SP, parameter));
}
public static string PernrNum(object parameter)
{
string SP = GetSP("PernrNum");
return(CommonExcute <string> .GeneralValue(SP, parameter));
}
public static string PrincipalsEmail(object parameter)
{
string sp = GetSp("PrincipalsEmail");
return(CommonExcute <string> .GeneralValue(sp, parameter));
}
public static string Cancel(object parameter)
{
string sp = GetSp("Cancel");
return(CommonExcute <string> .GeneralValue(sp, parameter));
}
public static string Delete(object parameter)
{
string SP = GetSP("Insert");
return(CommonExcute <string> .GeneralValue(SP, parameter));
}
public static string SelectedForInterview(object parameter)
{
string SP = GetSP("SelectedForInterview");
return(CommonExcute <string> .GeneralValue(SP, parameter));
}
public static string TeacherName(object parameter)
{
return(CommonExcute <string> .GeneralValue(GetSP("TeacherName"), parameter));
}
public static string Profile(object parameter)
{
return(CommonExcute <string> .GeneralValue(GetSP("Profile"), parameter));
}
public static string PostingNumber(object parameter)
{
return(CommonExcute <string> .GeneralValue(GetSP("PostingNumber"), parameter));
}
public static string Reject(object parameter)
{
return(CommonExcute <string> .GeneralValue(GetSP("Reject"), parameter));
}
public static string ConvertFunctionTableToString(object parameter)
{
string sp = GetSp("ConvertFunction");
return(CommonExcute <string> .GeneralValue(sp, parameter));
}
public static string NoticeUpdate(object parameter)
{
string SP = GetSP("NoticeUpdate");
return(CommonExcute <string> .GeneralValue(SP, parameter));
}
public static string SaveRanking(object parameter)
{
string SP = GetSP("SaveRanking");
return(CommonExcute <string> .GeneralValue(SP, parameter));
}
public static string UnSelected(object parameter)
{
string SP = GetSP("UnSelected");
return(CommonExcute <string> .GeneralValue(SP, parameter));
}
public static string ApplicantOTType(object parameter)
{
string SP = GetSP("OTType");
return(CommonExcute <string> .GeneralValue(SP, parameter));
}
public static string Delete(object parameter)
{
string sp = GetSp("Delete");
return(CommonExcute <string> .GeneralValue(sp, parameter));
}
public static string Confirm4th(object parameter)
{
string SP = GetSP("Confirm4th");
return(CommonExcute <string> .GeneralValue(SP, parameter));
}
public static string RePosting(object parameter)
{
string sp = GetSp("RePosting");
return(CommonExcute <string> .GeneralValue(sp, parameter));
}
public static string Revoke(object parameter)
{
string SP = GetSP("Revoke");
return(CommonExcute <string> .GeneralValue(SP, parameter));
}