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 JsonResult Filter(string _data)
{
try
{
string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
int uid = Convert.ToInt32(Session["CURENT_USER_ID"]);
FilterNotificari fn = JsonConvert.DeserializeObject <FilterNotificari>(_data, CommonFunctions.JsonDeserializerSettings);
//DateTime d = CommonFunctions.SwitchBackFormatedDate(_data) == null ? new DateTime() : CommonFunctions.SwitchBackFormatedDate(_data).Value.Date;
NotificariEmailView nev = new NotificariEmailView(uid, conStr, fn);
return(Json(JsonConvert.SerializeObject(nev, Formatting.None, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = CommonFunctions.DATE_FORMAT
}), JsonRequestBehavior.AllowGet));
}catch (Exception exp)
{
LogWriter.Log(exp);
response r = new response(false, exp.Message, null, null, new List <Error>()
{
new Error(exp)
});
return(Json(r, JsonRequestBehavior.AllowGet));
}
}
