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)); } }