private void BindData()
{
try
{
IRouteManager routeManager = (IRouteManager)BusinessObjectManager.GetRouteManager();
DataTable dt = new DataTable();
List <Route> routes = routeManager.GetRoutes();
dt.Columns.Add("RouteId", typeof(long));
dt.Columns.Add("FromCityName", typeof(string));
dt.Columns.Add("ToCityName", typeof(string));
dt.Columns.Add("DistanceInKms", typeof(decimal));
dt.Columns.Add("status", typeof(bool));
foreach (Route r in routes)
{
DataRow rw = dt.NewRow();
rw["RouteId"] = r.ID;
rw["FromCityName"] = r.FromCity.Name + " (" + r.FromCity.StateInfo.Name + ")";
rw["ToCityName"] = r.ToCity.Name + " (" + r.ToCity.StateInfo.Name + ")";
rw["DistanceInKms"] = r.DistanceInKms;
rw["status"] = r.IsActive;
dt.Rows.Add(rw);
}
GridView1.DataSource = dt;
ctlAdminMaster.BuildPager(GridView1);
}
catch (RouteManagerException ex)
{
throw ex;
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
if (((TextBox)(row.Cells[3].Controls[0])).Text.Length == 0)
{
lblError.Text = "Distance in Kms Can't be Empty";
((TextBox)(row.Cells[3].Controls[0])).Focus();
}
else
{
try
{
IRouteManager routeManager = (IRouteManager)BusinessObjectManager.GetRouteManager();
Route route = new Route();
route.ID = long.Parse((row.Cells[0].Text));
route.DistanceInKms = long.Parse(((TextBox)(row.Cells[3].Controls[0])).Text);
route.IsActive = ((CheckBox)(row.Cells[4].Controls[0])).Checked;
routeManager.UpdateRoute(route);
e.Cancel = true;
GridView1.EditIndex = -1;
BindData();
lblError.Text = "Route Updated";
}
catch (RouteManagerException ex)
{
throw ex;
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (dpFromCity.Text.Equals("None") == true)
{
lblError.Text = "Select From City";
dpFromCity.Focus();
}
else if (dpToCity.Text.Equals("None") == true)
{
lblError.Text = "Select To City";
dpToCity.Focus();
}
else if (dpFromCity.SelectedItem.Text.Equals(dpToCity.SelectedItem.Text))
{
lblError.Text = "From City & To City Cannot be Same";
dpFromCity.Focus();
}
else if (txtDistance.Text.Length == 0)
{
lblError.Text = "Enter the Distance between Routes";
txtDistance.Focus();
}
else
{
try
{
Route route = new Route();
IRouteManager routeManager = (IRouteManager)BusinessObjectManager.GetRouteManager();
City fromcity = new City();
fromcity.CityId = long.Parse(dpFromCity.SelectedItem.Value);
fromcity.Name = dpFromCity.SelectedItem.Text;
route.FromCity = fromcity;
City tocity = new City();
tocity.CityId = long.Parse(dpToCity.SelectedItem.Value);
tocity.Name = dpToCity.SelectedItem.Text;
route.ToCity = tocity;
if (routeManager.GetRouteID(route) > 0)
{
lblError.Text = "Already route exists";
dpFromCity.Focus();
}
else
{
route.DistanceInKms = double.Parse(txtDistance.Text);
route.IsActive = chkActive.Checked;
routeManager.AddRoute(route);
lblError.Text = "Route Added Successfully";
}
}
catch (RouteManagerException ex)
{
throw ex;
}
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
TextBox txtDist = (TextBox)row.Cells[3].Controls[1];
if (txtDist != null)
{
long lngDistance = 0;
if ((!long.TryParse(txtDist.Text, out lngDistance)) || (lngDistance <= 0))
{
ctlAdminMaster.ErrorMessage = "Distance should be a positive number";
txtDist.Focus();
}
else
{
try
{
IRouteManager routeManager = (IRouteManager)BusinessObjectManager.GetRouteManager();
Route route = new Route();
route.ID = long.Parse(((Label)row.Cells[0].Controls.OfType <Label>().First()).Text);
route.DistanceInKms = lngDistance;
//route.IsActive = ((CheckBox)(row.Cells[4].Controls[0])).Checked;
route.IsActive = true;
routeManager.UpdateRoute(route);
e.Cancel = true;
GridView1.EditIndex = -1;
BindData();
ctlAdminMaster.ErrorMessage = "Route Updated";
}
catch (RouteManagerException ex)
{
throw ex;
}
}
}
}
private void clear()
{
dpAirlineName.Items.Clear();
dpFlightName.Items.Clear();
dpDepartHours.Items.Clear();
dpDepartMins.Items.Clear();
dpArrivalHours.Items.Clear();
dpArrivalMins.Items.Clear();
for (int i = 0; i < 24; i++)
{
dpDepartHours.Items.Add(i.ToString());
dpArrivalHours.Items.Add(i.ToString());
}
for (int i = 0; i <= 59; i += 10)
{
dpDepartMins.Items.Add(i.ToString());
dpArrivalMins.Items.Add(i.ToString());
}
txtDuration.Enabled = false;
txtDuration.Text = "";
chkStatus.Checked = false;
try
{
IRouteManager routeManager = (IRouteManager)BusinessObjectManager.GetRouteManager();
try
{
List <Route> routes = routeManager.GetRoutes();
//dpRoute.Items.Add(new ListItem("Select Route...", "-1"));
foreach (Route route in routes)
{
string r = route.FromCity.Name + " ==> " + route.ToCity.Name;
string v = route.ID.ToString();
dpRoute.Items.Add(new ListItem(r, v));
}
}
catch (RouteManagerException e)
{
ctlAdminMaster.ErrorMessage = e.Message;
}
AirLineManager objairline = new AirLineManager();
List <Airline> airlines = objairline.GetAirLines();
foreach (Airline a in airlines)
{
ListItem item = new ListItem(a.Name, a.Id.ToString());
dpAirlineName.Items.Add(item);
}
dpAirlineName.DataBind();
}
catch (CityManagerException ex)
{
ctlAdminMaster.ErrorMessage = ex.Message;
}
catch (AirlineManagerException ex)
{
ctlAdminMaster.ErrorMessage = ex.Message;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
Route route = null;
IScheduleManager scheduleManager = (IScheduleManager)AirTravelManagerFactory.Create("ScheduleManager");
Schedule schedule = new Schedule();
string rid = dpRoute.SelectedValue;
IRouteManager routeManager = (IRouteManager)BusinessObjectManager.GetRouteManager();
try
{
List <Route> routes = routeManager.GetRoutes();
foreach (Route r in routes)
{
if (r.ID == Convert.ToInt32(rid))
{
route = r;
break;
}
}
}
catch (RouteManagerException ex)
{
ctlAdminMaster.ErrorMessage = ex.Message;
}
schedule.RouteInfo = route;
if (scheduleManager.GetRouteID(schedule) == 0)
{
ctlAdminMaster.ErrorMessage = "Select the Existing Route";
}
else if (dpFlightName.SelectedItem == null)
{
ctlAdminMaster.ErrorMessage = "Please select a Flight name";
}
else
{
TimeSpan t1 = TimeSpan.Parse(dpArrivalHours.SelectedItem.ToString() + ":" + dpArrivalMins.SelectedItem.ToString());
TimeSpan t2 = TimeSpan.Parse(dpDepartHours.SelectedItem.ToString() + ":" + dpDepartMins.SelectedItem.ToString());
total = int.Parse((t1 - t2).TotalMinutes.ToString());
if (total == 0)
{
ctlAdminMaster.ErrorMessage = "The departure time and the arrival time cannot be same";
return;
}
if (total < 0)
{
total = (24 * 60) + total;
}
txtDuration.Text = total.ToString();
Flight flight = new Flight();
flight.ID = long.Parse(dpFlightName.SelectedItem.Value);
flight.Name = dpFlightName.SelectedItem.Text;
scheduleid = Request.QueryString["scheduleid"].ToString();
schedule.ID = long.Parse(scheduleid);
schedule.RouteInfo = route;
schedule.FlightInfo = flight;
schedule.DepartureTime = TimeSpan.Parse(dpDepartHours.SelectedItem.ToString() + ":" + dpDepartMins.SelectedItem.ToString());
schedule.ArrivalTime = TimeSpan.Parse(dpArrivalHours.SelectedItem.ToString() + ":" + dpArrivalMins.SelectedItem.ToString());
schedule.DurationInMins = total;
schedule.IsActive = chkStatus.Checked;
scheduleManager.UpdateSchedule(schedule);
Response.Redirect("~/Admin/Schedule_Flight.aspx");
}
}
catch (ScheduleManagerException ex)
{
ctlAdminMaster.ErrorMessage = ex.Message;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int intDistance = 0;
if (dpFromCity.Text.Equals("None") == true)
{
ctlAdminMaster.ErrorMessage = "Select From City";
dpFromCity.Focus();
}
else if (dpToCity.Text.Equals("None") == true)
{
ctlAdminMaster.ErrorMessage = "Select To City";
dpToCity.Focus();
}
else if (dpFromCity.SelectedItem.Text.Equals(dpToCity.SelectedItem.Text))
{
ctlAdminMaster.ErrorMessage = "From City & To City Cannot be Same";
dpFromCity.Focus();
}
else if (txtDistance.Text.Length == 0)
{
ctlAdminMaster.ErrorMessage = "Enter the Distance between Routes";
txtDistance.Focus();
}
else if (!int.TryParse(txtDistance.Text, out intDistance) || (intDistance <= 0))
{
ctlAdminMaster.ErrorMessage = "Distance should be a valid positive number";
txtDistance.Focus();
}
else
{
try
{
Route route = new Route();
IRouteManager routeManager = (IRouteManager)BusinessObjectManager.GetRouteManager();
City fromcity = new City();
fromcity.CityId = long.Parse(dpFromCity.SelectedItem.Value);
fromcity.Name = dpFromCity.SelectedItem.Text;
route.FromCity = fromcity;
City tocity = new City();
tocity.CityId = long.Parse(dpToCity.SelectedItem.Value);
tocity.Name = dpToCity.SelectedItem.Text;
route.ToCity = tocity;
if (routeManager.GetRouteID(route) > 0)
{
ctlAdminMaster.ErrorMessage = "Already route exists";
dpFromCity.Focus();
}
else
{
route.DistanceInKms = double.Parse(txtDistance.Text);
route.IsActive = chkActive.Checked;
routeManager.AddRoute(route);
ctlAdminMaster.ErrorMessage = "Route Added Successfully";
//Response.Redirect("~/Admin/Home.aspx");
}
}
catch (RouteManagerException ex)
{
ctlAdminMaster.ErrorMessage = ex.Message;
}
}
}
private void clear()
{
dpAirlineName.Items.Clear();
dpFlightName.Items.Clear();
dpDepartHours.Items.Clear();
dpDepartMins.Items.Clear();
dpArrivalHours.Items.Clear();
dpArrivalMins.Items.Clear();
dpDepartHours.Items.Add("None");
dpArrivalHours.Items.Add("None");
for (int i = 0; i < 24; i++)
{
dpDepartHours.Items.Add(i.ToString());
dpArrivalHours.Items.Add(i.ToString());
}
//dpDepartMins.Items.Add("None");
//dpArrivalMins.Items.Add("None");
for (int i = 0; i <= 59; i += 10)
{
dpDepartMins.Items.Add(i.ToString());
dpArrivalMins.Items.Add(i.ToString());
}
txtDuration.Enabled = false;
txtDuration.Text = "";
chkStatus.Checked = false;
IRouteManager routeManager = (IRouteManager)BusinessObjectManager.GetRouteManager();
try
{
List <Route> routes = routeManager.GetRoutes();
dpRoute.Items.Add(new ListItem("Select Route...", "-1"));
foreach (Route route in routes)
{
string r = route.FromCity.Name + " (" + route.FromCity.StateInfo.Name + ")" + " ==> " + route.ToCity.Name + " (" + route.ToCity.StateInfo.Name + ")";
string v = route.ID.ToString();
dpRoute.Items.Add(new ListItem(r, v));
}
}
catch (RouteManagerException e)
{
ctlAdminMaster.ErrorMessage = e.Message;
}
IAirLineManager airlineManager = (IAirLineManager)AirTravelManagerFactory.Create("AirlineManager");
try
{
List <Airline> airlines = airlineManager.GetAirLines();
dpAirlineName.Items.Add("None");
foreach (Airline c in airlines)
{
ListItem item = new ListItem(c.Name, c.Id.ToString());
dpAirlineName.Items.Add(item);
}
dpAirlineName.DataBind();
}
catch (AirlineManagerException e)
{
ctlAdminMaster.ErrorMessage = e.Message;
}
ShowDefaultClasses();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
IScheduleManager scheduleManager = (IScheduleManager)AirTravelManagerFactory.Create("ScheduleManager");
Schedule schedule = new Schedule();
Route route = null;
if (dpAirlineName.Text.Equals("None") == true)
{
ctlAdminMaster.ErrorMessage = "Select Airline Name";
dpAirlineName.Focus();
}
else if (dpFlightName.Text.Equals("None") == true)
{
ctlAdminMaster.ErrorMessage = "Select Flight Name";
dpFlightName.Focus();
}
else if (dpDepartHours.Text.Equals("None") == true)
{
ctlAdminMaster.ErrorMessage = "Select Departure Hours";
dpDepartHours.Focus();
}
else if (dpDepartMins.Text.Equals("None") == true)
{
ctlAdminMaster.ErrorMessage = "Select Departure Minutes";
dpDepartMins.Focus();
}
else if (dpArrivalHours.Text.Equals("None") == true)
{
ctlAdminMaster.ErrorMessage = "Select Arrival Hours";
dpArrivalHours.Focus();
}
else if (dpArrivalMins.Text.Equals("None") == true)
{
ctlAdminMaster.ErrorMessage = "Select Arrival Minutes";
dpArrivalMins.Focus();
}
else
{
string rid = dpRoute.SelectedValue;
if (rid.Equals("-1"))
{
ctlAdminMaster.ErrorMessage = "Select a route";
return;
}
IRouteManager routeManager = (IRouteManager)BusinessObjectManager.GetRouteManager();
try
{
List <Route> routes = routeManager.GetRoutes();
foreach (Route r in routes)
{
if (r.ID == Convert.ToInt32(rid))
{
route = r;
break;
}
}
}
catch (RouteManagerException ex)
{
ctlAdminMaster.ErrorMessage = ex.Message;
}
schedule.RouteInfo = route;
if (scheduleManager.GetRouteID(schedule) == 0)
{
ctlAdminMaster.ErrorMessage = "Select the Existing Route";
//dpFromCity.Focus();
}
else
{
TimeSpan t1 = TimeSpan.Parse(dpArrivalHours.SelectedItem.ToString() + ":" + dpArrivalMins.SelectedItem.ToString());
TimeSpan t2 = TimeSpan.Parse(dpDepartHours.SelectedItem.ToString() + ":" + dpDepartMins.SelectedItem.ToString());
total = int.Parse((t1 - t2).TotalMinutes.ToString());
if (total == 0)
{
ctlAdminMaster.ErrorMessage = "The departure time and the arrival time cannot be same";
return;
}
if (total < 0)
{
total = (24 * 60) + total;
}
txtDuration.Text = total.ToString();
Flight flight = new Flight();
flight.ID = long.Parse(dpFlightName.SelectedItem.Value);
flight.Name = dpFlightName.SelectedItem.Text;
schedule.RouteInfo = route;
schedule.FlightInfo = flight;
schedule.DepartureTime = TimeSpan.Parse(dpDepartHours.SelectedItem.ToString() + ":" + dpDepartMins.SelectedItem.ToString());
schedule.ArrivalTime = TimeSpan.Parse(dpArrivalHours.SelectedItem.ToString() + ":" + dpArrivalMins.SelectedItem.ToString());
schedule.DurationInMins = total;
schedule.IsActive = chkStatus.Checked;
foreach (RepeaterItem item in Repeater1.Items)
{
Label lblclassname = (Label)item.FindControl("ClassName");
TextBox txtcost = (TextBox)item.FindControl("txtCostPerTicket");
decimal cost = 0;
try
{
cost = Convert.ToDecimal(txtcost.Text);
}
catch (FormatException)
{
ctlAdminMaster.ErrorMessage = "Cost should be a positive currency value";
txtcost.Focus();
return;
}
if (cost <= 0)
{
ctlAdminMaster.ErrorMessage = "Cost should be a positive currency value";
txtcost.Focus();
return;
}
else
{
if (txtcost != null || lblclassname != null)
{
string classname = lblclassname.Text;
string val = txtcost.Text;
FlightCost fc = new FlightCost();
fc.Class = (TravelClass)Enum.Parse(typeof(TravelClass), classname);
fc.CostPerTicket = decimal.Parse(txtcost.Text);
schedule.AddFlightCost(fc);
}
}
}
//Extracted from the loop preventing a potential exception
try
{
scheduleManager.AddSchedule(schedule);
ctlAdminMaster.ErrorMessage = "Schedule Added Successfully";
//Response.Redirect("~/Admin/Home.aspx");
}
catch (ScheduleManagerException ex)
{
ctlAdminMaster.ErrorMessage = ex.Message;
}
}
}
}
