public static string TeamMemberSelect(string operate, string userID, string schoolYear, string schoolCode, string actionType, string employeeID, string selected, string comment) { string sp1 = sp + ",@ActionType,@TeacherID,@Checked,@Comments"; ParameterSP3 parameter = new ParameterSP3 { Operate = operate, UserID = userID, SchoolYear = schoolYear, SchoolCode = schoolCode, ActionType = actionType, TeacherID = employeeID, Checked = selected, Comments = comment }; return(GeneralDataAccess.TextValue(sp1, parameter)); // return PLFSiteTeam.Selected(operate, userID, schoolCode, schoolYear, actionType, employeeID, selected, comment); }
public static string Signature2(string operate, string userID, string schoolYear, string schoolCode, string actionType) { Signature parameter = new Signature { Operate = operate, UserID = userID, SchoolYear = schoolYear, SchoolCode = schoolCode, ActionType = actionType }; return(GeneralDataAccess.TextValue(sp, parameter)); // return SignatureProcess.SignoffResult(operate, userID, userRole, schoolYear, schoolCode, actionType); }
public string GeneralValue(string SP, object parameter) { try { var result = GeneralDataAccess.TextValue(SP, parameter); return(result); } catch (Exception ex) { var exm = ex.Message; throw; } }
public static string RePosting(PositionPosting parameter) { try { string parameters = "@Operate,@UserID,@SchoolYear,@PositionID, @PostingCycle,@TakeApplicant"; string sp = "dbo.tcdsb_LTO_PositionDetails_RePosting " + parameters; string result = GeneralDataAccess.TextValue(sp, parameter); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string Operation(T position, string sp, string action) { try { var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; throw; } }
//public string UpdateResult(object position, int positionID) //{ // try // { // string sp = "dbo.tcdsb_LTO_PageInterview_Operation @Operate, @UserID, @SchoolYear, @PositionID, @CPNum, @Recommendation, @InterviewDate, @EffectiveDate, @OutCome, @Acceptance"; // var result = GeneralDataAccess.TextValue(sp, position); // return result; // } // catch (Exception ex) // { // var exm = ex.Message; // return "Failed"; // } //} //public string RecommendForHire(object position, int positionID) //{ // try // { // string sp = "dbo.tcdsb_LTO_PageInterview_Operation @Operate, @UserID, @SchoolYear, @PositionID, @CPNum, @Recommendation, @InterviewDate, @EffectiveDate, @OutCome, @Acceptance"; // var result = GeneralDataAccess.TextValue(sp, position); // return result; // } // catch (Exception ex) // { // var exm = ex.Message; // return "Failed"; // } //} //public string CheckInterviewCount(object position, int positionID) //{ // try // { // string sp = "dbo.tcdsb_LTO_PageInterview_OperationCheck @Operate, @UserID, @SchoolYear, @PositionID"; // var result = GeneralDataAccess.TextValue(sp, position); // return result; // } // catch (Exception ex) // { // var exm = ex.Message; // return "0"; // } //} //public string CheckSignOffCount(object position, int positionID) //{ // try // { // string sp = "dbo.tcdsb_LTO_PageInterview_OperationCheck @Operate, @UserID, @SchoolYear, @PositionID, @CPNum"; // var result = GeneralDataAccess.TextValue(sp, position); // return result; // } // catch (Exception ex) // { // var exm = ex.Message; // return "0"; // } //} //public string CheckHiringProcessStatus(object position, int positionID) //{ // try // { // string sp = "dbo.tcdsb_LTO_PageInterview_OperationCheck @Operate, @UserID, @SchoolYear, @PositionID"; // var result = GeneralDataAccess.TextValue(sp, position); // return result; // } // catch (Exception ex) // { // var exm = ex.Message; // return "Failed"; // } //} //public string InterviewSignOffAction(object position, int positionID) //{ // try // { // string sp = "dbo.tcdsb_LTO_PageInterview_SignOff @Operate, @UserID, @SchoolYear, @PositionID, @CPNum"; // var result = GeneralDataAccess.TextValue(sp, position); // return result; // } // catch (Exception ex) // { // var exm = ex.Message; // return "0"; // } //} public string InterviewOperation(InterviewResult position, string positonID) { try { string sp = GetSP(position.Operate); var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string DeletePosting(object position, int positionID) { try { string sp = GetSP("Delete"); // "dbo.tcdsb_LTO_PageApprove_Operation @Operate,@UserID,@SchoolYear,@SchoolCode, @PositionID,@Comments"; var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string RejectRequestPosting(object position, int positionID) { // Exec Rejection try { // Operate = "Reject" string sp = GetSP("Reject"); // "dbo.tcdsb_LTO_PageApprove_Operation @Operate,@UserID,@SchoolYear,@SchoolCode,@PositionID, @Comments,@CPNum"; var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string UpdatePosting(object position, int positionID) { try { // @Operate ="RePosting" string sp = "dbo.tcdsb_LTO_PageConfirmForHiring_Operation @Operate,@UserID,@SchoolYear,@SchoolCode,@PositionID,@Comments"; var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string ConfirmHire4thRound(object position, int positionID) { try { string sp = "dbo.tcdsb_LTO_PageConfirmForHiring4th_Operation @Operate, @UserID, @SchoolYear, @PositionType, @PositionID, @CPNum, @Comments,@Acceptance, @DateConfirm, @DateEffective, @DateEnd, @PrincipalEmail, @OfficerEmail, @Action, @PayStatus,@TeacherName"; var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public static string Content(ParameterSP0 parameter) { try { string sp = "dbo.tcdsb_PLF_FormData_WebAPI @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode,@ItemCode,@Value"; // ParameterSP0 parameter = new ParameterSP0 { Operate = "Content", SchoolYear = schoolYear, SchoolCode = schoolCode, ItemCode = itemCode, Value = value }; return(GeneralDataAccess.TextValue(sp, parameter)); } catch (Exception ex) { var exm = ex.Message; return(""); } }
public string RevokeHire(object position, int positionID) { try { string sp = "dbo.tcdsb_LTO_PageHired_Operation @Operate, @UserID, @SchoolYear, @PositionType, @PositionID, @CPNum, @Action"; var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public static string CancelPosting(PositionPosting parameter) { try { string sp = "dbo.tcdsb_LTO_PositionDetails_CancelPosting @Operate,@UserID,@SchoolYear,@PositionID, @Comments"; string result = GeneralDataAccess.TextValue(sp, parameter); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string MultiplePrinciaplEmail(ParametersForOperation parameter) { try { // @Operate ="RePosting" string sp = GetSP("MultiplePrinciapl"); // "dbo.tcdsb_LTO_PagePublish_Operation @Operate,@UserID,@SchoolYear,@SchoolCode,@PositionID"; var result = GeneralDataAccess.TextValue(sp, parameter); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string PostingApproveOperation(PositionApprove position, string action) { try { string sp = GetSP(position.Operate); var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string HiringOperation(ParametersForOperationHire position, string action) { try { string sp = GetSP(action); var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string QualificationOperation(QualificationUpdate position, string positionID) { try { string sp = GetSP(position.Operate); var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string TestCount(object position, int positionID) { try { // @Operate ="RePosting" string sp = "dbo.tcdsb_LTO_PagePublish_Operation @Operate,@UserID,@SchoolYear,@SchoolCode,@PositionID"; var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string RePosting(object position, int positionID) { try { // @Operate ="RePosting" string sp = GetSP("RePosting"); // "dbo.tcdsb_LTO_PagePublish_Operation @Operate,@UserID,@SchoolYear,@SchoolCode,@PositionID,@PositionType, @Comments,@PostingCycle,@TakeApplicant"; var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string Posting(object position, int positionID) { try { string sp = GetSP("Posting");//"dbo.tcdsb_LTO_PageApprove_Operation @Operate,@UserID,@SchoolYear,@SchoolCode,@PositionID,@Comments,@CPNum,@StartDate,@EndDate,@DatePublish,@DateApplyOpen,@DateApplyClose,@RequestSource"; var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public static string GetHelpContent(string operate, string userID, string categoryID, string areaID, string itemCode) { try { ParameterSP4 parameter = new ParameterSP4 { Operate = operate, UserID = userID, ItemCode = itemCode, CategoryID = categoryID, AreaID = areaID, ItemType = "Help" }; return(GeneralDataAccess.TextValue(sp, parameter)); } catch (Exception ex) { var em = ex.Message; return(""); } }
public static string TextContent(string operate, string userID, string userRole, string schoolYear, string schoolCode, string itemCode) { try { ParameterSP0 parameter = new ParameterSP0 { Operate = operate, UserID = userID, ItemCode = itemCode, SchoolYear = schoolYear, SchoolCode = schoolCode }; return(GeneralDataAccess.TextValue(sp, parameter)); } catch (Exception ex) { var exm = ex.Message; return(""); } }
public string QualificationUpdate(QualificationUpdate qual) { try { string paramaters = "@Operate,@UserID,@SchoolYear,@SchoolCode,@PositionID,@SourceID, @QualificationID, @Selected"; string sp = "dbo.tcdsb_LTO_Qualification_Update " + paramaters; var result = GeneralDataAccess.TextValue(sp, qual); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string DeletePosting(object position, int positionID) { try { // @Operate ="Delete" string sp = GetSP("Delete"); // "dbo.tcdsb_LTO_PagePublish_Operation @Operate,@UserID,@SchoolYear,@SchoolCode,@PositionID"; var result = GeneralDataAccess.TextValue <string>(sp, position); // var result = GeneralDataAccess.TextValue(sp, position); return(result.ToString()); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string HiringTeacherName(object position) { try { string paramaters = "@SchoolYear, @PositionID, @CPNum"; string sp = "dbo.tcdsb_LTO_checkTeacherNamebyCPNum " + paramaters; var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string Operation(T position, string action) { try { string tName = typeof(T).Name; string sp = GetSPNameAndParametersbyType(tName, action); var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public string CreatePosting(object position, int positionID) { try { //Operate ="Save" // StaffProfile parameter = new StaffProfile { Operate = operate, UserID = userID, CPNum = CPNum, Action = action }; string sp = GetSP("CreateNew"); // "dbo.tcdsb_LTO_PagePublish_CreateNewAndGetRequestID @Operate, @SchoolYear, @PositionID, @PositionType,@UserID, @SchoolCode"; var result = GeneralDataAccess.TextValue(sp, position); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public static string GetHelpContent(string operate, string userID, string categoryID, string areaID, string itemCode) { try { List2Item parameter = new List2Item { Operate = operate }; return(GeneralDataAccess.TextValue(sp, parameter)); } catch (Exception ex) { var em = ex.Message; return(""); } }
public static string SaveEmailNotice(EmailNotice2 mailItems) { try { // String sp = "dbo.tcdsb_LTO_ConfirmForHir_Log2 @UserID,@SchoolYear,@SchoolCode,@PositionType, @PositionID, @PositionTitle, @PostingNum, @NoticePrincipal, @EmailType,@EmailTo, @EmailCC, @EmailFrom, @EmailSubject, @EmailBody"; string sp = "dbo.tcdsb_LTO_EmailNotificaiton_Log @UserID,@SchoolYear,@SchoolCode,@PositionType, @PositionID, @PositionTitle, @PostingNum, @NoticePrincipal, @NoticeFor,@EmailType,@EmailTo, @EmailCC, @EmailFrom, @EmailSubject, @EmailBody"; string result = GeneralDataAccess.TextValue(sp, mailItems); return(result); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }
public static string SignatureOld(string operate, string userID, string userRole, string schoolYear, string schoolCode, string actionType, string actionDate) { try { ParameterSP1 parameter = new ParameterSP1 { Operate = operate, UserID = userID, UserRole = userRole, SchoolYear = schoolYear, SchoolCode = schoolCode, ActionType = actionType, ActionDate = actionDate }; return(GeneralDataAccess.TextValue(sp, parameter)); // return SignatureProcess.SignoffResult(operate, userID, userRole, schoolYear, schoolCode, actionType, actionDate); } catch (Exception ex) { var exm = ex.Message; return("Failed"); } }