public static DataBaseExecute.ReturnResult InsertCancellationResults(int idAccount, string ReasonsRemovalTests, int idResult)
{
// делаем запрос с введеным в тектовое поле логином
SqlCommand command = new SqlCommand(SQLQuery.InsertCancellationResults);
command.Parameters.AddWithValue("@UserID", idAccount);
command.Parameters.AddWithValue("@Reason", ReasonsRemovalTests);
command.Parameters.AddWithValue("@prohozhdenie_testa_archive", idResult);
return(DataBaseExecute.ExecuteNonQuery(command, false));
}
public static DataBaseExecute.ReturnResult prohozhdenie_testa_archive(int accountId)
{
if (accountId == 0)
{
return new DataBaseExecute.ReturnResult()
{
StatusExecute = DataBaseExecute.ReturnResult.Status.Error, ErrorMsg = "Значение idKabinet указано неверно"
}
}
;
SqlCommand command = new SqlCommand(SQLQuery.InsertIntOprohozhdenieTestaArchive);
command.Parameters.AddWithValue("@ID_testiruemyj", accountId);
return(DataBaseExecute.ExecuteNonQuery(command, true));
}
public static DataBaseExecute.ReturnResult DeleteTestirovanie(int accountId)
{
if (accountId == 0)
{
return new DataBaseExecute.ReturnResult()
{
StatusExecute = DataBaseExecute.ReturnResult.Status.Error, ErrorMsg = "Значение idKabinet указано неверно"
}
}
;
SqlCommand command = new SqlCommand(SQLQuery.DeleteTestirovanie);
command.Parameters.AddWithValue("@IDtestiruemyj", accountId);
return(DataBaseExecute.ExecuteNonQuery(command, false));
}
public static DataBaseExecute.ReturnResult DeleteProhozhdenieTesta(int idKabinet)
{
if (idKabinet == 0)
{
return new DataBaseExecute.ReturnResult()
{
StatusExecute = DataBaseExecute.ReturnResult.Status.Error, ErrorMsg = "Значение idKabinet указано неверно"
}
}
;
SqlCommand command = new SqlCommand(SQLQuery.DeleteProhozhdenieTesta);
command.Parameters.AddWithValue("@IDKabinet", idKabinet);
return(DataBaseExecute.ExecuteNonQuery(command, false));
}