protected void delete_Click(object sender, EventArgs e)
{
Button refBtn = (Button)(sender);
int testTravelDetailsId = 30;
itineraryDetailsDAO itineraryDao = new itineraryDetailsDAO();
travelDetailsDAO travelDao = new travelDetailsDAO();
int insCnt = itineraryDao.deleteItineraryDetailsInfo(testTravelDetailsId);
if (insCnt == 1)
{
System.Diagnostics.Debug.WriteLine("Itinerary Details Removed!");
}
else
{
System.Diagnostics.Debug.WriteLine("Itinerary Details Removing Failed!");
}
int insCntVer2 = travelDao.deleteTravelDetailsInfo(testTravelDetailsId);
if (insCntVer2 == 1)
{
System.Diagnostics.Debug.WriteLine("Travel Details Removed!!");
}
else
{
System.Diagnostics.Debug.WriteLine("Travel Details Removing Failed!");
}
}
protected void Page_Load(object sender, EventArgs e)
{
int travelDetailsId = int.Parse(Session["travelDetailsId"].ToString());
travelDetailsIdHidden.Value = travelDetailsId.ToString();
travelDetails travelDetailsObj = new travelDetails();
travelDetailsDAO travelDao = new travelDetailsDAO();
travelDetailsObj = travelDao.getTravelDetailsData(travelDetailsId);
if (travelDetailsObj != null)
{
tripNameLbl.Text = travelDetailsObj.tripNameClass;
startDateLblVer2.Text = travelDetailsObj.startDateClass.ToString();
endDateLbl.Text = travelDetailsObj.endDateClass.ToString();
countryLbl.Text = travelDetailsObj.countryClass;
stateLbl.Text = travelDetailsObj.stateClass;
descriptionLbl.Text = travelDetailsObj.descriptionClass;
}
else
{
errorMsg = "No details";
}
}
protected void deleteAndEditRow(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "editButton")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = gv1.Rows[index];
int testTravelDetailsId = int.Parse(row.Cells[1].Text);
Session["travelDetailsId"] = testTravelDetailsId;
Response.Redirect("edit.aspx");
}
else if (e.CommandName == "deleteButton")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = gv1.Rows[index];
int testTravelDetailsId = int.Parse(row.Cells[1].Text);
System.Diagnostics.Debug.WriteLine("row removed = " + testTravelDetailsId);
itineraryDetailsDAO itineraryDao = new itineraryDetailsDAO();
travelDetailsDAO travelDao = new travelDetailsDAO();
int insCnt = itineraryDao.deleteItineraryDetailsInfo(testTravelDetailsId);
if (insCnt == 1)
{
System.Diagnostics.Debug.WriteLine("Itinerary Details Removed!");
}
else
{
System.Diagnostics.Debug.WriteLine("Itinerary Details Removing Failed!");
}
int insCntVer2 = travelDao.deleteTravelDetailsInfo(testTravelDetailsId);
if (insCntVer2 == 1)
{
System.Diagnostics.Debug.WriteLine("Travel Details Removed!!");
}
else
{
System.Diagnostics.Debug.WriteLine("Travel Details Removing Failed!");
}
Response.Redirect("itineraryHomepage.aspx");
}
else if (e.CommandName == "editItinerary")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = gv1.Rows[index];
int testTravelDetailsId = int.Parse(row.Cells[1].Text);
Session["travelDetailsId"] = testTravelDetailsId;
System.Diagnostics.Debug.WriteLine("travel id is =" + testTravelDetailsId);
Response.Redirect("editItinerary.aspx");
}
}
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!";
}
}
protected void editTravelDetailsButton_Click(object sender, EventArgs e)
{
Thread.Sleep(5000);
string tripName, country, state, description;
DateTime startDate, endDate;
try
{
tripName = tripNameDetailsTextBox.Text;
country = countryTextBox.Text;
state = stateTextBox.Text;
description = descriptionDetails.InnerText;
startDate = DateTime.Parse(startDateInput.Text);
endDate = DateTime.Parse(endDateInput.Text);
if (String.IsNullOrEmpty(tripName))
{
errorMsg += "Please Enter A Trip Name!\n";
}
else if (String.IsNullOrEmpty(country))
{
errorMsg += "Please Enter A Country!\n";
}
else if (String.IsNullOrEmpty(description))
{
errorMsg += "Please Enter A Description!\n";
}
//else if (startDate > endDate)
//{
// errorMsg += "Please Pick A Start Date Earlier Than End Date!\n";
//}
//else if (endDate < startDate)
//{
// errorMsg += "Please Pick A End Date Later Than Start Date!\n";
//}
else
{
travelDetailsDAO travelDetailsDao = new travelDetailsDAO();
travelDetails travelObj = new travelDetails();
int travelDetailsId = int.Parse(travelDetailsIdHidden.Value);
System.Diagnostics.Debug.WriteLine("id is = " + travelDetailsId);
int insCnt = travelDetailsDao.updateTravelDetails(travelDetailsId, tripName, startDate, endDate, country, description, 0.00, state);
if (insCnt == 1)
{
Response.Redirect("itineraryHomepage.aspx");
System.Diagnostics.Debug.WriteLine("No error!");
}
else
{
errorMsg += "Error While Updating Data!";
status.Text = errorMsg;
System.Diagnostics.Debug.WriteLine(errorMsg);
}
}
}
catch (Exception ex)
{
errorMsg += ex.ToString();
}
}