public void InsertNewVacationRequestTest_F5203_K_1()
{
bool Result = false;
TestDBReset Reset = new TestDBReset();
ulong VacationRequestID = 100;
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sqlStatement =
"INSERT INTO [dbo].[VacationRequest] VALUES (" + @VacationRequestID +
", @VacationStartDate, @VacationEndDate, @SubmissionDate, @VacationType, @VacationProcessingState, @ModificationDate, @VacationPeriodOverlapNote, @VacationLockPeriodNote, @NetVacationDays, @EmployeeID)";
using (SqlCommand cmd = new SqlCommand(sqlStatement, connection))
{
cmd.Parameters.AddWithValue("VacationStartDate", "20150301");
cmd.Parameters.AddWithValue("VacationEndDate", "20151202");
cmd.Parameters.AddWithValue("SubmissionDate", "2015-06-03 00:00:00.000");
cmd.Parameters.AddWithValue("VacationType", "Erholungsurlaub");
cmd.Parameters.AddWithValue("VacationProcessingState", "genehmigt");
cmd.Parameters.AddWithValue("ModificationDate", "2015-06-03 12:25:47.933");
cmd.Parameters.AddWithValue("VacationPeriodOverlapNote", 0);
cmd.Parameters.AddWithValue("VacationLockPeriodNote", 0);
cmd.Parameters.AddWithValue("NetVacationDays", 20);
cmd.Parameters.AddWithValue("EmployeeID", "f7bb0ab3-728b-4053-9b83-1b159a9d83a8");
try
{
connection.Open();
cmd.ExecuteNonQuery();
Result = true;
}
catch (SqlException e)
{
{
Result = false;
}
}
}
}
if (Result == true)
{
if (Reset.ResetTestDB())
{
Result = true;
}
else
{
Result = false;
}
}
bool actual = true;
Assert.AreEqual(actual, Result);
}
public void UpdateVacationRequestStatusTest_F5081_K_1()
{
TestDBReset Reset = new TestDBReset();
bool Result = false;
int UpdateVacationRequestStatusboth = 10;
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sqlStatement = //insert ID like that because of DataType conflicts
"UPDATE dbo.VacationRequest SET VacationProcessingState = @VacationProcessingState, ModificationDate = @modificationDate WHERE VacationRequestID = " +
UpdateVacationRequestStatusboth + "";
using (SqlCommand cmd = new SqlCommand(sqlStatement, connection))
{
cmd.Parameters.AddWithValue("VacationProcessingState", "ACHTUNG");
cmd.Parameters.AddWithValue("modificationDate", "2050-01-01 01:14:34.020");
try
{
connection.Open();
cmd.ExecuteNonQuery(); //insert,delete,update is NonQuery
Result = true;
}
catch (SqlException e) //if failure in Database result = false
{
{
Result = false;
}
}
}
}
if (Result == true)
{
if (Reset.ResetTestDB())
{
Result = true;
}
else
{
Result = false;
}
}
bool actual = true;
Assert.AreEqual(actual, Result);
}
public void UpdateRemainingVacationDaysTest_F5211_K_1()
{
bool Result = false;
TestDBReset Reset = new TestDBReset();
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sqlStatement =
"UPDATE VacationEntitlement SET VacationDayRemaining = @RemainingVacationDays WHERE EmployeeID = @EmployeeID";
using (SqlCommand cmd = new SqlCommand(sqlStatement, connection))
{
cmd.Parameters.AddWithValue("RemainingVacationDays", 40);
cmd.Parameters.AddWithValue("EmployeeID", "1e04bd54-4fb8-4bb8-806c-8ad7b8c90c43");
try
{
connection.Open();
cmd.ExecuteNonQuery();
Result = true;
}
catch (SqlException e)
{
{
Result = false;
}
}
}
}
if (Result == true)
{
if (Reset.ResetTestDB())
{
Result = true;
}
else
{
Result = false;
}
}
Assert.AreEqual(true, Result);
}