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