public void InsertNewShiftgroup()
{
ShiftGroup ShiftGroup = new VacationManagement.ShiftGroup("bff0f95a-5b1a-42cc-a1cc-8f520477c37a","d2dd4ad0-7c53-497e-aa5e-d9d09132076b");
bool Result = false;
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sqlStatement =
"INSERT INTO [dbo].[Shiftgroup] VALUES (@EmployeeID01, @EmployeeID02)";
using (SqlCommand cmd = new SqlCommand(sqlStatement, connection))
{
cmd.Parameters.AddWithValue("EmployeeID01", ShiftGroup.getEmployeeID01());
cmd.Parameters.AddWithValue("EmployeeID02", ShiftGroup.getEmployeeID02());
try
{
connection.Open();
cmd.ExecuteNonQuery();//insert/delete/update is nonQuery
Result = true;
}
catch (SqlException e) //if Failure in Database then Result = false
{
{
Result = false;
}
}
}
}
Assert.AreEqual(true, Result);
}
public Boolean InsertNewShiftgroup(ShiftGroup Shiftgroup)
{
bool Result = false;
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sqlStatement =
"INSERT INTO [dbo].[Shiftgroup] VALUES (@EmployeeID01, @EmployeeID02)";
using (SqlCommand cmd = new SqlCommand(sqlStatement, connection))
{
cmd.Parameters.AddWithValue("EmployeeID01", Shiftgroup.getEmployeeID01());
cmd.Parameters.AddWithValue("EmployeeID02", Shiftgroup.getEmployeeID02());
try
{
connection.Open();
cmd.ExecuteNonQuery();//insert/delete/update is nonQuery
UpdateNewShiftgroupInUser(Shiftgroup);
Result = true;
}
catch (SqlException e) //if Failure in Database then Result = false
{
{
Result = false;
}
}
}
}
return Result;
}
public Boolean UpdateNewShiftgroupInUser(ShiftGroup Shiftgroup)
{
bool Result = false;
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sqlStatement =
"UPDATE dbo.[AspNetUsers] SET ShiftGroupID = @ShiftgroupId WHERE Id = @EmployeeID01 OR Id = @EmployeeID02";
using (SqlCommand cmd = new SqlCommand(sqlStatement, connection))
{
cmd.Parameters.AddWithValue("ShiftgroupId", SelectShiftGroupId(Shiftgroup.getEmployeeID01()));
cmd.Parameters.AddWithValue("EmployeeID01", Shiftgroup.getEmployeeID01());
cmd.Parameters.AddWithValue("EmployeeID02", Shiftgroup.getEmployeeID02());
try
{
connection.Open();
cmd.ExecuteNonQuery();//insert/delete/update is nonQuery
Result = true;
}
catch (SqlException e) //if Failure in Database then Result = false
{
{
Result = false;
}
}
}
}
return Result;
}