//public string tablesData()
//{
// string html = "";
// itineraryDetailsDAO travelItineraryDao = new itineraryDetailsDAO();
// List<itineraryDetails> userList = new List<itineraryDetails>();
// userList = travelItineraryDao.getTravelDetails("2");
// if (userList != null)
// {
// foreach (var i in userList)
// {
// html += "<tr><td class='column1'>" + "12/09/2000" + "</td><td class='column2'>" + i.travelDetailsId + "</td><td class='column3'>" + i.tripNameClass + "</td><td class='column4'>" + i.startDateClass + "</td><td class='column5'>" + i.endDateClass + "</td><td class='column6'>" + i.countryClass + "</td><td class='column7'>" + i.stateClass + "</td><td class='column8'><asp:Button ID='button" + i.travelDetailsId + "' runat='server' class='btn btn-info' Text='Button' onclick='editItinerary_Click'/>" + "</td></tr>";
// }
// return html;
// }
// else
// {
// html = "<p>No details found!</p>";
// return html;
// }
//}
//void editItinerary_Click(object sender, EventArgs e)
//{
// userNameLbl.Text = "worked!";
//}
public List <itineraryDetails> details()
{
itineraryDetailsDAO travelItineraryDao = new itineraryDetailsDAO();
List <itineraryDetails> userList = new List <itineraryDetails>();
userList = travelItineraryDao.getTravelDetails("2");
if (userList != null)
{
return(userList);
}
else
{
return(userList);
}
}
protected void Page_Load(object sender, EventArgs e)
{
itineraryDetailsDAO travelItineraryDao = new itineraryDetailsDAO();
List <itineraryDetails> userList = new List <itineraryDetails>();
userList = travelItineraryDao.getTravelDetails("2");
if (userList != null)
{
gv1.DataSource = userList;
gv1.DataBind();
}
else
{
errorMsg = "null";
}
}
protected void addTravelDetails_Click(object sender, EventArgs e)
{
Thread.Sleep(5000);
status.Text = "";
// Initialize all variables
string tripName, email, country, description, state, currentTime;
DateTime startDate, endDate;
double expectedExpense;
string userId;
//Getting information from textBoxes <need to add validations>
tripName = tripNameDetails.Text.ToString();
email = emailDetails.Text.ToString();
country = countryTextBox.Text.ToString();
description = descriptionDetails.InnerText; // Will change once textarea bug is fixed
startDate = DateTime.Parse(startDateInput.Text);
endDate = DateTime.Parse(endDateInput.Text);
expectedExpense = 0.00;
state = stateTextBox.Text.ToString();
currentTime = DateTime.Now.ToString("yyyy, MM, dd, hh, mm, ss");
userId = "2";
//Validate
string errorMessage;
try
{
travelDetailsDAO tdDAO = new travelDetailsDAO();
int insCnt = tdDAO.insertTravelDetailsInfo(tripName, startDate, endDate, country, description, expectedExpense, state, userId, currentTime);
if (insCnt == 1)
{
itineraryDetailsDAO travelItineraryDao = new itineraryDetailsDAO();
List <itineraryDetails> userList = new List <itineraryDetails>();
userList = travelItineraryDao.getTravelDetails("2");
foreach (var i in userList)
{
if (i.tripNameClass == tripName)
{
Session["travelId"] = i.travelDetailsId;
}
}
status.Text = "Data Successfully Added! Redirecting you to the next page.";
Thread.Sleep(5000);
Response.Redirect("itineraryCreatorStep2.aspx");
}
else
{
errorMessage = "Unable to insert travel details, please inform system administrator!";
status.Text = errorMessage;
Thread.Sleep(5000);
Response.Redirect("itineraryCreatorStep1.aspx");
}
}
catch (FormatException)
{
errorMessage = "Reached Catch!";
}
}