public void DeleteQuestoesNaoAssociadas(int idFiltro)
{
using (var ctx = new DesenvContext())
{
ctx.SetCommandTimeOut(180);
SqlCommand sql = new SqlCommand(String.Format("DELETE from tblQuestao_MontaProva WHERE intFiltroId = {0} and intProvaId IS NULL", idFiltro.ToString()));
ctx.Database.ExecuteSqlRaw(sql.CommandText);
}
}
protected int DeleteQuestoesByProvaId(int ProvaId)
{
var sb = ProvaId.ToString();
using (var ctx = new DesenvContext())
{
ctx.SetCommandTimeOut(180);
ctx.Database.ExecuteSqlRaw(String.Format("DELETE from tblQuestao_MontaProva WHERE intProvaId = {0}", sb));
}
return(1);
}
protected int DeleteQuestoes(List <int> questoesIds)
{
if (questoesIds.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("(");
string combindedString = string.Join(",", questoesIds.ToArray());
sb.Append(combindedString);
sb.Append(")");
var stringbuilderresult = sb.ToString();
using (var ctx = new DesenvContext())
{
ctx.SetCommandTimeOut(180);
ctx.Database.ExecuteSqlRaw(String.Format("DELETE from tblQuestao_MontaProva WHERE intID in {0}", sb.ToString()));
}
}
return(1);
}
