public List <itineraryDetails> getTravelDetails(string Id) { List <itineraryDetails> tdList = new List <itineraryDetails>(); SqlDataAdapter da; DataSet ds = new DataSet(); //Create Adapter //WRITE SQL Statement to retrieve all columns from Customer by customer Id using query parameter StringBuilder sqlCommand = new StringBuilder(); sqlCommand.AppendLine("Select * from travelDetails where"); sqlCommand.AppendLine("userId = @paraUserId"); SqlConnection myConn = new SqlConnection(DBConnect); da = new SqlDataAdapter(sqlCommand.ToString(), myConn); da.SelectCommand.Parameters.AddWithValue("paraUserId", Id); // fill dataset da.Fill(ds, "travelDetailsTable"); int rec_cnt = ds.Tables["travelDetailsTable"].Rows.Count; if (rec_cnt > 0) { foreach (DataRow row in ds.Tables["travelDetailsTable"].Rows) { itineraryDetails myTD = new itineraryDetails(); myTD.travelDetailsId = row["Id"].ToString(); myTD.tripNameClass = row["tripName"].ToString(); myTD.startDateClass = DateTime.Parse(row["startDate"].ToString()); myTD.endDateClass = DateTime.Parse(row["endDate"].ToString()); myTD.expectedExpensesClass = double.Parse(row["expectedExpense"].ToString()); myTD.countryClass = row["country"].ToString(); myTD.stateClass = row["state"].ToString(); myTD.userIdClass = row["userId"].ToString(); myTD.currentTimeClass = row["dateEntered"].ToString(); tdList.Add(myTD); } } else { tdList = null; } return(tdList); }
protected void Page_Load(object sender, EventArgs e) { int travelDetailsId = int.Parse(Session["travelDetailsId"].ToString()); itineraryDetailsDAO itineraryDetailsDao = new itineraryDetailsDAO(); itineraryDetails itiObj = new itineraryDetails(); itiObj = itineraryDetailsDao.getItineraryDetailsData(travelDetailsId); travellID.Value = travelDetailsId.ToString(); travelId.Value = (itiObj.itineraryHtmlClass).ToString(); if (itiObj != null) { System.Diagnostics.Debug.WriteLine("html is = " + itiObj.itineraryHtmlClass + " and travelid is = " + travelDetailsId); } else { System.Diagnostics.Debug.WriteLine("nth is shown"); } }
public itineraryDetails getItineraryDetailsData(int travelDetailsId) { //Get data to see which user is is SqlDataAdapter da; DataSet ds = new DataSet(); //Create Adapter //WRITE SQL Statement to retrieve all columns from Customer by customer Id using query parameter StringBuilder sqlCommand = new StringBuilder(); sqlCommand.AppendLine("Select itineraryHtml from itineraryDetails where"); sqlCommand.AppendLine("travelDetailsId = @paraItineraryDetailsId"); itineraryDetails obj = new itineraryDetails(); SqlConnection myConn = new SqlConnection(DBConnect); da = new SqlDataAdapter(sqlCommand.ToString(), myConn); da.SelectCommand.Parameters.AddWithValue("paraItineraryDetailsId", travelDetailsId); da.Fill(ds, "itineraryDetails"); int rec_cnt = ds.Tables["itineraryDetails"].Rows.Count; if (rec_cnt > 0) { DataRow row = ds.Tables["itineraryDetails"].Rows[0]; obj.itineraryHtmlClass = row["itineraryHtml"].ToString(); } else { obj = null; } return(obj); }