public void UpdateTest_return_Successfully_check()
{
//Arrange
var parameter = new ParametersForPosition()
{
SchoolYear = schoolyear,
PositionID = getNewPublishID("LTO").ToString()
};
var position = PublishPositionExe.Position(parameter)[0];
position.Operate = "Update";
position.SchoolYear = schoolyear;
position.PositionTitle = "Test Grade 10 Teacher";
position.PositionLevel = "BC708E";
position.Description = " position descriptions from HR staff";
position.StartDate = "2019/09/03";
position.EndDate = "2020/06/30";
position.DatePublish = "2019/11/11";
position.DateApplyOpen = "2019/11/13";
position.DateApplyClose = "2019/11/15";
string expect = "Successfully";
//Act
string result = PublishPositionExe.Update(position);
//Assert
Assert.AreEqual(expect, result, $" Postion update is { result} ");
}
public void PositionsTest_Return_All_published_Postion_List()
{
//Arrange
var myGridview = new System.Web.UI.WebControls.GridView();
var parameter = new ParametersForPositionList()
{
Operate = "Page",
UserID = "mif",
SchoolYear = schoolyear,
PositionType = "LTO",
Panel = "All",
Status = "Open",
SearchBy = "All",
SearchValue1 = "",
SearchValue2 = ""
};
string expect = "334";
//Act
List <PositionListPublish> publishList = PublishPositionExe.Positions(parameter);
myGridview.AutoGenerateColumns = true;
myGridview.DataSource = publishList;
myGridview.DataBind();
var result = myGridview.Rows.Count.ToString();
//Assert
Assert.IsNotNull(result, $" Publish positions count is { result } ");
}
public string DeleteTest(object parameter)
{
string result = PublishPositionExe.Delete(parameter);
return(result);
// TODO: add assertions to method PublishPositionExeTest.DeleteTest(Object)
}
public List <PositionPublish> DefaultDateTest(object parameter)
{
List <PositionPublish> result = PublishPositionExe.DefaultDate(parameter);
return(result);
// TODO: add assertions to method PublishPositionExeTest.DefaultDateTest(Object)
}
public string SPNameTest(string action)
{
string result = PublishPositionExe.SpName(action);
return(result);
// TODO: add assertions to method PublishPositionExeTest.SPNameTest(String)
}
public string PrincipalsEmailTest(object parameter)
{
string result = PublishPositionExe.PrincipalsEmail(parameter);
return(result);
// TODO: add assertions to method PublishPositionExeTest.PrincipalsEmailTest(Object)
}
public List <PositionListPublish> PositionsTest(object parameter)
{
List <PositionListPublish> result = PublishPositionExe.Positions(parameter);
return(result);
// TODO: add assertions to method PublishPositionExeTest.PositionsTest(Object)
}
public void DefaultDateTest()
{
//Arrange
string action = "DefaultDate";
SearchParameter parameter = new SearchParameter()
{
Operate = action,
SchoolYear = "20192020",
PositionType = "LTO"
};
// Act
List <PositionPublish> myDate = PublishPositionExe.DefaultDate(parameter);
//myGridview.AutoGenerateColumns = true;
//myGridview.DataSource = myDatasource;
//myGridview.DataBind();
var startDate = myDate[0].StartDate;
var endDate = myDate[0].EndDate;
var publishDate = myDate[0].DatePublish;
var openDate = myDate[0].DateApplyOpen;
var closeDate = myDate[0].DateApplyClose;
string expect = DateFC.YMD(DateTime.Now);
string result = publishDate;
//Assert
Assert.AreEqual(expect, result, $"default publish Date Value { result}");
}
public void PositionInfoTest()
{
//Arrange
var parameter = new ParametersForPosition()
{
SchoolYear = schoolyear,
PositionID = getNewPublishID("LTO").ToString()
};
var position = PublishPositionExe.Position(parameter)[0];
position.Operate = "Update";
position.SchoolYear = schoolyear;
position.PositionTitle = "Test Grade 10 Teacher";
position.PositionLevel = "BC708E";
position.Description = " position descriptions from HR staff";
position.StartDate = "2019/09/03";
position.EndDate = "2020/06/30";
position.DatePublish = "2019/11/11";
position.DateApplyOpen = "2019/11/13";
position.DateApplyClose = "2019/11/15";
//Act
string updateresult = PublishPositionExe.Update(position);
List <PositionInfo> positionInfo = PublishPositionExe.PositionInfo(parameter);
string expect = position.PositionTitle + "(" + parameter.PositionID + ")";
string expect2 = position.StartDate;
string result = positionInfo[0].PositionTitle;
string result2 = positionInfo[0].StartDate;
//Assert
Assert.AreEqual(expect, result, $" Position { parameter.PositionID } title is { result} ");
Assert.AreEqual(expect2, result2, $" Position { parameter.PositionID } Apply open Date is { result2} ");
}
public void PositionTest_return_publishPosition_by_giving_PositionID()
{
//Arrange
var myGridview = new System.Web.UI.WebControls.GridView();
var parameter = new ParametersForPosition()
{
SchoolYear = schoolyear,
PositionID = getNewPublishID("LTO").ToString()
};
string expect = parameter.PositionID;
//Act
List <PositionPublish> publishList = PublishPositionExe.Position(parameter);
myGridview.AutoGenerateColumns = true;
myGridview.DataSource = publishList;
myGridview.DataBind();
myGridview.SelectedIndex = 0;
GridViewRow row = myGridview.SelectedRow;
string result = row.Cells[14].Text; // PositionID in Gridview Cell position
var result2 = publishList[0].PositionID;
//Assert
Assert.AreEqual(expect, result, $" Publish positions ID is { result } ");
}
public void UpdateTest_createNewPublish_and_Update_Position_Return_Successfully()
{
//Arrange
var parameter = new ParametersForPosition()
{
SchoolYear = "20192020",
PositionID = getNewPublishID("LTO").ToString()
};
var position = PublishPositionExe.Position(parameter)[0];
position.Operate = "Update";
position.SchoolYear = "20192020";
position.PositionTitle = "Test Grade 10 Teacher";
position.PositionLevel = "BC708E";
position.Description = " position descriptions from HR staff using interface method";
position.StartDate = "2019/09/03";
position.EndDate = "2020/06/30";
position.DatePublish = "2019/12/11";
position.DateApplyOpen = "2019/12/13";
position.DateApplyClose = "2019/12/15";
string expect = "Successfully";
//Act
var testPosition = new Posting(new PostingPublish());
// IPostingPosition<string> testPosition = new PostingPublish<string>();
// var testList = testPosition.Update(parameter) .Position(parameter);// RequestPostingExe.Positions(parameter);
string result = testPosition.Update(position);
//Assert
Assert.AreEqual(expect, result, $" Postion update is { result} ");
}
private int getNewPublishID(string positionType)
{
publish.PositionType = positionType;
string newid = PublishPositionExe.Add(publish);
int x = Int32.Parse(newid);
return(x);
}
public void AddTest_Creat_NewPOP_PublishPosition()
{ //Arrange
publish.PositionType = "POP";
//Act
string result = PublishPositionExe.Add(publish);
//Assert
Assert.IsNotNull(result, $"Creat new publish ID is { result }");
}
public void SPNameTest_retrun_Positions_StoreProcedure_name()
{
//Arrange
string action = "Positions";
//Act
string expect = "dbo.tcdsb_LTO_PagePublish_Positions @Operate,@UserID,@SchoolYear,@PositionType,@Panel,@Status,@SearchBy,@SearchValue1,@SearchValue2";
string result = PublishPositionExe.SpName(action);
//Assert
Assert.AreEqual(expect, result, $" Publish Positions list Store Procedure Name: { result}");
}
public void SPNameTest_retrun_CreateNewPublish_StoreProcedure_name()
{
//Arrange
string action = "New";
//Act
string expect = "dbo.tcdsb_LTO_PagePublish_CreateNew @Operate,@UserID,@SchoolYear,@SchoolCode,@PositionID,@PositionType";
string result = PublishPositionExe.SpName(action);
//Assert
Assert.AreEqual(expect, result, $" Create new Publish Position Store Procedure Name: { result}");
}
public void SPNameTest_retrun_Position_StoreProcedure_name()
{
//Arrange
string action = "Position";
//Act
string expect = "dbo.tcdsb_LTO_PagePublish_Position @SchoolYear, @PositionID";
string result = PublishPositionExe.SpName(action);
//Assert
Assert.AreEqual(expect, result, $" Publish Position Store Procedure Name: { result}");
}
public void PrincipalsEmailTest()
{
var parameter = new
{
SchoolYear = "20192020",
SchoolCode = "0227",
PositionID = "14641"
};
//Act
string result = PublishPositionExe.PrincipalsEmail(parameter);
//Assert
Assert.IsNotNull(result, $"request position Info { result} .");
}
public void DeadlineTest_return_DeadlineDate_bygiveingPublishDate()
{
//Arrange
var anonyParametere = new
{
SchoolYear = "20192020",
DatePublish = "2019/11/11",
PositionType = "LTO"
};
//Act
string result = PublishPositionExe.Deadline(anonyParametere);
string expect = "2019/11/13";
//Assert
Assert.AreEqual(expect, result, $" The deasline date is { result } for publish date {anonyParametere.DatePublish } ");
}
private int getNewPublishID(string positionType)
{
NewPosition publish = new NewPosition()
{
Operate = "New",
SchoolYear = "20192020",
PositionID = "0",
PositionType = "LTO",
SchoolCode = "0549",
UserID = "mif"
};
publish.PositionType = positionType;
string newid = PublishPositionExe.Add(publish);
int x = Int32.Parse(newid);
return(x);
}
private string Step4_PostingRequestandGetPositionID()
{
// 4. posting Request
//Arrange
var parameter = new
{
SchoolYear = _schoolYear,
PositionID = _requestId.ToString() // create new request
};
var parameterForDeadline = new
{
SchoolYear = _schoolYear,
DatePublish = _publishDate,
PositionType = "LTO"
};
var requestPosition = PostingPositionExe.Position(parameter)[0]; // get the posting position
requestPosition.Comments = "Posting school request post position test process";
requestPosition.CPNum = _cpNum;
requestPosition.StartDate = _dateStart;
requestPosition.EndDate = _dateEnd;
requestPosition.DatePublish = _publishDate;
requestPosition.DateApplyOpen = _applyDate;
requestPosition.DateApplyClose = PublishPositionExe.Deadline(parameterForDeadline);
//Act
string postingPositionId = PostingPositionExe.Posting(requestPosition); // go for posting
_positionId = _requestId = Int32.Parse(postingPositionId);
var parameterForGetPostingNumber = new
{
Operate = "Get",
PositionID = postingPositionId
};
var result = PostingPositionExe.PostingNumber(parameterForGetPostingNumber); // get Published Position
string expect = DateTime.Now.Year.ToString() + "-" + postingPositionId;
//Assert
Assert.AreEqual(expect, result, $"Posting Request {result }");
return("Successfully");
}
public void CancelTest()
{
// Arrange
var parameter = new ParametersForPosition()
{
SchoolYear = schoolyear,
PositionID = getNewPublishID("LTO").ToString()
};
var position = PublishPositionExe.Position(parameter)[0];
position.Operate = "Cancel";
//Act
string result = PublishPositionExe.Cancel(position);
string expect = "Successfully";
//Assert
Assert.AreEqual(expect, result, $" { parameter.PositionID } has been cancel { result} ");
}
public void AttributeTest()
{
//Arrange
string action = "PositionInfo";
publish.UserID = "mif";
publish.Operate = action;
publish.SchoolYear = "20192020";
publish.SchoolCode = "0549";
publish.PositionID = getNewPublishID("LTO").ToString();
//act
string expect = "0549";
//Act
string result = PublishPositionExe.Attribute(parameter);
//Assert
Assert.IsNotNull(result, $"request position Info { result} .");
}
public void PostingNumberTest()
{
//Arrange
var parameter = new
{
SchoolYear = "20192020",
PositionID = GetNewRequestId("LTO").ToString() // create new request
};
var parameterForDeadline = new
{
SchoolYear = "20192020",
DatePublish = "2019/11/12",
PositionType = "LTO"
};
var requestPosition = PostingPositionExe.Position(parameter)[0]; // get the posting position
requestPosition.Comments = "Posting school request post position test process";
requestPosition.CPNum = "00000000";
requestPosition.StartDate = "2019/09/03";
requestPosition.EndDate = "2020/06/30";
requestPosition.DatePublish = "2019/11/11";
requestPosition.DateApplyOpen = "2019/11/12";
requestPosition.DateApplyClose = PublishPositionExe.Deadline(parameterForDeadline);
//Act
string postingPositionId = PostingPositionExe.Posting(requestPosition); // go for posting
var parameterForGetPostingNumber = new
{
Operate = "Get",
PositionID = postingPositionId
};
var result = PostingPositionExe.PostingNumber(parameterForGetPostingNumber); // get Published Position
string expect = DateTime.Now.Year.ToString() + "-" + postingPositionId;
//Assert
Assert.AreEqual(expect, result, $"Posting Number is { result } ");
}
public void PostingTest_return_PublishPositionID()
{
//Arrange
var parameter = new
{
SchoolYear = "20192020",
PositionID = GetNewRequestId("LTO").ToString() // create new request
};
var parameterForDeadline = new
{
SchoolYear = "20192020",
DatePublish = "2019/11/12",
PositionType = "LTO"
};
var requestPosition = PostingPositionExe.Position(parameter)[0]; // get the posting position
requestPosition.Comments = "Posting school request post position test process";
requestPosition.CPNum = "00000000";
requestPosition.StartDate = "2019/09/03";
requestPosition.EndDate = "2020/06/30";
requestPosition.DatePublish = "2019/11/11";
requestPosition.DateApplyOpen = "2019/11/12";
requestPosition.DateApplyClose = PublishPositionExe.Deadline(parameterForDeadline);
//Act
string postingPositionId = PostingPositionExe.Posting(requestPosition); // go for posting
var parameterFormPublishPosition = new
{
SchoolYear = "20192020",
PositionID = postingPositionId
};
var publishPosition = PublishPositionExe.Position(parameterFormPublishPosition)[0]; // get Published Position
string expect = parameter.PositionID;
string result = publishPosition.RequestID.ToString();
//Assert
Assert.AreEqual(expect, result, $"position posted new position ID is { postingPositionId }. request ID is { result } ");
}
public void RePostingTest()
{
//Arrange
var parameter = new ParametersForPosition()
{
SchoolYear = schoolyear,
PositionID = getNewPublishID("LTO").ToString()
};
var position = PublishPositionExe.Position(parameter)[0];
string prePostingCycle = position.PostingCycle;
position.Operate = "RePosting";
position.UserID = "mif";
position.Comments = "Reposting from test process";
position.PostingCycle = "2";
string repostingID = PublishPositionExe.RePosting(position);
parameter.PositionID = repostingID;
var parameter2 = new ParametersForPosition()
{
SchoolYear = schoolyear,
PositionID = repostingID
};
var position2 = PublishPositionExe.Position(parameter2)[0];
string expect = position.PostingNumber;
string result = position2.PostingNumber;
string expect2 = prePostingCycle;
string result2 = position2.PostingCycle;
//Assert
Assert.AreEqual(expect, result, $" { parameter.PositionID } reporting to { parameter2.PositionID} ");
Assert.AreEqual(expect, result, $" { parameter.PositionID } posting Number is { expect} ");
Assert.AreNotEqual(expect2, result2, $" { parameter.PositionID } posting Number is { expect} ");
}
public void UpdateTest_using_reretive_update_result_value_ToVerify()
{
//Arrange
var parameter = new ParametersForPosition()
{
SchoolYear = schoolyear,
PositionID = getNewPublishID("LTO").ToString()
};
var position = PublishPositionExe.Position(parameter)[0];
position.Operate = "Update";
position.SchoolYear = schoolyear;
position.PositionTitle = "Test Grade 10 Teacher";
position.PositionLevel = "BC708E";
position.Description = " position descriptions from HR staff";
position.StartDate = "2019/09/03";
position.EndDate = "2020/06/30";
position.DatePublish = "2019/11/11";
position.DateApplyOpen = "2019/11/13";
position.DateApplyClose = "2019/11/15";
string expect = "Successfully";
string expect2 = "2019/11/15";
string expect3 = parameter.PositionID;
//Act
string result = PublishPositionExe.Update(position);
var position2 = PublishPositionExe.Position(parameter)[0];
string result2 = position2.DateApplyClose;
string result3 = position2.PositionID.ToString();
//Assert
Assert.AreEqual(expect, result, $" Postion update is { result} ");
Assert.AreEqual(expect2, result2, $" Check with apply cloase Date. Postion Apply close Date is { result2} ");
Assert.AreEqual(expect3, result3, $" check with Position ID Position ID is { parameter.PositionID} ");
}
public void SaveTest_return_successfully_Save_EditContent()
{
//Arrange
var parameter = new
{
SchoolYear = "20192020",
PositionID = GetNewRequestId("LTO").ToString() // create new request
};
var parameterForDeadline = new
{
SchoolYear = "20192020",
DatePublish = "2019/11/12",
PositionType = "LTO"
};
var requestPosition = PostingPositionExe.Position(parameter)[0]; // get the posting position
requestPosition.Operate = "Save";
requestPosition.Comments = "Posting school request post position test process";
requestPosition.CPNum = "00000000";
requestPosition.StartDate = "2019/09/03";
requestPosition.EndDate = "2020/06/30";
requestPosition.DatePublish = "2019/11/11";
requestPosition.DateApplyOpen = "2019/11/12";
requestPosition.DateApplyClose = PublishPositionExe.Deadline(parameterForDeadline);
requestPosition.Qualification = "";
requestPosition.QualificationCode = "";
requestPosition.FTE = 1.00M;
requestPosition.FTEPanel = "Full";
//Act
string result = PostingPositionExe.Save(requestPosition);
string expect = "Successfully";
//Assert
Assert.AreEqual(expect, result, $"Posting Edit save action for { parameter.PositionID } is { result }");
}
public List <T> Positions(object parameter)
{
string sp = PublishPositionExe.SpName("Positions");
return(CommonExcute <T> .GeneralList(sp, parameter));
}
public string Update(object parameter)
{
string sp = PublishPositionExe.SpName("Update");
return(CommonExcute <string> .GeneralValue(sp, parameter));
}
public void PostingRoundsTest()
{
List <PositionPublish> result = PublishPositionExe.PostingRounds(parameter);
Assert.Fail();
}
