Create Problem Time Addition

i have a scenario that i need to add time.

for example time is 11:50 pm and i need to add 30 minutes. So after addition it should show me 00:20 am with date.

write a code for this.

i tried this but i get a error after adding.

after addition it is showing me something like 1.00:20:00.

so i need to convert this to date time.

Stop	Type	Address	Arrival	Waiting(Min)	Departure	Traval(Min)
CZCZ	CP	ZZC	8:00PM	60	9:00PM	0
ZCZC	CP	CVZVZ	9:00PM	20	9:20PM	10
CZZGVZ	CP	VZXVZV	9:30PM	10	9:40PM	20
asgdsag	CP	sdgsdg	10:00PM	10	10:10PM	20
ZCCZZ	CP	ZCZCZC	10:30PM	60	11:30PM	0
CZCZ	CP	ZCZCC	11:30 PM	5	11:35 PM	5
ZCZC	CP	ZVZVZ	11:40 PM	10	11:50 PM	10

Arrival Time + waiting time = Departure Time

and

Departure + Traval = Next Arrival Time

for (int i = 0; i < dtCurrentTable.Rows.Count; i++)

{

RadioButton Rdbs = ((RadioButton)GridRouteDetails.Rows[i].Cells[0].FindControl("GrdSelectAll"));

if (Rdbs.Checked == true)

{

dtTableRow = dtCurrentTable.NewRow();

int rowindex = Convert.ToInt32(ViewState["Gridindex"]);

dtTableRow["#"] = 0;

if (RadioCollectionpt0.Checked == true)

{

dtTableRow["Type"] = "CP";

dtTableRow["Stop"] = txtCollectionpoint0.Text;

}

if (RadioHCE0.Checked == true)

{

DataTable dt1 = (DataTable)ViewState["HCEOccupier"];

DataRow[] dr = dt1.Select("HCEID=" + ViewState["SelHCEId"].ToString());

if (dr.Length>0)

{

dtTableRow["Type"] = dr[0]["CustomerCode"].ToString();

}

dtTableRow["Stop"] = ddlHCEPoint0.SelectedItem.Text;

}

dtTableRow["Adress"] = txtAddress.Text;

var TMR=Convert.ToDateTime(ViewState["TIME"]);

var TMRQ= TMR - TMR.Date;

dtTableRow["ArrivalTime"] = TMRQ;

int IntTraval = Convert.ToInt16(txtTravelTime.Text);

TimeSpan TIntTraval = TimeSpan.FromMinutes(IntTraval);

dtTableRow["TravalTime"] = TIntTraval.Minutes;

dtTableRow["WaitingTime"] = txtWaitingTime.Text;

int WTO =Convert.ToInt16(txtWaitingTime.Text);

TimeSpan WTOresult = TimeSpan.FromMinutes(WTO);

dtTableRow["DepartureTime"] = TMRQ .Add(WTOresult);

TimeSpan DPTO= TMRQ .Add(WTOresult);

dtTableRow["HceID"] = ddlHCEPoint0.SelectedValue;

dtCurrentTable.Rows.InsertAt(dtTableRow, i + 1);

for (int P=i+1; P < dtCurrentTable.Rows.Count; P++)

{

DateTime DepTime = Convert.ToDateTime(dtCurrentTable.Rows[P - 1]["DepartureTime"]);

var DTMR = Convert.ToDateTime(DepTime);

var ConDepTime = DTMR - DTMR.Date;

int TravalTime = Convert.ToInt16(dtCurrentTable.Rows[P - 1]["TravalTime"]);

TimeSpan ConTravTime = TimeSpan.FromMinutes(TravalTime);

TimeSpan DDPTO = (ConDepTime.Add(ConTravTime));

//the Problem shows in TimeSpan DDPTO the value Shows {1.00:20:00}

//so give me Solution

DateTime DatDDPTO = Convert.ToDateTime("01 01 1920 " + DDPTO.ToString());

DatDDPTO.ToString("hh:mm tt");

dtCurrentTable.Rows[P]["ArrivalTime"] = DatDDPTO.ToString("hh:mm tt");

int WWTO = Convert.ToInt16(dtCurrentTable.Rows[P]["WaitingTime"]);

TimeSpan WWTOresult = TimeSpan.FromMinutes(WWTO);

TimeSpan DDD = DDPTO.Add(WWTOresult);

DateTime DatDTPTO = Convert.ToDateTime("01 01 1920 " + DDD.ToString());

DatDTPTO.ToString("hh:mm tt");

dtCurrentTable.Rows[P]["DepartureTime"] = DatDTPTO.ToString("hh:mm tt");

}

ViewState["RouteDetails"] = dtCurrentTable;

GridRouteDetails.DataSource = dtCurrentTable;

GridRouteDetails.DataBind();

break;

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjay Darekar11y ago
for (int i = 0; i < dtCurrentTable.Rows.Count; i++)
{
RadioButton Rdbs = ((RadioButton)GridRouteDetails.Rows[i].Cells[0].FindControl("GrdSelectAll"));
if (Rdbs.Checked == true)
{

dtTableRow = dtCurrentTable.NewRow();
int rowindex = Convert.ToInt32(ViewState["Gridindex"]);
dtTableRow["#"] = 0;
if (RadioCollectionpt0.Checked == true)
{
dtTableRow["Type"] = "CP";
dtTableRow["Stop"] = txtCollectionpoint0.Text;
}
if (RadioHCE0.Checked == true)
{
DataTable dt1 = (DataTable)ViewState["HCEOccupier"];
DataRow[] dr = dt1.Select("HCEID=" + ViewState["SelHCEId"].ToString());
if (dr.Length>0)
{
dtTableRow["Type"] = dr[0]["CustomerCode"].ToString();
}
dtTableRow["Stop"] = ddlHCEPoint0.SelectedItem.Text;
}
dtTableRow["Adress"] = txtAddress.Text;
var TMR=Convert.ToDateTime(ViewState["TIME"]);
var TMRQ= TMR - TMR.Date;
dtTableRow["ArrivalTime"] = TMRQ;
int IntTraval = Convert.ToInt16(txtTravelTime.Text);
TimeSpan TIntTraval = TimeSpan.FromMinutes(IntTraval);
dtTableRow["TravalTime"] = TIntTraval.Minutes;
dtTableRow["WaitingTime"] = txtWaitingTime.Text;
int WTO =Convert.ToInt16(txtWaitingTime.Text);
TimeSpan WTOresult = TimeSpan.FromMinutes(WTO);
dtTableRow["DepartureTime"] = TMRQ .Add(WTOresult);
TimeSpan DPTO= TMRQ .Add(WTOresult);
dtTableRow["HceID"] = ddlHCEPoint0.SelectedValue;
dtCurrentTable.Rows.InsertAt(dtTableRow, i + 1);
for (int P=i+1; P < dtCurrentTable.Rows.Count; P++)
{
DateTime DepTime = Convert.ToDateTime(dtCurrentTable.Rows[P - 1]["DepartureTime"]);
var DTMR = Convert.ToDateTime(DepTime);
var ConDepTime = DTMR - DTMR.Date;
int TravalTime = Convert.ToInt16(dtCurrentTable.Rows[P - 1]["TravalTime"]);
TimeSpan ConTravTime = TimeSpan.FromMinutes(TravalTime);
TimeSpan DDPTO = (ConDepTime.Add(ConTravTime));
//the Problem shows in TimeSpan DDPTO the value Shows {1.00:20:00}
//so give me Solution

DateTime DatDDPTO = Convert.ToDateTime("01 01 1920 " + DDPTO.ToString());

DatDDPTO.ToString("hh:mm tt");
dtCurrentTable.Rows[P]["ArrivalTime"] = DatDDPTO.ToString("hh:mm tt");

int WWTO = Convert.ToInt16(dtCurrentTable.Rows[P]["WaitingTime"]);
TimeSpan WWTOresult = TimeSpan.FromMinutes(WWTO);

TimeSpan DDD = DDPTO.Add(WWTOresult);

DateTime DatDTPTO = Convert.ToDateTime("01 01 1920 " + DDD.ToString());
DatDTPTO.ToString("hh:mm tt");

dtCurrentTable.Rows[P]["DepartureTime"] = DatDTPTO.ToString("hh:mm tt");
}
ViewState["RouteDetails"] = dtCurrentTable;
GridRouteDetails.DataSource = dtCurrentTable;
GridRouteDetails.DataBind();

break;
}

}
0
Manas Mohapatra11y ago
Can you please provide your code how you are converting so that you are getting different result. Then I will merge my solution with your code.

Thanks..
0