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