/// <summary>
/// Prende la lista di tutte le cartelle non attive per la mail selezionata
/// </summary>
/// <param name="mail"></param>
/// <returns></returns>
public List <SendersFolders> GetFoldersNONAbilitati(string mail)
{
List <SendersFolders> listaCartelle = new List <SendersFolders>();
try
{
using (var dbcontext = new FAXPECContext())
{
var oCmd = dbcontext.Database.Connection.CreateCommand();
oCmd.CommandText = "SELECT DISTINCT m.ID_SENDER, f.NOME, m.MAIL, f.IDNOME, f.SYSTEM " +
"FROM [FAXPEC].[FAXPEC].[MAIL_SENDERS] m, [FAXPEC].[FAXPEC].[folders] f, [FAXPEC].[FAXPEC].[folders_senders] fs " +
"WHERE m.mail = '" + mail + "' " +
"EXCEPT " +
"SELECT DISTINCT m.ID_SENDER, f.NOME, m.MAIL, f.IDNOME, f.SYSTEM " +
"FROM [FAXPEC].[FAXPEC].[MAIL_SENDERS] m, [FAXPEC].[FAXPEC].[folders] f, [FAXPEC].[FAXPEC].[folders_senders] fs " +
"WHERE m.mail = '" + mail + "' " +
"AND m.ID_SENDER = fs.IDSENDER " +
"AND f.ID = fs.IDFOLDER";
oCmd.Connection.Open();
using (var r = oCmd.ExecuteReader())
{
if (r.HasRows)
{
listaCartelle = new List <SendersFolders>();
while (r.Read())
{
SendersFolders sFold = DaoSQLServerDBHelper.MapToSendersFolders(r);
listaCartelle.Add(sFold);
}
}
}
oCmd.Connection.Close();
}
}
catch (Exception ex)
{
listaCartelle = null;
//Allineamento log - Ciro
if (ex.GetType() != typeof(ManagedException))
{
ManagedException mEx = new ManagedException(ex.Message, "SND_ORA004", string.Empty, string.Empty, ex);
ErrorLogInfo er = new ErrorLogInfo(mEx);
log.Error(er);
}
}
return(listaCartelle);
}
