While using entity framework for saving data to SQL server db, date value changes to previous day

Question

0.00/5 (No votes)

See more:

, +

I am using entity framework 5 for saving data from application to SQL Server 2014 with a webservice.It is a winforms Application.

entity class is having date declared as below

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Entities.Commen;
namespace Entities.Masters
{
   public class ChittyRecieptEntity:Utility
    {
        public DateTime ChittyRepaymentDate { get; set; }
       ///...........
       ///.........
    }
}

and web services class is created like below

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Entities.Masters;
using System.Data.Entity;
using Data;
namespace Operations.Masters
{
   public class ChittyRecieptOperations
    {
       public ChittyRecieptEntity DoSaveChittyReciept(ChittyRecieptEntity entity)
        {
            try
            {
                using (JMFLEntities ctxt = new JMFLEntities())
                {
                    TblChittyReciept tblobj = new TblChittyReciept();
                ///.....
                ///....
                    tblobj.ChittyRepaymentDate = entity.ChittyRepaymentDate;
                    ctxt.SaveChanges();
                 }
            }
            catch (Exception ex)
            {
            }
            return entity;
        }

database field is ChittyRepaymentDate ,declared as date and not null

server is in US (godaddy)

this date field is passing from application (using datetime.now) ,but after saving in date field on sql server it is saved as previous date value.

can you tell me what might i have done wrong.

Thanks in advance
George

What I have tried:

while using service from local machine and database on live server, date is saving correctly.

a previous date selected in date picker of application saves correctly

selecting date on datepicker twice (other than current date then current date)
saves correctly

date passing from application with datetime.now and default date of date picker(current date) saves incorrect or previous date

while using break point in debugger can see value of date passing from application is correct and saving is incorrect on live server.

Posted 28-Jul-16 20:21pm

george4986

Updated 9-Aug-16 19:54pm

Add a Solution

2 solutions

Solution 1

Hi,
Did you try to call context.AcceptAllChanges() ?
The following link c# - SaveChanges vs. AcceptAllChanges in Entity Framework - Stack Overflow[^] contains the use for both methods.

C#

using (JMFLEntities ctxt = new JMFLEntities())
                {
                    TblChittyReciept tblobj = new TblChittyReciept();
                ///.....
                ///....
                    tblobj.ChittyRepaymentDate = entity.ChittyRepaymentDate;
//Edit: as you're creating a new EF object, I think you should attach it to context such as: 
ctxt.TblChittyReciepts.AddObject(tblobj); 

                    ctxt.SaveChanges();
                    ctxt.AcceptAllChanges(); 
                 }

Posted 31-Jul-16 2:34am

P_Z

Updated 31-Jul-16 2:40am

v2

Comments

george4986 10-Aug-16 1:56am

doesn't worked in my case.Thanks for sparing your time ;-)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

george4986 · Accepted Answer · 2016-08-09T19:54:00

I have resolved the issue by passing converted time using timezone within the application.Since the application's usage is within India.I have used like this

C#

public static DateTime toISTDate(DateTime input)
       {
           return TimeZoneInfo.ConvertTime(input.Date, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"));
       }

and converted date input as

C#

Entity.ChittyRepaymentManualDate = FormUtility.toISTDate(dtpManualRcptDate.Value);

This resolved my issue.I think while using entity framework,the value of datetime.now passing from application is changed to the hosted spaces location based time.