// get sigal position by ID
public static List <PositionPosting> PositionByID(ParameterCL parameter)
{
try
{
string sp = "dbo.tcdsb_LTO_PositionDetails_PublishbyID @SchoolYear,@PositionID";
List <PositionPosting> position1 = GeneralDataAccess.GetListofTypeT <PositionPosting>(sp, parameter);
return(position1);
}
catch (System.Exception ex)
{
string em = ex.Message;
return(null);
}
}
public static string GetMultipleSchoolEmail(string schoolYear, string schoolCode, int positionID)
{
try
{
String sp = "dbo.tcdsb_LTO_PositionNoticeToPrincipal_multipSchool @SchoolYear,@SchoolCode,@PositionID";
ParameterCL parameter = new ParameterCL {
SchoolYear = schoolYear, SchoolCode = schoolCode, PositionID = positionID
};
string result = GeneralDataAccess.TextValue(sp, parameter);
return(result);
}
catch (Exception ex)
{
var exm = ex.Message;
return("");
}
}
public static string UserProfileByID(string type, string userID)
{
try
{
string sp = "dbo.tcdsb_LTO_GetUserProfilebyUserID @UserID,@Type";
ParameterCL parameter = new ParameterCL {
UserID = userID, Type = type
};
string result = GeneralDataAccess.TextValue(sp, parameter);
return(result);
}
catch (Exception ex)
{
var exm = ex.Message;
return("");
}
}
public IList <PositionPosting> GetPosition(int positionID)
{
try
{
string sp = "dbo.tcdsb_LTO_PositionDetails_PublishbyID @SchoolYear, @PositionID";
var parameter = new ParameterCL()
{
PositionID = positionID, SchoolYear = ""
};
List <PositionPosting> position1 = GeneralDataAccess.GetListofTypeT <PositionPosting>(sp, parameter);
return(position1);
}
catch (System.Exception ex)
{
string em = ex.Message;
return(null);
}
}
public IList <PositionApprove> GetPosition(int requestID)
{
try
{
string sp = "dbo.tcdsb_LTO_PositionDetails_RequestbyID @SchoolYear, @PositionID";
var parameter = new ParameterCL()
{
PositionID = requestID, SchoolYear = ""
};
// List<PositionApprove> position1 = CommonExcute<PositionApprove>.GeneralList(sp, parameter);
List <PositionApprove> position1 = GeneralDataAccess.GetListofTypeT <PositionApprove>(sp, parameter);
return(position1);
}
catch (System.Exception ex)
{
string em = ex.Message;
return(null);
}
}
