internal static SendersFolders MapToSendersFolders(DbDataReader dr)
{
SendersFolders sFold = new SendersFolders();
sFold.IdSender = Convert.ToInt32(dr.GetValue("ID_SENDER"));
//sFold.IdFolder = Convert.ToInt32(dr.GetValue("ID"));
sFold.Nome = (string)dr.GetValue("NOME");
sFold.Mail = (string)dr.GetValue("MAIL");
sFold.IdNome = Convert.ToInt16(dr.GetValue("IDNOME"));
//sFold.Tipo = (string)dr.GetValue("TIPO");
sFold.System = Convert.ToInt16(dr.GetValue("SYSTEM"));
return(sFold);
}
/// <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);
}
/// <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 = null;
try
{
using (OracleCommand oCmd = base.CurrentConnection.CreateCommand())
{
oCmd.CommandText = "SELECT DISTINCT m.ID_SENDER, f.NOME, m.MAIL, f.IDNOME, f.SYSTEM " +
"FROM MAIL_SENDERS m,folders f,folders_senders fs " +
"WHERE m.mail = :MAIL1 " +
"MINUS " +
"SELECT DISTINCT m.ID_SENDER, f.NOME, m.MAIL, f.IDNOME, f.SYSTEM " +
"FROM MAIL_SENDERS m,folders f,folders_senders fs " +
"WHERE m.mail = :MAIL2 " +
"AND m.ID_SENDER = fs.IDSENDER " +
"AND f.ID = fs.IDFOLDER";
oCmd.Parameters.Add("MAIL1", mail);
oCmd.Parameters.Add("MAIL2", mail);
using (OracleDataReader r = oCmd.ExecuteReader())
{
if (r.HasRows)
{
listaCartelle = new List <SendersFolders>();
while (r.Read())
{
SendersFolders sFold = DaoOracleDbHelper.MapToSendersFolders(r);
listaCartelle.Add(sFold);
}
}
}
}
}
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);
}
public ICollection <SendersFolders> GetAll()
{
List <SendersFolders> list = new List <SendersFolders>();
try
{
using (var dbcontext = new FAXPECContext())
{
var groups = dbcontext.FOLDERS.GroupBy(x => x.IDNOME).ToList();
foreach (IEnumerable <FOLDERS> element in groups)
{
var f = element.First();
SendersFolders s = new SendersFolders()
{
IdFolder = (int)f.ID,
IdNome = (short)f.IDNOME,
Tipo = f.TIPO,
Nome = f.NOME
};
list.Add(s);
}
}
}
catch (Exception ex)
{
if (ex.GetType() != typeof(ManagedException))
{
throw ex;
}
ManagedException mEx = new ManagedException(ex.Message, "SND_ORA006", string.Empty, string.Empty, ex);
ErrorLogInfo er = new ErrorLogInfo(mEx);
log.Error(er);
throw mEx;
}
return(list);
}
public int Save(SendersFolders entity)
{
throw new NotImplementedException();
}
public void Update(SendersFolders entity)
{
throw new NotImplementedException();
}
public void Insert(SendersFolders entity)
{
throw new NotImplementedException();
}
