public ActiveUp.Net.Mail.DeltaExt.MailUser GetById(decimal id)
{
ActiveUp.Net.Mail.DeltaExt.MailUser user = null;
using (FAXPECContext dbcontext = new FAXPECContext())
{
var mailsender = dbcontext.MAIL_SENDERS.Where(x => x.ID_SENDER == id).FirstOrDefault();
try
{
int idmailserver = (int)mailsender.ID_MAILSERVER;
MAILSERVERS ms = dbcontext.MAILSERVERS.Where(x => x.ID_SVR == idmailserver).FirstOrDefault();
MailServer s = AutoMapperConfiguration.FromMailServersToModel(ms);
int idmailuser = (int)mailsender.ID_SENDER;
List <Folder> list = GetMailFolders(idmailuser);
user = DaoSQLServerDBHelper.MapToMailUser(mailsender, s, list);
}
catch (Exception ex)
{
if (!ex.GetType().Equals(typeof(ManagedException)))
{
ManagedException mEx = new ManagedException(ex.Message, "ERR_ACC_006", string.Empty, string.Empty, ex.InnerException);
ErrorLogInfo err = new ErrorLogInfo(mEx);
err.objectID = id.ToString();
log.Error(err);
}
user = null;
}
}
return(user);
}
public void Insert(ActiveUp.Net.Mail.DeltaExt.MailUser entity)
{
try
{
using (FAXPECContext dbcontext = new FAXPECContext())
{
MAIL_SENDERS s = new MAIL_SENDERS();
s.USERNAME = entity.LoginId;
s.ID_MAILSERVER = entity.Id;
s.ID_RESPONSABILE = entity.IdResponsabile;
s.PASSWORD = entity.Password;
// s.ID_RESPONSABILE = 1;
s.FLG_MANAGED = (entity.FlgManaged == 0) ? "0" : "1";
s.MAIL = entity.EmailAddress.ToLower().Trim();
dbcontext.MAIL_SENDERS.Add(s);
int resp = dbcontext.SaveChanges();
if (resp == 1)
{
entity.UserId = dbcontext.MAIL_SENDERS.OrderByDescending(c => c.ID_SENDER).FirstOrDefault().ID_SENDER;
}
}
}
catch (Exception ex)
{
if (!ex.GetType().Equals(typeof(ManagedException)))
{
ManagedException mEx = new ManagedException(ex.Message, "ERR_ACC_004", string.Empty, string.Empty, ex.InnerException);
ErrorLogInfo err = new ErrorLogInfo(mEx);
err.objectID = entity.Id.ToString();
log.Error(err);
}
}
}
public void Delete(decimal id)
{
using (var dbcontext = new FAXPECContext())
{
try
{
var oldserver = dbcontext.MAILSERVERS.Where(x => x.ID_SVR == (double)id).First();
dbcontext.MAILSERVERS.Remove(oldserver);
dbcontext.SaveChanges();
}
catch (Exception ex)
{
//Allineamento log - Ciro
if (ex.GetType() != typeof(ManagedException))
{
ManagedException mEx = new ManagedException(DalExMessages.RUBRICA_NON_AGGIORNATA + " " + ex.Message,
"DAL_UNIQUE_CODE_1",
string.Empty,
string.Empty,
ex);
ErrorLogInfo er = new ErrorLogInfo(mEx);
log.Error(er);
throw mEx;
}
else
{
throw;
}
//throw new ManagedException(DalExMessages.RUBRICA_NON_AGGIORNATA, "DAL_UNIQUE_CODE", "", "", "", "", "", ex);
}
}
}
public MailServer GetById(decimal id)
{
MailServer mailserver = null;
using (var dbcontext = new FAXPECContext())
{
try
{
var m = dbcontext.MAILSERVERS.Where(x => x.ID_SVR == (double)id).First();
mailserver = AutoMapperConfiguration.FromMailServersToModel(m);
}
catch (SqlException oex)
{
//Allineamento log - Ciro
if (oex.GetType() != typeof(ManagedException))
{
ManagedException mEx = new ManagedException(DalExMessages.TITOLO_NON_RECUPERATO + oex.Message,
"DAL_TIT_010",
string.Empty,
string.Empty,
oex);
ErrorLogInfo er = new ErrorLogInfo(mEx);
log.Error(er);
throw mEx;
}
else
{
throw;
}
//throw new ManagedException(DalExMessages.TITOLO_NON_RECUPERATO, "DAL_TIT_010", "", "", "", "", "", oex);
}
}
return(mailserver);
}
protected void odsServerConfig_ObjectCreating(object sender, ObjectDataSourceEventArgs e)
{
if (this.IdServer_ViewState != decimal.MinusOne)
{
try
{
MailServerConfigFacade facade = MailServerConfigFacade.GetInstance();
e.ObjectInstance = facade.LoadServerConfigById(this.IdServer_ViewState);
}
catch (Exception ex)
{
if (ex.GetType() != typeof(ManagedException))
{
ManagedException mEx = new ManagedException("Errore nel caricamento della configurazione del server", "CM020",
string.Empty, string.Empty, ex.InnerException);
ErrorLogInfo err = new ErrorLogInfo(mEx);
err.loggingAppCode = "WEB_MAIL";
err.objectID = this.Context.Session.SessionID;
log.Error(err);
info.AddMessage(mEx.Message, Com.Delta.Messaging.MapperMessages.LivelloMessaggio.ERROR);
}
else
{
info.AddMessage(ex.Message, Com.Delta.Messaging.MapperMessages.LivelloMessaggio.ERROR);
}
}
}
else
{
e.ObjectInstance = new MailServer();
}
}
public HttpResponseMessage getStatByUserMail(string utente, string mail,
string dt, string df,
int?page, int?start, int?limit, string sort, string dir)
{
StatModel model = new StatModel();
try
{
BackendUserService bus = new BackendUserService();
DateTime datainzio = DateTime.Parse(dt);
DateTime datafine = DateTime.Parse(df);
int starti = start.HasValue ? Convert.ToInt32(start) : 1;
int recordPagina = limit.HasValue ? Convert.ToInt32(limit) : 10;
int tot = 0;
List <UserResultItem> list = bus.GetStatsInBox(mail, utente, datainzio, datafine, starti, recordPagina, ref tot);
model.Totale = tot.ToString();
model.success = "true";
model.ElencoStat = list;
return(this.Request.CreateResponse <StatModel>(HttpStatusCode.OK, model));
}
catch (Exception ex)
{
ErrorLogInfo error = new ErrorLogInfo();
error.freeTextDetails = ex.Message + " " + "Parameteri: " + utente + " " + mail + " " + dt + " " + df;
error.logCode = "ERR_S01";
error.loggingAppCode = "PEC";
error.loggingTime = System.DateTime.Now;
error.uniqueLogID = System.DateTime.Now.Ticks.ToString();
log.Error(error);
model.message = ex.Message;
model.success = "false";
return(this.Request.CreateResponse <StatModel>(HttpStatusCode.OK, model));
}
}
public void Insert(SendMail.Model.RubricaMapping.RubricaEntita entity)
{
using (var dbcontext = new FAXPECContext())
{
try
{
var rubr = DaoSQLServerDBHelper.MapToRubrEntita(entity, true);
dbcontext.RUBR_ENTITA.Add(rubr);
int r = dbcontext.SaveChanges();
if (r == 1)
{
entity.IdReferral = (long)rubr.ID_REFERRAL;
}
else
{
//Allineamento log - Ciro
ManagedException mEx = new ManagedException("Errore inserimento ",
"RUB_ORA003",
string.Empty,
string.Empty,
null);
ErrorLogInfo er = new ErrorLogInfo(mEx);
log.Error(er);
throw mEx;
}
}
catch
{
throw;
}
}
}
public ICollection <MailServer> GetAll()
{
using (OracleCommand ocmd = new OracleCommand())
{
// preparo il command
ocmd.Connection = base.CurrentConnection;
ocmd.CommandText = "SELECT * FROM MAILSERVERS";
// eseguo il command
try
{
return(DaoOracleDbHelper <MailServer> .ExecSelectCommand(ocmd, DaoOracleDbHelper.MapToMailServer));
}
catch (OracleException oex)
{
//Allineamento log - Ciro
if (oex.GetType() != typeof(ManagedException))
{
ManagedException mEx = new ManagedException(DalExMessages.TITOLO_NON_RECUPERATO + oex.Message,
"DAL_TIT_001",
string.Empty,
string.Empty,
oex);
ErrorLogInfo er = new ErrorLogInfo(mEx);
log.Error(er);
throw mEx;
}
else
{
throw;
}
//throw new ManagedException(DalExMessages.TITOLO_NON_RECUPERATO, "DAL_TIT_001", "", "", "", "", "", oex);
}
}
}
public ICollection <Titolo> GetSottotitoliByIdPadre(decimal titoloKey)
{
using (OracleCommand ocmd = new OracleCommand())
{
ocmd.Connection = base.CurrentConnection;
ocmd.CommandText = "SELECT ID_SOTTOTITOLO AS ID_TITOLO, COM_CODE AS APP_CODE, SOTTOTITOLO AS TITOLO , PROT_CODE, ACTIVE FROM COMUNICAZIONI_SOTTOTITOLI WHERE REF_ID_TITOLO = :pREF_ID_TIT ORDER BY SOTTOTITOLO";
ocmd.Parameters.Add("pREF_ID_TIT", titoloKey);
List <string> mappingList = new List <string>()
{
"ID_TITOLO", "TITOLO", "PROT_CODE", "DELETED", "APP_CODE"
};
// eseguo il command
try
{
return(DaoOracleDbHelper <Titolo> .ExecSelectCommand(ocmd, DaoOracleDbHelper.MapToTitolo, mappingList));
}
catch (OracleException oex)
{
//TASK: Allineamento log - Ciro
ManagedException mEx = new ManagedException(DalExMessages.TITOLO_NON_RECUPERATO,
"DAL_TIT_001", string.Empty,
string.Empty, oex);
ErrorLogInfo err = new ErrorLogInfo(mEx);
log.Error(mEx);
throw mEx;
//throw new ManagedException(DalExMessages.TITOLO_NON_RECUPERATO, "DAL_TIT_001", "", "", "", "", "", oex);
}
}
}
public void Insert(MailRefs entity)
{
try
{
using (OracleCommand oCmd = base.CurrentConnection.CreateCommand())
{
oCmd.CommandText = cmdInsertMailRefs;
oCmd.Parameters.Add("MAILID", entity.RefIdMail);
oCmd.Parameters.Add("DEST", entity.AddresseeMail);
oCmd.Parameters.Add("TIPO", entity.AddresseeClass.ToString());
oCmd.BindByName = true;
oCmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
//Allineamento log - Ciro
if (ex.GetType() != typeof(ManagedException))
{
ManagedException mEx = new ManagedException(ex.Message, "ERR_INS001", string.Empty, string.Empty, ex);
ErrorLogInfo er = new ErrorLogInfo(mEx);
er.objectID = entity.IdRef.ToString();
log.Error(er);
throw mEx;
}
else
{
throw ex;
}
}
}
public HttpResponseMessage GetAllRoles()
{
RolesModel m = new RolesModel();
try
{
var roleStore = new RoleStore();
var roles = roleStore.GetAll().Result;
m.RolesList = roles;
m.Totale = roles.Count.ToString();
m.success = "true";
}
catch (Exception ex)
{
ErrorLogInfo error = new ErrorLogInfo();
error.freeTextDetails = ex.Message;
error.logCode = "ERR_R001";
error.loggingAppCode = "PEC";
error.loggingTime = System.DateTime.Now;
error.uniqueLogID = System.DateTime.Now.Ticks.ToString();
log.Error(error);
m.message = ex.Message;
m.success = "false";
return(this.Request.CreateResponse <RolesModel>(HttpStatusCode.InternalServerError, m));
}
return(this.Request.CreateResponse <RolesModel>(HttpStatusCode.OK, m));
}
public void setDefaultContact(long idTitolo, long refOrg, long idContatto)
{
using (OracleCommand oCmd = base.CurrentConnection.CreateCommand())
{
oCmd.CommandText = cmdSetDefaultContact;
oCmd.Parameters.Add(new OracleParameter("pCONTATTO", OracleDbType.Int64, idContatto, ParameterDirection.Input));
oCmd.Parameters.Add(new OracleParameter("pIDTITOLO", OracleDbType.Int64, idTitolo, ParameterDirection.Input));
oCmd.Parameters.Add(new OracleParameter("pIDENTITA", OracleDbType.Int64, refOrg, ParameterDirection.Input));
oCmd.BindByName = true;
try
{
int ret = oCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
//TASK: Allineamento log - Ciro
if (!ex.GetType().Equals(typeof(ManagedException)))
{
ManagedException mEx = new ManagedException(ex.Message,
"ORA_ERR007", string.Empty, string.Empty, ex);
ErrorLogInfo err = new ErrorLogInfo(mEx);
_log.Error(err);
throw mEx;
}
else
{
throw ex;
}
}
}
}
protected void odsServerConfig_Inserting(object sender, ObjectDataSourceMethodEventArgs e)
{
MailServer ms = e.InputParameters[0] as MailServer;
try
{
MailServerConfigFacade facade = MailServerConfigFacade.GetInstance();
facade.insertServerConfig(ms);
this.IdServer_ViewState = ms.Id;
info.AddMessage("Operazione effettuata", Com.Delta.Messaging.MapperMessages.LivelloMessaggio.OK);
}
catch (ManagedException mEx)
{
info.AddMessage(mEx.Message, Com.Delta.Messaging.MapperMessages.LivelloMessaggio.ERROR);
}
catch (Exception ex)
{
ManagedException mEx = new ManagedException("Errore nell'inserimento del nuovo server", "CM010",
string.Empty, string.Empty, ex.InnerException);
ErrorLogInfo err = new ErrorLogInfo(mEx);
err.loggingAppCode = "WEB_MAIL";
err.objectID = this.Context.Session.SessionID;
if (MySecurityProvider.CurrentPrincipal != null && MySecurityProvider.CurrentPrincipal.MyIdentity != null)
{
err.userID = MySecurityProvider.CurrentPrincipal.MyIdentity.UserName;
}
log.Error(err);
info.AddMessage(mEx.Message, Com.Delta.Messaging.MapperMessages.LivelloMessaggio.ERROR);
}
}
public void Update(ActiveUp.Net.Mail.DeltaExt.MailUser entity)
{
try
{
using (FAXPECContext dbcontext = new FAXPECContext())
{
MAIL_SENDERS m = dbcontext.MAIL_SENDERS.Where(x => x.ID_SENDER == entity.UserId).First();
if (m != null)
{
m.PASSWORD = entity.Password;
m.MAIL = entity.EmailAddress;
m.ID_RESPONSABILE = entity.IdResponsabile;
m.ID_MAILSERVER = entity.Id;
m.USERNAME = entity.LoginId;
m.FLG_MANAGED = (entity.FlgManaged == 0) ? "0" : "1";
dbcontext.SaveChanges();
}
}
}
catch (Exception ex)
{
if (!ex.GetType().Equals(typeof(ManagedException)))
{
ManagedException mEx = new ManagedException(ex.Message, "ERR_ACC_005", string.Empty, string.Empty, ex.InnerException);
ErrorLogInfo err = new ErrorLogInfo(mEx);
err.objectID = entity.Id.ToString();
log.Error(err);
}
}
}
public int GetMessageSize(string uid)
{
switch (InProtoGet())
{
case IncomingProtocols.POP3:
int idx = this.Pop3.Pop3Client.GetMessageIndex(uid);
if (idx > 0)
{
return(this.Pop3.Pop3Client.GetMessageSize(idx));
}
else
{
return(-1);
}
break;
case IncomingProtocols.IMAP:
//throw new ManagedException("Imap not supported at all!", String.Empty, String.Empty, String.Empty, null);
//TASK: Allineamento log - Ciro
ManagedException mEx = new ManagedException("Imap not supported at all!",
"ERR_MAIL_0114", string.Empty,
string.Empty, null);
ErrorLogInfo err = new ErrorLogInfo(mEx);
_log.Error(mEx);
throw mEx;
break;
default:
return(0);
}
}
public void Delete(decimal id)
{
OracleCommand ocmd = new OracleCommand();
ocmd.CommandText = deleteStatement;
ocmd.Parameters.Add("pID_SVR", id);
ocmd.Connection = base.CurrentConnection;
try
{
ocmd.ExecuteNonQuery();
}
catch (Exception ex)
{
//Allineamento log - Ciro
if (ex.GetType() != typeof(ManagedException))
{
ManagedException mEx = new ManagedException(DalExMessages.RUBRICA_NON_AGGIORNATA + " " + ex.Message,
"DAL_UNIQUE_CODE_1",
string.Empty,
string.Empty,
ex);
ErrorLogInfo er = new ErrorLogInfo(mEx);
log.Error(er);
throw mEx;
}
else
{
throw;
}
//throw new ManagedException(DalExMessages.RUBRICA_NON_AGGIORNATA, "DAL_UNIQUE_CODE", "", "", "", "", "", ex);
}
}
public void sendMail(Message message)
{
try
{
this.Smtp.SendMail(message, _AccSettings);
}
catch (Exception ex)
{
//TASK: Allineamento log - Ciro
if (ex.GetType() != typeof(ManagedException))
{
ManagedException mEx = new ManagedException("Non posso leggere la casella postale. Dettaglio: " + ex.Message,
"ERR_MAIL_0008", string.Empty,
string.Empty, ex);
ErrorLogInfo err = new ErrorLogInfo(mEx);
_log.Error(mEx);
throw mEx;
}
else
{
throw;
}
//throw new ManagedException("Non posso leggere la casella postale"
// , "ERR_MAIL_0008", "MailServerFacade.cs", "sendMail", "smtpController.sendMail", "", "", ex
// );
}
}
private void addEmailsTo(string mails, Message message)
{
mails = mails.Trim();
mails.Replace(" ", "");
string[] toArray = mails.Split(new char[] { ',', ';' }, StringSplitOptions.RemoveEmptyEntries);
string pattern = "\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*";
for (int i = 0; i < toArray.Length; i++)
{
if (toArray[i] != String.Empty)
{
if (Regex.IsMatch(toArray[i], pattern))
{
if (!selectEmail(message.To).Contains(toArray[i]))
{
message.To.Add(toArray[i]);
}
}
else
{
//Allineamento log - Ciro
ManagedException mEx = new ManagedException("La mail " + toArray[i] + "non è una mail valida", "ERR_MF_001", string.Empty, string.Empty, null);
ErrorLogInfo er = new ErrorLogInfo(mEx);
er.objectID = mails;
_log.Error(er);
throw mEx;
}
}
}
//throw new ManagedException("La mail " + toArray[i] + "non è una mail valida", "ERR_MF_001", null, null, null, null, null, null);
}
protected void odsMailConfig_Updating(object sender, ObjectDataSourceMethodEventArgs e)
{
try
{
MailAccountService mailAccountService = new MailAccountService();
MailUser mu = e.InputParameters[0] as MailUser;
if (!IsValidEmailDesc(mu.EmailAddress))
{
e.Cancel = true;
info.AddMessage("Errore nel formato della mail", Com.Delta.Messaging.MapperMessages.LivelloMessaggio.ERROR);
return;
}
mailAccountService.Update(mu);
info.AddMessage("Operazione effettauata", Com.Delta.Messaging.MapperMessages.LivelloMessaggio.OK);
}
catch (Exception ex)
{
if (ex.GetType() != typeof(ManagedException))
{
ManagedException mEx = new ManagedException("Errore nel caricamento della configurazione della mail", "CM008",
string.Empty, string.Empty, ex.InnerException);
ErrorLogInfo err = new ErrorLogInfo(mEx);
err.loggingAppCode = "WEB_MAIL";
err.objectID = this.Context.Session.SessionID;
log.Error(err);
info.AddMessage(mEx.Message, Com.Delta.Messaging.MapperMessages.LivelloMessaggio.ERROR);
}
else
{
info.AddMessage(ex.Message, Com.Delta.Messaging.MapperMessages.LivelloMessaggio.ERROR);
}
}
e.Cancel = true;
}
