private static List <Staff> StaffList(Staff parameter) { string sp = "dbo.tcdsb_LTO_RosterTCDSBSeachbyNameAndCPNum @SearchBy,@SearchValue"; List <Staff> staffs = GeneralDataAccess.GetListofTypeT <Staff>(sp, parameter); return(staffs); }
public static void SetLists2(System.Web.UI.WebControls.ListControl myListControl, System.Web.UI.WebControls.ListControl myListControl2, object parameter) { string sp = "dbo.tcdsb_LTO_ListSchoolsNew @Operate, @Para0, @Para1, @Para2, @Para3"; List <List2Item> myListData = GeneralDataAccess.GetListofTypeT <List2Item>(sp, parameter); AssemblingSchoolList(myListControl, myListControl2, myListData); }
public static void SetLists(System.Web.UI.WebControls.ListControl myListControl, ParameterSP parameter) { string sp = "dbo.tcdsb_PLF_ListDDL2New @Operate,@UserID,@UserRole,@SchoolYear"; List <List2Item> myList = GeneralDataAccess.GetListofTypeT <List2Item>(sp, parameter); AssemblingMyList(myListControl, myList); }
public static void AssembleProfilePage(Page myPage, string operate, string userID, string CPNum) { try { Staff parameter = new Staff { Operate = operate, UserID = userID, CPNum = CPNum }; string sp = "dbo.tcdsb_LTO_RosterLTOProfileAction @Operate,@UserID,@CPNum"; var profile = new List <Staff>(); profile = GeneralDataAccess.GetListofTypeT <Staff>(sp, parameter); Label newLable = (Label)myPage.FindControl("LabelSchoolName"); newLable.Text = profile[0].SchoolName; newLable = (Label)myPage.FindControl("LabelTeacherName"); newLable.Text = profile[0].TeacherName; newLable = (Label)myPage.FindControl("LabelCPNum"); newLable.Text = profile[0].CPNum; newLable = (Label)myPage.FindControl("LabelHireDate"); newLable.Text = profile[0].DateOfHire; newLable = (Label)myPage.FindControl("LabelCurrentStatus"); newLable.Text = profile[0].OTType; TextBox newtextbox = (TextBox)myPage.FindControl("LabelOCTQualification"); newtextbox.Text = profile[0].Qualification; } catch (Exception ex) { var exm = ex.Message; throw new Exception(); } }
private static List <List2Item> GetListData(object parameter) { string sp = "dbo.tcdsb_LTO_ListDDLNew @Operate,@Para0,@Para1,@Para2,@Para3"; var myListData = GeneralDataAccess.GetListofTypeT <List2Item>(sp, parameter); // var myListData = GeneralExe.DDList(parameter); // GeneralDataAccess.GetListofTypeT<List2Item>(sp, parameter); return(myListData); }
public static void SetLists2(System.Web.UI.WebControls.DropDownList myListControl, System.Web.UI.WebControls.DropDownList myListControl2, ParameterSP parameter) { string sp = "dbo.tcdsb_PLF_ListSchoolsNew @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode"; List <List2Item> myList = GeneralDataAccess.GetListofTypeT <List2Item>(sp, parameter); AssemblingMyList(myListControl, myList, "myValue", "myValue"); // school Code DDL AssemblingMyList(myListControl2, myList, "myValue", "myText"); // School Name DDL }
public static void SetLists3(System.Web.UI.WebControls.ListControl myListControl1, System.Web.UI.WebControls.ListControl myListControl2, System.Web.UI.WebControls.ListControl myListControl3, object parameter) { string sp = "dbo.tcdsb_LTO_ListSchoolPrincipalsNew @Operate, @Para0, @Para1, @Para2, @Para3"; List <List2Item> myList = GeneralDataAccess.GetListofTypeT <List2Item>(sp, parameter); AssemblingMyList(myListControl1, myList, "myValue", "myText"); // school Code DDL AssemblingMyList(myListControl2, myList, "myValue", "myText"); // school Code DDL AssemblingMyList(myListControl3, myList, "myValue", "myText"); // school Code DDL }
public static void SetSearchList(System.Web.UI.WebControls.ListControl myListControl, string operate, string para0, string para1) { List2Item parameter = new List2Item { Operate = operate, Para0 = para0, Para1 = para1 }; string sp = "dbo.tcdsb_LTO_ListDDL_SearchList @Operate,@Para0,@Para1"; List <List2Item> myListData = GeneralDataAccess.GetListofTypeT <List2Item>(sp, parameter); // myListData = GeneralExe.SearchList(parameter); AssemblingMyList(myListControl, myListData); }
public static List <ApplicantNotice> ApplicantsNoticebyID(ApplicantNotice parameter) { try { string sp = "dbo.tcdsb_LTO_PagePublish_NoticeToTeacherList @UserID, @SchoolYear,@PositionID,@Action"; List <ApplicantNotice> noticelist = GeneralDataAccess.GetListofTypeT <ApplicantNotice>(sp, parameter); return(noticelist); } catch (System.Exception ex) { string em = ex.Message; return(null); } }
public static void StaffsGridView(ref GridView myGridView, Staff parameter, string Scope) { try { string sp = "dbo.tcdsb_LTO_RosterTCDSBSeachbyNameAndCPNum @SearchBy,@SearchValue"; List <Staff> staffs = GeneralDataAccess.GetListofTypeT <Staff>(sp, parameter); myGridView.DataSource = staffs; myGridView.DataBind(); } catch (System.Exception ex) { string em = ex.Message; } }
// get Default position Date public static List <LimitDate> LimitedDate(object parameter) { try { string sp = "dbo.tcdsb_LTO_PositionDetails_DefaultDate @Operate, @AppType, @SchoolYear"; List <LimitDate> limitedate = GeneralDataAccess.GetListofTypeT <LimitDate>(sp, parameter); return(limitedate); } catch (System.Exception ex) { string em = ex.Message; return(null); } }
public IList <PositionApprove> Position(ParametersForPosition parameter) { try { string sp = "dbo.tcdsb_LTO_PageApprove_Position @SchoolYear, @PositionID"; var position1 = GeneralDataAccess.GetListofTypeT <PositionApprove>(sp, parameter); return(position1); } catch (System.Exception ex) { string em = ex.Message; return(null); } }
// 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 IList <TeacherListForPrincipalInterview> GetList(ParametersForPosition parameter) { try { string sp = "dbo.tcdsb_LTO_TeacherList_InterviewCandidate @SchoolYear,@PositionID"; var list = GeneralDataAccess.GetListofTypeT <TeacherListForPrincipalInterview>(sp, parameter); return(list); } catch (Exception ex) { var exm = ex.Message; return(null); } }
public List <QualificationSelected> rList(ParametersForPosition parameter) { try { //4th round @searchBy = PostingCycle, SearchValue1 = 4 string sp = "dbo.tcdsb_LTO_QualificationSelectedList @SchoolYear,@PositionID"; var list = GeneralDataAccess.GetListofTypeT <QualificationSelected>(sp, parameter); return(list); } catch (Exception ex) { var exm = ex.Message; return(null); } }
public List <T> ListDefaultDate(LimitDate parameter) { try { var objName = (typeof(T)).Name; string sp = GetSP(objName); //string sp = SPNameAndParameters.GetSingleList<T>();//getPositionsSP(className); var list = GeneralDataAccess.GetListofTypeT <T>(sp, parameter); return(list); } catch (Exception ex) { var exm = ex.Message; return(null); } }
public List <PositionApprove> rPosition(ParametersForPosition parameter) { try { //4th round @searchBy = PostingCycle, SearchValue1 = 4 tcdsb_LTO_PositionList_RequestPostingWithSearch string sp = "dbo.tcdsb_LTO_PositionList_ApprovingRequest @Operate,@UserID,@SchoolYear,@PositionType,@Panel,@Status,@SearchBy, @SearchValue1, @SearchValue2"; var list = GeneralDataAccess.GetListofTypeT <PositionApprove>(sp, parameter); return(list); } catch (Exception ex) { var exm = ex.Message; return(null); } }
public IList <PositionListInterview> GetList(ParametersForPositionList parameter) { try { //4th round @searchBy = PostingCycle, SearchValue1 = 4 string sp = "dbo.tcdsb_LTO_PositionList_Interview @Operate,@UserID,@SchoolYear,@PositionType,@Panel,@Status,@SearchBy, @SearchValue1, @SearchValue2"; var list = GeneralDataAccess.GetListofTypeT <PositionListInterview>(sp, parameter); return(list); } catch (Exception ex) { var exm = ex.Message; return(null); } }
public IList <MultipleSchoolEmail> MultipleSchoolPrinciapls(ParametersForPosition parameter) { try { //4th round @searchBy = PostingCycle, SearchValue1 = 4 tcdsb_LTO_PositionList_RequestPostingWithSearch string sp = "dbo.tcdsb_LTO_PageApprove_MultipleSchoolPrincipal @SchoolYear, @PositionID"; var list = GeneralDataAccess.GetListofTypeT <MultipleSchoolEmail>(sp, parameter); return(list); } catch (Exception ex) { var exm = ex.Message; return(null); } }
public IList <PositionPosting> GetPosition(ParametersForPosition parameter) { 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(ParametersForPosition parameter) { try { string sp = "dbo.tcdsb_LTO_PositionDetails_RequestbyID @SchoolYear, @PositionID"; // var parameter = new ParameterCL() { PositionID = positionID, 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); } }
public static List <FormContent> ListofContent(string schoolYear, string schoolCode) { try { string sp = "dbo.tcdsb_PLF_FormData_WebAPI @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode"; ParameterSP0 parameter = new ParameterSP0 { Operate = "Content", UserID = "mif", SchoolYear = schoolYear, SchoolCode = schoolCode }; List <FormContent> myList = GeneralDataAccess.GetListofTypeT <FormContent>(sp, parameter); return(myList); } catch (Exception ex) { var exm = ex.Message; return(null); } }
public IList <PositionInterview> GetPosition(int positionID) { try { string sp = "dbo.tcdsb_LTO_PositionDetails_RequestbyID @SchoolYear, @PositionID"; var parameter = new ParameterCL() { PositionID = positionID, SchoolYear = "" }; List <PositionInterview> position1 = GeneralDataAccess.GetListofTypeT <PositionInterview>(sp, parameter); return(position1); } catch (System.Exception ex) { string em = ex.Message; return(null); } }
public static void AssembleDetails(Page myPage, PositionBase parameter) { try { string sp = "dbo.tcdsb_LTO_PositionDetails_PublishbyID @SchoolYear,@PositionID"; List <PositionPosting> position = GeneralDataAccess.GetListofTypeT <PositionPosting>(sp, parameter); //IPositionRepository<PositionPosting, string> repository = Factory.Get<PositionPosting>(); // IList<Employee2> gridData = repository.GetListItems(WorkingProfile.UserRole, userID, schoolyear, schoolcode, searchby, searchvalue); //Label newLable = (Label)myPage.FindControl("LabelSchoolName"); //newLable.Text = position[0].SchoolName; //newLable = (Label)myPage.FindControl("LabelTeacherName"); //newLable.Text = position[0].TeacherName; //newLable = (Label)myPage.FindControl("LabelCPNum"); //newLable.Text = position[0].CPNum; //newLable = (Label)myPage.FindControl("LabelHireDate"); //newLable.Text = position[0].DateOfHire; //newLable = (Label)myPage.FindControl("LabelCurrentStatus"); //newLable.Text = position[0].OTType; //TextBox newtextbox = (TextBox)myPage.FindControl("LabelOCTQualification"); //newtextbox.Text = position[0].Qualification; //foreach (Staff myitem in profile) //{ // Label newLable = (Label)myPage.FindControl("LabelSchoolName"); // newLable.Text = myitem.SchoolName; // HtmlTextArea newArea = (HtmlTextArea)myPage.FindControl("Text" + code); // newArea.Value = myitem.Notes; //} } catch (Exception ex) { var exm = ex.Message; throw new Exception(); } }
public static void BindGridView(ref GridView myGridView, string listPage, string method, string userID, string schoolYear, string schoolCode) { try { if (listPage == "SchoolHistory") { string sp = "dbo.tcdsb_PLF_SchoolHistoryNew @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode"; ParameterSP parameter = new ParameterSP { Operate = method, UserID = userID, SchoolYear = schoolYear, SchoolCode = schoolCode }; List <School> schools = GeneralDataAccess.GetListofTypeT <School>(sp, parameter); //schools = PublishListDA.GetSchoolHistroy("Get", "", userID, schoolyear, schoolcode); myGridView.DataSource = schools; myGridView.DataBind(); } } catch (System.Exception ex) { string em = ex.Message; } }
public static void BindGridView(ref GridView myGridView, string listPage, string method, string userID, string schoolYear, string schoolCode, string schoolArea) { try { if (listPage == "SchoolListbyArea") { string sp = "dbo.tcdsb_PLF_AreaSchoolList @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode,@SchoolArea"; ParameterSP2 parameter = new ParameterSP2 { Operate = "", UserID = userID, SchoolYear = schoolYear, SchoolCode = schoolCode, SchoolArea = schoolArea }; List <School> schools = GeneralDataAccess.GetListofTypeT <School>(sp, parameter); // List<School> schools = PublishList.GetAreaSchools("Get", "Role", userID, schoolyear, schoolcode, schoolArea); ; myGridView.DataSource = schools; myGridView.DataBind(); } } catch (System.Exception ex) { string em = ex.Message; } }
public static void BindGridView(ref GridView myGridView, string listPage, string method, string userID, string schoolYear, string schoolCode) { try { if (listPage == "SchoolHistory") { string sp = "dbo.tcdsb_PLF_SchoolHistoryNew @SchoolYear,@SchoolCode"; School parameter = new School { SchoolYear = schoolYear, SchoolCode = schoolCode }; // List<School> schools = GeneralDataAccess.GetSchoolList(sp, parameter); List <School> schools = GeneralDataAccess.GetListofTypeT <School>(sp, parameter); myGridView.DataSource = schools; myGridView.DataBind(); } } catch (System.Exception ex) { string em = ex.Message; } }
public static void BindGridView(ref GridView myGridView, string GridType, School parameter) { try { string sp = ""; if (GridType == "SchoolHistory") { sp = "dbo.tcdsb_PLF_SchoolHistoryNew @SchoolYear,@SchoolCode"; } if (GridType == "SchoolListbyArea") { sp = "dbo.tcdsb_PLF_AreaSchoolListNew @SchoolYear,@SchoolCode,@SchoolArea"; } // School parameter = new School { SchoolYear = schoolYear, SchoolCode = schoolCode, SchoolArea = schoolArea }; List <School> schools = GeneralDataAccess.GetListofTypeT <School>(sp, parameter); myGridView.DataSource = schools; myGridView.DataBind(); } catch (System.Exception ex) { string em = ex.Message; } }