Kapryśna metoda parsująca DateTime

Kapryśna metoda parsująca DateTime
Ulgikkksss
UL
Ulgikkksss
UL
  • Rejestracja:ponad 5 lat
  • Ostatnio:prawie 5 lat
  • Postów:37
0

Napotkałem dzisiaj w aplikacji ciekawy problem. Mianowicie, wszystko na localhoście działa aż miło, problem pojawił się po publikacji na hostingu. Otóż, mam metode, która na podstawie danych wejściowych z bazy danych parsuje to na klase DataTime. Zarówno na localu jak i na hostingu korzystam z tej samej bazy. Jak można zauważyć, dane są identyczne, jednak tutaj wyjątek się nie pojawia, a tam się pojawia. Proszę o pomoc.

To localhost jak widać po debugu

title

A to część logów powyższego kodu z hostingu

Kopiuj

DEBUG 2020-04-17 00:08:09,056 363393ms ManageController       ntNewNotifications - 04/16/20 14:14:40
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:40
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:41
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:41
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:41
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:41
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:42
DEBUG 2020-04-17 00:08:09,087 363425ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:42
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:42
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:43
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:43
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:43
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:43
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:44
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:44
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:44
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:45
DEBUG 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,103 363440ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:45
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:45
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:46
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:46
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:47
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:47
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:47
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:47
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:48
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:48
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:48
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:49
DEBUG 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,118 363456ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at ASP._Page_Areas_Admin_Views_Manage_Index_cshtml._CountNewNotifications()
DEBUG 2020-04-17 00:08:09,134 363472ms ManageController       ntNewNotifications - 04/16/20 14:14:49
DEBUG 2020-04-17 00:08:09,134 363472ms ManageController       ntNewNotifications - 04/16/20 14:14:39
ERROR 2020-04-17 00:08:09,134 363472ms ManageController       ntNewNotifications - System.FormatException: String was not recognized as a valid DateTime.
edytowany 1x, ostatnio: ŁF
Udostępnij
Kopiuj link do postu Kopiuj link do postu jako Markdown
Komentuj
somekind
somekind
somekind
somekind
Moderator
  • Rejestracja:około 17 lat
  • Ostatnio:2 dni
  • Lokalizacja:Wrocław
4

Skoro masz daty po hamburgerowemu, to albo ustaw format regionalny na serwerze na hamburgerowy, albo parsuj z wymuszeniem takiego, czyli np.:

Kopiuj
var ziemniak = DateTime.Parse(x.DateCreated, new CultureInfo("en-us"));
edytowany 1x, ostatnio: somekind
Udostępnij
Kopiuj link do postu Kopiuj link do postu jako Markdown
Komentuj
ŁF
ŁF
ŁF
ŁF
Moderator
  • Rejestracja:ponad 22 lata
  • Ostatnio:31 minut
5

Dlaczego w modelu trzymasz stringa z datą? Trzymaj tam datę z datą...

Udostępnij
Kopiuj link do postu Kopiuj link do postu jako Markdown
Komentuj
boska_cebula
BC
boska_cebula
BC
  • Rejestracja:prawie 6 lat
  • Ostatnio:4 miesiące
  • Postów:214
1

ogólnie to co napisał @ŁF a jak już się upierasz trzymajć stringi to ParseExact

Udostępnij
Kopiuj link do postu Kopiuj link do postu jako Markdown
Komentuj
Ulgikkksss
UL
Ulgikkksss
UL
  • Rejestracja:ponad 5 lat
  • Ostatnio:prawie 5 lat
  • Postów:37
0

Faktycznie, przeoczyłem format. Wszystko teraz działa jak nalezy. Dzięki za pomoc!

Udostępnij
Kopiuj link do postu Kopiuj link do postu jako Markdown
Komentuj

Zarejestruj się i dołącz do największej społeczności programistów w Polsce.

Otrzymaj wsparcie, dziel się wiedzą i rozwijaj swoje umiejętności z najlepszymi.

Utwórz konto