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