Please Help I Tried And Confuse In My Application Taskmanger

Question

1.00/5 (1 vote)

See more:

i want to put Value in ACompleteDate(Actual Complete Date) Column In My Table. But I am Confuse which Value insert in this column . Any Formula please Suggestion...

My Table Following:-

TaskID int
UserID int
TaskName nvarchar(150)
TaskDesc nvarchar(MAX)
ScriptName varchar(50)
StartDate date
EndDate date
TargatedDays int
ACompleteDate datetime
WorkedDays int
RateID int
RateRemarks nvarchar(50)
Status bit Checked
CreatedBY int
AdminRemarks nvarchar(MAX)
SystemDate datetime
IPAddress varchar(50)

Posted 2-Dec-14 20:01pm

Nishant.Chauhan80

Updated 2-Dec-14 20:02pm

v2

Add a Solution

Comments

Sinisa Hajnal 3-Dec-14 2:04am

Are you asking US what YOUR program should be doing? At some point, someone will mark the task complete. At that point you set the date to current date. What formula are you expecting? What should actually be in actual date?

Nishant.Chauhan80 3-Dec-14 2:09am

i want to insert Value in ACompleteDate(Actual Complete Date) Column but which value

Sinisa Hajnal 3-Dec-14 2:22am

That is exactly what I mean - we can tell you how to insert into the column but you have to know which value should go in there it is your program! Can you describe what should go in there? Why don't you just insert current date when the task is marked complete?

Nishant.Chauhan80 3-Dec-14 2:25am

No Column already Exist ACompleteDate(Actual Complete Date) Column See On above My Table But How to calculate ACompleteDate(Actual Complete Date) Vs Start Date

Sinisa Hajnal 3-Dec-14 2:32am

You're not making this any clearer. I know it exists, you're asking how to put value into it. But you never specify WHAT VALUE that is. My comments assume you want to mark the date when the task was actually complete. If you need something else, you have to describe it. What do you mean caclulate vs StartDate. Or to ask differently: If your StartDate is 1.1.2015 and your EndDate is 15.1.2015, what should be ActualDate?

Nishant.Chauhan80 3-Dec-14 2:45am

ActualDate is current date time of system

Nishant.Chauhan80 3-Dec-14 2:35am

ok sir thanks i was thought any formula StartDate Vs Actual Complete Date ok i use current date thanks again

Sinisa Hajnal 3-Dec-14 2:39am

That's what I said! :) Should've just write the solution instead of commenting :)

Nishant.Chauhan80 3-Dec-14 2:14am

which date insert in this column ACompleteDate(Actual Complete Date) Column

/\jmot 3-Dec-14 2:06am

not clear, be more specific.

1 solution

Add a Solution

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

OriginalGriff · Accepted Answer · 2014-12-02T20:29:00

When you mark the task as complete, there are two ways you can do it: issue an SQL UPDATE with the current date from the system on which the user decides it is complete:

C#

using (SqlCommand cmd = new SqlCommand("UPDATE MyTable SET ACompleteDate=@DT WHERE TaskID=@ID", con))
   {
   cmd.Parameters.AddWithValue("@ID", taskId);
   cmd.Parameters.AddWithValue("@DT", DateTime.Now);
   cmd.ExecuteNonQuery();
   }

The other alternative is toy use the server time:

C#

using (SqlCommand cmd = new SqlCommand("UPDATE MyTable SET ACompleteDate=GetDate() WHERE TaskID=@ID", con))
   {
   cmd.Parameters.AddWithValue("@ID", taskId);
   cmd.ExecuteNonQuery();
   }

Depends on the environment you want to work in which you want to use.

Please Help I Tried And Confuse In My Application Taskmanger

1 solution

Solution 1

Add your solution here

Preview 0

Please Help I Tried And Confuse In My Application Taskmanger

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us