Example #1
0
        public void ApprovePositionTest_Return_oneList_of_thePositionID()
        {   //Arrange
            // create new request
            int newid = getNewRequestID("LTO");
            // update the request and principal request down.
            var position = new PositionRequesting()
            {
                Operate    = "Request Posting",
                UserID     = "mif",
                SchoolYear = schoolyear,
                PositionID = newid
            };

            RequestingPostExe.PostRequest(position, "0");

            //Act

            var parameter = new ParametersForPosition()
            {
                SchoolYear = schoolyear,
                PositionID = newid.ToString(),
            };
            int expect = newid;

            //Act
            var list        = CommonListExecute.ApprovePosition(parameter);
            int resultCount = list.Count;
            int result      = list[0].PositionID;

            //Assert
            Assert.AreEqual(expect, result, $"  approve request position by id  { result}");
            Assert.IsTrue(resultCount >= 0, $"  approve request posting List is { resultCount}");
        }
Example #2
0
        public void SaveRequestTest()
        {  //Arrange
            int newid     = getNewRequestID("LTO");
            var parameter = new PositionRequesting()
            {
                Operate          = "Update",
                UserID           = "mif",
                SchoolYear       = schoolyear,
                SchoolCode       = "0320",
                PositionID       = newid,
                Comments         = "Posting reques,t comment ",
                PositionType     = "LTO",
                PositionTitle    = "Title of posting",
                PositionLevel    = "BC708E",
                Qualification    = "",
                Description      = "Description",
                FTE              = 67,
                FTEPanel         = "AM",
                StartDate        = "2019/03/10",
                EndDate          = "2019/06/25 ",
                ReplaceTeacher   = "New Teacher",
                ReplaceTeacherID = "00031675",
                ReplaceReason    = "Pregnancy/Parental",
                Owner            = "frijiom"
            };
            string expect = "Successfully";
            //Act
            var result = RequestingPostExe.SaveRequest(parameter, "0");

            //Assert
            Assert.AreEqual(expect, result, $"  Request position by ID { result} ");
        }
Example #3
0
        //public string CreateRequest(object position, int positionID)
        //{
        //    try
        //    {
        //        string sp = "dbo.tcdsb_LTO_PageRequest_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 string PostRequest(object position, int positionID)
        //{
        //    try
        //    {
        //        string sp = "dbo.tcdsb_LTO_PageRequest_Operation @Operate,  @SchoolYear,  @PositionID";
        //        var result = GeneralDataAccess.TextValue(sp, position);
        //        return result;
        //    }
        //    catch (Exception ex)
        //    {
        //        var exm = ex.Message;
        //        return "Failed";
        //    }
        //}
        //public string DeleteRequest(object position, int positionID)
        //{
        //    try
        //    {
        //        string sp = "dbo.tcdsb_LTO_PageRequest_Operation @Operate,  @SchoolYear, @PositionID";
        //        var result = GeneralDataAccess.TextValue(sp, position);
        //        return result;
        //    }
        //    catch (Exception ex)
        //    {
        //        var exm = ex.Message;
        //        return "Failed";
        //    }
        //}

        //public string UpdateRequest(object position, int positionID)
        //{
        //    try
        //    {    //  @Operate ="RePosting"
        //        string sp = "dbo.tcdsb_LTO_PageRequest_Operation @Operate, @SchoolYear,  @PositionID, @PositionType,@UserID, @SchoolCode, @StartDate, @EndDate, @Comments, @PositionLevel, @PositionTitle, @Description, @Qualification, @QualificationCode, @FTE, @FTEPanel, @ReplaceTeacherID, @ReplaceReason, @OtherReason, @Owner";
        //        var result = GeneralDataAccess.TextValue(sp, position);
        //        return result;
        //    }
        //    catch (Exception ex)
        //    {
        //        var exm = ex.Message;
        //        return "Failed";
        //    }
        //}
        //public string UpdateQualification(object qual, int positionID)
        //{
        //    try
        //    {    //  @Operate ="RePosting"
        //        string sp = "dbo.tcdsb_LTO_PageRequest_Qualification_Update @Operate,@UserID, @SchoolYear,@SchoolCode, @PositionID, @SourceID, @QualificationID, @Selected";
        //        var result = GeneralDataAccess.TextValue(sp, qual);
        //        return result;
        //    }
        //    catch (Exception ex)
        //    {
        //        var exm = ex.Message;
        //        return "Failed";
        //    }
        //}
        //public string RequestAttribute(object qual, int positionID)
        //{
        //    try
        //    {    //  @Operate ="RePosting"
        //        string sp = "dbo.tcdsb_LTO_PageRequest_Attribute @Operate,@UserID, @SchoolYear,@SchoolCode, @PositionID";
        //        var result = GeneralDataAccess.TextValue(sp, qual);
        //        return result;
        //    }
        //    catch (Exception ex)
        //    {
        //        var exm = ex.Message;
        //        return "Failed";
        //    }
        //}
        public string RequestingOperation(PositionRequesting 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");
            }
        }
Example #4
0
        public void PositionTest_RequestPostingbyRequestID()
        {    //Arrange
            int newid = getNewRequestID("LTO");

            ParametersForPosition parameters = CommonParameter.GetParameters("20182019", newid.ToString());

            int expect = newid;

            //Act
            PositionRequesting position = RequestingPostExe.Position(parameters)[0];

            int result = position.PositionID;

            //Assert
            Assert.AreEqual(expect, result, $"  Request position by ID { result} ");
        }
Example #5
0
        private int getNewRequestID(string positionType)
        {
            var parameter = new PositionRequesting()
            {
                Operate      = "New",
                SchoolYear   = schoolyear,
                PositionID   = 0,
                PositionType = positionType,
                SchoolCode   = "0320",
                UserID       = "mif"
            };
            string newid = RequestingPostExe.NewRequest(parameter, "0");
            int    x     = Int32.Parse(newid);

            return(x);
        }
Example #6
0
        public void DeleteRequestTest()
        {     //Arrange
            int newid    = getNewRequestID("LTO");
            var position = new PositionRequesting()
            {
                Operate    = "Delete",
                UserID     = "mif",
                SchoolYear = schoolyear,
                PositionID = newid
            };
            string expect = "Successfully";
            //Act
            var result = RequestingPostExe.DeleteRequest(position, "0");

            //Assert
            Assert.AreEqual(expect, result, $" Create New Request position   { result} ");
        }
Example #7
0
        public void NewRequestTest()
        {
            //Arrange
            var position = new PositionRequesting()
            {
                Operate      = "Request",
                UserID       = "mif",
                SchoolYear   = schoolyear,
                SchoolCode   = "0320",
                PositionID   = 0,
                PositionType = "LTO",
            };
            int expect = 1633;
            //Act
            var result = RequestingPostExe.NewRequest(position, "0");

            //Assert
            Assert.IsNotNull(result, $" Create New Request position   { result} ");
        }
Example #8
0
        public void UpdateTest_create_a_NewRequest_and_Update_RequestInformation_return_Successfully()
        {
            //Arrange
            string action  = "Update";
            var    request = new PositionRequesting()
            {
                Operate           = "Update",
                UserID            = "mif",
                SchoolYear        = "20192020",
                SchoolCode        = "0549",
                PositionID        = getNewRequestID("LTO"),
                Comments          = "Test request posting Update function by new",
                PositionType      = "LTO",
                PositionTitle     = "English Grade 10 Teacher",
                PositionLevel     = "BC003E",
                Qualification     = "Biology; Science; Science - General; ",
                QualificationCode = "317; 401; 405; ",
                Description       = "Biology; Science; Science - General; full time position need senior levelUpdate process from interface class",
                FTE              = 1.00M,
                FTEPanel         = "Full",
                StartDate        = DateFC.YMD2("2019/09/01"),
                EndDate          = DateFC.YMD2("2020/06/30"),
                ReplaceTeacher   = "replace teachername",
                ReplaceTeacherID = "00019103",
                ReplaceReason    = "6",
                OtherReason      = "Medical Leave",
                Owner            = "frijiom"
            };

            //Act


            //Act
            //  IPostingPosition<string> testPosition = new PostingRequest<string>();

            var    testPosition = new Posting(new PostingRequest());
            string result       = testPosition.Update(request); //string result = RequestPostingExe.Update(parameter);
            string expect       = "Successfully";

            //Assert
            Assert.AreEqual(expect, result, $"  Request Posting Resulte { result}.");
        }
Example #9
0
        public void CommonExcuteTest_RequestPosting_Update_Return_Successfully()
        {
            //Arrange
            int    ids       = getNewRequestID("LTO");
            string action    = "Update";
            var    parameter = new PositionRequesting()
            {
                Operate           = "Update",
                UserID            = "mif",
                SchoolYear        = "20182018",
                SchoolCode        = "0549",
                PositionID        = ids,
                PositionType      = "LTO",
                PositionTitle     = "Position Title for Test ",
                PositionLevel     = "BC012E",
                Qualification     = "",
                QualificationCode = "",
                Description       = "Posiition descriptiion for test",
                FTE              = 0.50M,
                FTEPanel         = "AM",
                StartDate        = "2018/09/03",
                EndDate          = "2019/06/30",
                DatePublish      = "2018/06/18",
                DateApplyOpen    = "2018/06/25",
                DateApplyClose   = "2018/06/27",
                Comments         = "Test posting comments",
                ReplaceTeacherID = "",
                ReplaceTeacher   = "",
                ReplaceReason    = "",
                OtherReason      = "",
                Owner            = "mif"
            };
            string expect = "Successfully";

            //Act

            string SP     = CommonExcute.SPNameAndParameters(SPFile, cPage, action);
            string result = CommonExcute <PositionRequesting> .GeneralValue(SP, parameter);

            //Assert
            Assert.AreEqual(expect, result, $"  Update Posting position Content { result}");
        }
Example #10
0
        private string Step2_GetRequestPosition()
        {
            // 2. Get this new Request
            //Arrange
            var parameterForRequest = new
            {
                SchoolYear = _schoolYear,
                PositionID = _requestId.ToString()
            };

            //Act
            List <PositionRequesting> request1 = RequestPostingExe.Position(parameterForRequest);

            _request = request1[0];

            //Assert
            Assert.IsNotNull(_request, $" Get Request Position ");

            return("Successfully");
        }
Example #11
0
        private int getNewRequestID(string positionType)
        {  //Arrange
            PositionRequesting request = new PositionRequesting()
            {
                Operate      = "New",
                SchoolYear   = "20192020",
                PositionID   = 0,
                PositionType = positionType,
                SchoolCode   = "0549",
                UserID       = "mif"
            };
            string action = "New";

            string SP    = CommonExcute.SPNameAndParameters(SPFile, "Request", action);
            string newid = CommonExcute <PositionRequesting> .GeneralValue(SP, request);

            int x = Int32.Parse(newid);

            return(x);
        }
Example #12
0
        private string Step3_UpdateRequestPosiiton()
        {
            //Arrange
            PositionRequesting updatePosition = new PositionRequesting()
            {
                Operate           = "Update",
                UserID            = "mif",
                SchoolYear        = _schoolYear,
                SchoolCode        = _schoolCode,
                PositionID        = _requestId,
                Comments          = "Test request posting Update function by new",
                PositionType      = "LTO",
                PositionTitle     = "English Grade 10 Teacher",
                PositionLevel     = "BC003E",
                Qualification     = "Biology; Science; Science - General; ",
                QualificationCode = "317; 401; 405; ",
                Description       = "Biology; Science; Science - General; full time position need senior level",
                FTE              = 1.00M,
                FTEPanel         = "Full",
                StartDate        = DateFC.YMD2(_dateStart),
                EndDate          = DateFC.YMD2(_dateEnd),
                ReplaceTeacher   = "replace teachername",
                ReplaceTeacherID = "00019103",
                ReplaceReason    = "6",
                OtherReason      = "Medical Leave",
                Owner            = "frijiom",
                PrincipalID      = _principalId
            };

            //Act
            string result = RequestPostingExe.Update(updatePosition);
            string expect = "Successfully";

            //Assert
            Assert.AreEqual(expect, result, $" Update and save postion request action was:  { result}");

            return("Successfully");
        }
Example #13
0
        public static string RequestPositionAttribute(PositionRequesting operation, string positonID)
        {
            var myval = new RequestingPost();

            return(myval.RequestingOperation(operation, positonID));
        }
Example #14
0
        public static string NewRequest(PositionRequesting position, string positonID)
        {
            var myval = new RequestingPost();

            return(myval.RequestingOperation(position, positonID));
        }
Example #15
0
 public static string RequestOperation(PositionRequesting operation, string action)
 {
     //  return CommonOperationExcute<PositionRequesting>.CommonOperation(operation, action);
     return(Operation(operation, action));
 }