How to know which line give me error incorrect string with date time

Question

How to know which line give me error incorrect string with date time

Ahmed Salah Abed Elaziz 390

I work on app asp.net MVC . I face issue on local machine code below working without any issue but on IIS server publish I get error 500 internal server error

I get error Input string was not in a correct format with Date Time

my question which line date time conversation make this error and which fuction or convert there are multiple one

so How to know this error

I don't know error because i work on server iis

so which tool or modifications code that let me know source line of error .

can you please help me

How to know which line give error incorrect string with date time

    [HttpPost]
    public JsonResult RequesterIndex(ResignationRequester resignationRequester)
    {
        dynamic responseData = new ExpandoObject();
        responseData.success = false;
        responseData.message = "";
       
        var filenumber = resignationRequester.EmpID;
        if (Session[SessionKeys.UserCode] != null)
        {
            JDEUtility jde = new JDEUtility();
            resignationRequester.DeptCode = Session[SessionKeys.DepartmentCode].ToString();
            resignationRequester.EmpID = Convert.ToInt32(Session[SessionKeys.UserCode]);
            resignationRequester.EmpName = Convert.ToString(Session[SessionKeys.Username]);
            resignationRequester.Dept = Convert.ToString(Session[SessionKeys.Department]);
            resignationRequester.Designation = Convert.ToString(Session[SessionKeys.Designation]);
            resignationRequester.PayGrade = Convert.ToString(Session[SessionKeys.PayGrade]);
            resignationRequester.CompanyCode = Convert.ToString(Session[SessionKeys.Company]);
            resignationRequester.Gender = Convert.ToString(Session[SessionKeys.Gender]);

            resignationRequester.ServiceDuration = Convert.ToString(Session[SessionKeys.ServiceDuration]);
            int noticeperiod = Convert.ToInt32(Session[SessionKeys.NoticePeriod]);
            int julianRequestDate = JulianDate.DateTimeToJulian(resignationRequester.LastWorkingDate);
            int SubmitionDate = JulianDate.DateTimeToJulian((DateTime)Session[SessionKeys.SubmitionDate]);
            int JoinedDate = JulianDate.DateTimeToJulian((DateTime)Session[SessionKeys.JoinDate]);
            int storedLastedWorkingDate = JulianDate.DateTimeToJulian((DateTime)Session[SessionKeys.LastWorkingDate]);
            int visaExpiryDate;
            if (Session[SessionKeys.VisaExpiryDate] == null)
            {
                visaExpiryDate = 0;
            }
            else
            {
                DateTime visDateExpire = Convert.ToDateTime(Session[SessionKeys.VisaExpiryDate]);
                visaExpiryDate = JulianDate.DateTimeToJulian(visDateExpire);

            }


         

            if (ModelState.IsValid)
            {
             

                if (julianRequestDate > storedLastedWorkingDate)
                {
                    //ViewBag.errorMsg
                    responseData.success = false;
                    responseData.message = "Last Working Date Must Not Increase Notice Period";
                    return Json(responseData);
                 

                }
                if (resignationRequester.DirectManager == 0)
                {
                 
                    responseData.success = false;
                    responseData.message = "Department Manager Must Be Bigger Than 0";
                    return Json(responseData);
                   

                }
                if (Convert.ToString(resignationRequester.LineManager).Length < 6 && !string.IsNullOrEmpty(resignationRequester.LineManager.ToString()))
                {
                    responseData.success = false;
                    responseData.message = "Length Line Manager Must Be equal 6 or More";
                    return Json(responseData);
                 
                }
                if (Convert.ToString(resignationRequester.DirectManager).Length < 6 && !string.IsNullOrEmpty(resignationRequester.DirectManager.ToString()))
                {
                    responseData.success = false;
                    responseData.message = "Length Direct Manager Must Be equal 6 or More";
                    return Json(responseData);
                   
                }
                if (Convert.ToInt32(resignationRequester.EmpID) == Convert.ToInt32(resignationRequester.DirectManager) &&
Convert.ToInt32(resignationRequester.EmpID) == Convert.ToInt32(resignationRequester.LineManager)
&& !string.IsNullOrEmpty(Convert.ToString(resignationRequester.LineManager)) && !string.IsNullOrEmpty(Convert.ToString(resignationRequester.DirectManager)))
                {
                    responseData.success = false;
                    responseData.message = "Requester Have Same Number of Manager";
                    return Json(responseData);
                  
                }
                if (!string.IsNullOrEmpty(Convert.ToString(resignationRequester.LineManager)) && resignationRequester.LineManagerName == null)
                {
                    responseData.success = false;
                    responseData.message = "Line Manager Name Blank";
                    return Json(responseData);
                    //goto InvalidModel;
                }
                if (julianRequestDate > 0 && SubmitionDate > 0 && julianRequestDate < SubmitionDate)
                {
                    responseData.success = false;
                    responseData.message = "Last Worked Date Must be Bigger than Submit Date";
                    return Json(responseData);
                    //goto InvalidModel;
                }
    

                int checkEmployeeNoExist = jde.CheckEmployeeExistOrNot(resignationRequester.EmpID);
                if (checkEmployeeNoExist >= 1)
                {
                    responseData.success = false;
                    responseData.message = "Employee Exist Before";
                    return Json(responseData);
    
                }


                try
                {
                    Workforce.InsertToReignation(resignationRequester, JoinedDate, (string)Session[SessionKeys.Username], (DateTime)Session[SessionKeys.LastWorkingDate], noticeperiod, (int)Session[SessionKeys.UserCode]);
                }
                catch (Exception ex)
                {
                    responseData.success = false;
                    responseData.message = "Create Not Done Correctly";
                    return Json(responseData);
                }
                Session[SessionKeys.DirectManager] = GetEmployeeName(Convert.ToString(resignationRequester.DirectManager));
                Session[SessionKeys.LineManager] = GetEmployeeName(Convert.ToString(resignationRequester.LineManager));
                if (string.IsNullOrEmpty(ViewBag.errorMsg))
                {
                    responseData.success = true;
                    responseData.message = "Resignation Submission form Created successfully";
                    TempData["SuccessBeforePrint"] = 1;

                    return Json(responseData);
                }



            }
            else
            {
                responseData.success = false;
                var errors = ModelState.Select(x => x.Value.Errors)
                                        .Where(y => y.Count > 0)
                                        .ToList();
                responseData.message = "Some Required Fields Not Added";
                return Json(responseData);

            }
        }
        else
        {
            responseData.success = false;
            responseData.message = "No Data For This File No";
            return Json(responseData);
        }
        return Json(responseData);
        
    }

AgaveJoe 1,510 Reputation points

2023-11-07T21:03:42.6533333+00:00

Use standard exception handling and logging to find errors during runtime. For example wrap the code in a try...catch. Log all the variable values needed in the catch block.

https://learn.microsoft.com/en-us/dotnet/csharp/language-reference/statements/exception-handling-statements
SurferOnWww 4,721 Reputation points

2023-11-08T01:08:06.5366667+00:00

What is your development environment? Which do you use, .NET Framework or .NET/.NET Core?
Ahmed Salah Abed Elaziz 390 Reputation points

2023-11-08T01:32:24.74+00:00

.NET Framework asp.net mvc and above is web api action
Yurong Dai-MSFT 2,846 Reputation points Microsoft External Staff

2023-11-08T03:27:57.0733333+00:00

Hi @Ahmed Salah Abed Elaziz,

In the code you provided, there are several date conversions from DateTime to int using the DateTimeToJulian method. You receive the error The input string has an incorrect date-time format, most likely due to an invalid or incorrectly formatted DateTime value. To determine which line of code caused this error, you can add exception handling and log the error details. Surround the code block where the date conversion occurs with a try-catch block to catch any exceptions. Inside the catch block, log the error details and the specific DateTime value that caused the problem.
Ahmed Salah Abed Elaziz 390 Reputation points

2023-11-08T05:06:14.3833333+00:00

how to know which date cause issue and get information about column that have issue conversion date time

so exactly how to get as example if date of visaexpire is issue how to get

invalid or incorrectly formatted DateTime value of column visa expiry date
Yurong Dai-MSFT 2,846 Reputation points Microsoft External Staff

2023-11-08T06:49:43.05+00:00

Hi @Ahmed Salah Abed Elaziz,

Does your code work properly in your local development environment? Or does the error only occur when deploying to IIS?
AgaveJoe 1,510 Reputation points

2023-11-08T10:10:24.4133333+00:00

how to know which date cause issue and get information about column that have issue conversion date time

For the third time! Add a try...catch to catch the exception. Then inside the catch block write code to capture the Session values. Did you read the linked documentation I provided? Did you at least try adding a try...catch?
Lex Li 6,037 Reputation points

2023-11-08T15:15:50.3133333+00:00

Which IIS installation are you using? If that's just the local IIS installed on your development machine, simply attach Visual Studio debugger to the right w3wp.exe process and you can easily see the actual exceptions.

2 answers

Your answer

AgaveJoe 1,510 Reputation points

2023-11-07T21:03:42.6533333+00:00

Use standard exception handling and logging to find errors during runtime. For example wrap the code in a try...catch. Log all the variable values needed in the catch block.

https://learn.microsoft.com/en-us/dotnet/csharp/language-reference/statements/exception-handling-statements
SurferOnWww 4,721 Reputation points

2023-11-08T01:08:06.5366667+00:00

What is your development environment? Which do you use, .NET Framework or .NET/.NET Core?
Ahmed Salah Abed Elaziz 390 Reputation points

2023-11-08T01:32:24.74+00:00

.NET Framework asp.net mvc and above is web api action
Yurong Dai-MSFT 2,846 Reputation points Microsoft External Staff

2023-11-08T03:27:57.0733333+00:00

Hi @Ahmed Salah Abed Elaziz,

In the code you provided, there are several date conversions from DateTime to int using the DateTimeToJulian method. You receive the error The input string has an incorrect date-time format, most likely due to an invalid or incorrectly formatted DateTime value. To determine which line of code caused this error, you can add exception handling and log the error details. Surround the code block where the date conversion occurs with a try-catch block to catch any exceptions. Inside the catch block, log the error details and the specific DateTime value that caused the problem.
Ahmed Salah Abed Elaziz 390 Reputation points

2023-11-08T05:06:14.3833333+00:00

how to know which date cause issue and get information about column that have issue conversion date time

so exactly how to get as example if date of visaexpire is issue how to get

invalid or incorrectly formatted DateTime value of column visa expiry date
Yurong Dai-MSFT 2,846 Reputation points Microsoft External Staff

2023-11-08T06:49:43.05+00:00

Hi @Ahmed Salah Abed Elaziz,

Does your code work properly in your local development environment? Or does the error only occur when deploying to IIS?
AgaveJoe 1,510 Reputation points

2023-11-08T10:10:24.4133333+00:00

how to know which date cause issue and get information about column that have issue conversion date time

For the third time! Add a try...catch to catch the exception. Then inside the catch block write code to capture the Session values. Did you read the linked documentation I provided? Did you at least try adding a try...catch?
Lex Li 6,037 Reputation points

2023-11-08T15:15:50.3133333+00:00

Which IIS installation are you using? If that's just the local IIS installed on your development machine, simply attach Visual Studio debugger to the right w3wp.exe process and you can easily see the actual exceptions.

Answer 1

Olaf Helper 47,516

In one part you handle "VisaExpiryDate" as integer and in the next as datetime; that can't work,

Ahmed Salah Abed Elaziz 390 Reputation points

2023-11-08T12:22:00.86+00:00

can you show me please according to above

how to user try and catch or throw to get specific error on which line and which property please

can you show by sample code if possible according to code above

Answer 2

Bruce (SqlWork.com) 78,086 Volunteer Moderator

While the best approach is proper logging so you can reproduce the problem locally, just push a debug build and pdb file.

Share via

How to know which line give me error incorrect string with date time

2 answers

Your answer