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)); }