public NotificariEmailView(int _CURENT_USER_ID, string conStr, object _filterParams)
{
string _filter = "";
if (_filterParams is DateTime)
{
_filter = String.Format(" DATE(EMAIL_NOTIFICATIONS.TIMESTAMP) = '{0}' ", CommonFunctions.ToMySqlFormatDate(Convert.ToDateTime(_filterParams)));
}
if (_filterParams is int)
{
_filter = String.Format(" EMAIL_NOTIFICATIONS.ID_DOSAR = {0} ", Convert.ToInt32(_filterParams));
}
if (_filterParams is FilterNotificari)
{
FilterNotificari fn = (FilterNotificari)_filterParams;
_filter = String.Format(" DATE(EMAIL_NOTIFICATIONS.TIMESTAMP) >= '{0}' ", CommonFunctions.ToMySqlFormatDate(Convert.ToDateTime(fn.TimeStampStartFilter)));
_filter = String.Format("{0} AND DATE(EMAIL_NOTIFICATIONS.TIMESTAMP) <= '{1}' ", _filter, CommonFunctions.ToMySqlFormatDate(Convert.ToDateTime(fn.TimeStampEndFilter)));
if (!String.IsNullOrWhiteSpace(fn.NrDosarCascoFilter))
{
_filter = String.Format("{0} AND DOSARE.NR_DOSAR_CASCO LIKE '%{1}%' ", _filter, fn.NrDosarCascoFilter);
}
}
EmailNotificationsRepository enr = new EmailNotificationsRepository(_CURENT_USER_ID, conStr);
EmailNotification[] ens = (EmailNotification[])enr.GetFiltered(null, null, _filter, null).Result;
//LogWriter.Log(String.Format("length: {0}", ens.Length));
this.EmailNotifications = new EmailNotificationExtended[ens.Length];
for (int i = 0; i < ens.Length; i++)
{
this.EmailNotifications[i] = new EmailNotificationExtended(_CURENT_USER_ID, conStr, ens[i]);
}
}
public NotificariEmailView(int _CURENT_USER_ID, string conStr)
{
EmailNotificationsRepository enr = new EmailNotificationsRepository(_CURENT_USER_ID, conStr);
EmailNotification[] ens = (EmailNotification[])enr.GetAll().Result;
this.EmailNotifications = new EmailNotificationExtended[ens.Length];
for (int i = 0; i < ens.Length; i++)
{
this.EmailNotifications[i] = new EmailNotificationExtended(_CURENT_USER_ID, conStr, ens[i]);
}
}
