/// <summary>
/// Deletes an assignment from the db.
/// </summary>
/// <param name="assignment">The assignment you want to delete. Must have non-null Id.</param>
/// <returns>The number of rows deleted from the db.</returns>
public static int DeleteAssignment(Assignment assignment)
{
Stopwatch watch = Stopwatch.StartNew();
string sql = @"DELETE FROM dbo.Assignments
WHERE Id = @Id";
int output = AzureDataStore.DeleteData(sql, assignment);
watch.Stop();
Analytics.TrackEvent(nameof(DeleteAssignment), new Dictionary <string, string>
{
{ "ElapsedTime", $"{ watch.ElapsedMilliseconds } ms" }
});
return(output);
}
/// <summary>
/// Removes a user from enrollment in a class.
/// </summary>
/// <param name="class">
/// The class you wich the user to unenroll from.
/// Id, UserID, and Period must be non-null.
/// </param>
/// <returns>The number of rows deleted from the db.</returns>
public static int UnenrollUserFromClass(Class @class)
{
Stopwatch watch = Stopwatch.StartNew();
string sql = @"DELETE FROM dbo.Class_Users
WHERE ClassId = @Id AND UserId = @UserId AND Period = @Period";
int output = AzureDataStore.DeleteData(sql, @class);
watch.Stop();
Analytics.TrackEvent(nameof(UnenrollUserFromClass), new Dictionary <string, string>
{
{ "ElapsedTime", $"{ watch.ElapsedMilliseconds } ms" }
});
return(output);
}