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