protected void lvSummary_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
RouteOrder r = (RouteOrder)(dataItem.DataItem);
Label lblRouteTotal = (Label)(dataItem.FindControl("lblRouteTotal"));
lblRouteTotal.Text = r.RouteTotalAmount.ToString("c") + " USD";
Label lblRouteName = (Label)(dataItem.FindControl("lblRouteName"));
Route route = new Route().GetRouteBySchedule(r.ScheduleId.Value);
lblRouteName.Text = route.DeparturePort.PortName + " - " + route.ArriavlPort.PortName;
Schedule schedule = new Schedule().GetById(r.ScheduleId.Value, false);
Label lblVesselName = (Label)(dataItem.FindControl("lblVesselName"));
lblVesselName.Text = schedule.Vessel.VesselName;
Vessel vessel = new Vessel().GetById(schedule.VesselId.Value, false);
Label lblCompanyName = (Label)(dataItem.FindControl("lblCompanyName"));
lblCompanyName.Text = vessel.Operator.CompanyName;
Label lblDepartureDatetime = (Label)(dataItem.FindControl("lblDepartureDatetime"));
lblDepartureDatetime.Text = schedule.SailingTime.HasValue ? schedule.SailingTime.Value.ToString() : string.Empty;
Label lblArrivalDatetime = (Label)(dataItem.FindControl("lblArrivalDatetime"));
lblArrivalDatetime.Text = schedule.ArrivalTime.HasValue ? schedule.ArrivalTime.Value.ToString() : string.Empty;
Label lblPassenger = (Label)(dataItem.FindControl("lblPassenger"));
Label lblTransport = (Label)(dataItem.FindControl("lblTransport"));
Label lblAccommodation = (Label)(dataItem.FindControl("lblAccommodation"));
}
}
public RouteDto(Route route)
{
_RoutesID = route.ID;
_OperatorId = route.OperatorId;
_DeparturePortId = route.DeparturePortId;
_ArriavlPortId = route.ArriavlPortId;
_IsActive = route.IsActive;
}
public void DoUpdate(int ID, int operatorId, string departurePortId, string arrivalPortId)
{
Route route = new Route().GetById(ID, true);
route.OperatorId = operatorId;
route.DeparturePortId = departurePortId;
route.ArriavlPortId = arrivalPortId;
route.Update();
}
public static Route GetRouteByPortId(string depPortId, string arrPortId, int operatorId)
{
OQL oql = new OQL(typeof(Route));
if (string.IsNullOrEmpty(depPortId) || string.IsNullOrEmpty(arrPortId) || operatorId <= 0)
return null;
oql.AddCondition(Condition.Eq(Route.Properties.OperatorId, operatorId));
oql.AddCondition(Condition.Eq(Route.Properties.DeparturePortId, depPortId));
oql.AddCondition(Condition.Eq(Route.Properties.ArriavlPortId, arrPortId));
RouteList list = new Route().GetList(oql);
if (list.Count == 1)
return list[0];
else if (list.Count > 1)
throw new Exception("Duplicate route with same operator, departure port and arrival port found.");
else
return null;
}
protected void lvAccommodation_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
RouteOrder r = (RouteOrder)(dataItem.DataItem);
Label lblRoute = (Label)(dataItem.FindControl("lblRoute"));
Route route = new Route().GetRouteBySchedule(r.ScheduleId.Value);
lblRoute.Text = route.DeparturePort.PortName+ " - " + route.ArriavlPort.PortName;
GridView gvAccommodation = (GridView)(dataItem.FindControl("gvAccommodation"));
if (gvAccommodation != null)
{
IList<FareType> ftList = new FareType().GetAccommodationTypeBySchedule(r.ScheduleId.Value);
gvAccommodation.DataSource = ftList;
gvAccommodation.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!(Session[ByteCore.FerryBooking.Web.SessionVariable.Step1UserInput] is Step1UserInput))
{
Response.Redirect("Default.aspx");
}
Step1UserInput step1 = (Step1UserInput)Session[SessionVariable.Step1UserInput];
if (!Page.IsPostBack)
{
RouteList routelist = new RouteList();
Route r1 = new Route().GetById(step1.Route1Id,false);
routelist.Add(r1);
Hashtable htSchedulePreLoad = new Hashtable();
htSchedulePreLoad.Add(r1.ID.ToString(),InitRouteSchedule(step1.Route1Id));
if (step1.Route2Id>0)
{
Route r2 = new Route().GetById(step1.Route2Id, false);
routelist.Add(r2);
htSchedulePreLoad.Add(r2.ID.ToString(), InitRouteSchedule(step1.Route2Id));
}
if (step1.Route3Id>0)
{
Route r3 = new Route().GetById(step1.Route3Id, false);
routelist.Add(r3);
htSchedulePreLoad.Add(r3.ID.ToString(), InitRouteSchedule(step1.Route3Id));
}
if (step1.Route4Id > 0)
{
Route r4 = new Route().GetById(step1.Route4Id, false);
routelist.Add(r4);
htSchedulePreLoad.Add(r4.ID.ToString(), InitRouteSchedule(step1.Route4Id));
}
Session[SessionVariable.RouteSchedules] = htSchedulePreLoad;
this.lvSchedule.DataSource = routelist;
lvSchedule.DataBind();
RouteOrderPassengerDetailList passengerList = new RouteOrderPassengerDetailList();
for (int i = 0; i < step1.PassengersCount; i++)
{
passengerList.Add(new RouteOrderPassengerDetail());
}
lvPassenger.DataSource = passengerList;
lvPassenger.DataBind();
lvTravelMethod.DataSource = routelist;
lvTravelMethod.DataBind();
}
}
private void UpdateRoute(int id)
{
int operatorId;
string departurePortId;
string arrivalPortId;
DropDownList ddlOperator = (DropDownList)this.FV_Route.FindControl("ddlOperator");
DropDownList ddlDeparturePort = (DropDownList)this.FV_Route.FindControl("ddlDeparturePort");
DropDownList ddlArrivalPort = (DropDownList)this.FV_Route.FindControl("ddlArrivalPort");
operatorId = (ddlOperator == null) ? 0 : Convert.ToInt32(ddlOperator.SelectedValue);
departurePortId = (ddlDeparturePort == null) ? "" : ddlDeparturePort.SelectedValue;
arrivalPortId = (ddlArrivalPort == null) ? "" : ddlArrivalPort.SelectedValue;
Route route = new Route();
route.DoUpdate(id, operatorId, departurePortId, arrivalPortId);
BindList();
if (ddlOperator != null)
ddlOperator.SelectedIndex = 0;
if (ddlDeparturePort != null)
ddlDeparturePort.SelectedIndex = 0;
if (ddlArrivalPort != null)
ddlArrivalPort.SelectedIndex = 0;
this.lblMessage.Text = "Update successfully";
this.lblMessage.ForeColor = Color.Green;
}
private void InsertRoute()
{
int operatorId;
string departurePortId;
string arrivalPortId;
DropDownList ddlOperator = (DropDownList)this.FV_Route.FindControl("ddlOperator");
DropDownList ddlDeparturePort = (DropDownList)this.FV_Route.FindControl("ddlDeparturePort");
DropDownList ddlArrivalPort = (DropDownList)this.FV_Route.FindControl("ddlArrivalPort");
operatorId = (ddlOperator == null) ? 0 : Convert.ToInt32(ddlOperator.SelectedValue);
departurePortId = (ddlDeparturePort == null) ? "" : ddlDeparturePort.SelectedValue;
arrivalPortId = (ddlArrivalPort == null) ? "" : ddlArrivalPort.SelectedValue;
_route = new Route();
_route.OperatorId = operatorId;
_route.DeparturePortId = departurePortId;
_route.ArriavlPortId = arrivalPortId;
Route.DoInsert(_route);
BindList();
if (ddlOperator != null)
ddlOperator.SelectedIndex = 0;
if (ddlDeparturePort != null)
ddlDeparturePort.SelectedIndex = 0;
if (ddlArrivalPort != null)
ddlArrivalPort.SelectedIndex = 0;
this.lblMessage.Text = "Insert successfully";
this.lblMessage.ForeColor = Color.Green;
}
public DataTable ImportFareDumpFile(string fileName)
{
DataTable dt = null;
DataTable dtErrInfo = new DataTable();
dtErrInfo.Columns.Add("RowNumber", typeof(int));
dtErrInfo.Columns.Add("ErrColumnName", typeof(string));
dtErrInfo.Columns.Add("ErrColumnData", typeof(string));
dtErrInfo.Columns.Add("ErrDescription", typeof(string));
dt = this.GetDataTableFromExcel(fileName);
//Check Column in imported Excel file match the template, no missing column
string columnNames;
columnNames = ",Dep,Arr,Dreg,Areg,Category,Facility,Minlength,Maxlength,Amount,Byfootamt,Startdate,Enddate,Recid,Description,";
int rowNumber = 0;
foreach (DataColumn column in dt.Columns)
{
if (columnNames.IndexOf("," + column.ColumnName + ",") < 0)
dtErrInfo.Rows.Add(new object[] { rowNumber, column.ColumnName, "Template Error", "The column in XLS file does not match orinigal template" });
}
if (dtErrInfo.Rows.Count > 0)
return dtErrInfo;
//Check if column “Dep” and “Arr”(Port Code) exists in Port table.
//If not then create port
foreach (DataRow row in dt.Rows)
{
string depPortId = row["Dep"].ToString();
string arrPortId = row["Arr"].ToString();
if (string.IsNullOrEmpty(depPortId) || string.IsNullOrEmpty(arrPortId))
continue;
Port dport = new Port().GetById(depPortId, false);
if (dport == null)
{
Port dp = new Port();
dp.DoInsert(depPortId, depPortId);
}
Port aport = new Port().GetById(arrPortId, false);
if (aport == null)
{
Port ap = new Port();
ap.DoInsert(arrPortId, arrPortId);
}
//Select distinct column “Dep” and “Arr” from Route table, if not exist, insert into Route table
Company c = Company.GetCompanyByShortName("AMHS");
int operatorId = c.ID;
Route r = Route.GetRouteByPortId(depPortId, arrPortId, operatorId);
int routeId;
if (r == null)
{
Route newRoute = new Route();
newRoute.OperatorId = operatorId;
newRoute.DeparturePortId = depPortId;
newRoute.ArriavlPortId = arrPortId;
newRoute.IsActive = true;
Route.DoInsert(newRoute);
routeId = newRoute.ID;
}
else
{
routeId = r.ID;
}
//Create a record in Fare table (RouteID, StartDate, EndDate)
string strStartDate = row["Startdate"].ToString();
string strEndDate = row["Enddate"].ToString();
DateTime startDate = DateTime.MaxValue;
DateTime endDate = DateTime.MaxValue;
if (string.IsNullOrEmpty(strStartDate) || string.IsNullOrEmpty(strEndDate))
{
dtErrInfo.Rows.Add(new object[] { rowNumber, "StartDate/EndDate", "Null", " StartDate/EndDate is worng format or value" });
continue;
}
if (DateTime.TryParse(strStartDate, out startDate) && DateTime.TryParse(strEndDate, out endDate))
{
int fareId;
Fare existingFare = Fare.GetFareByRouteAndDateRange(routeId, startDate, endDate);
if (existingFare == null)
{
Fare newFare = new Fare();
newFare.RoutesID = routeId;
newFare.StartDate = startDate;
newFare.EndDate = endDate;
Fare.DoInsert(newFare);
fareId = newFare.ID;
}
else
{
fareId = existingFare.ID;
}
string strCategory = row["Category"].ToString();
FareCategory fareCategory = FareCategory.GetCategoryByName(strCategory);
if (fareCategory == null)
{
dtErrInfo.Rows.Add(new object[] { rowNumber, "Fare Category", "Null", " Fare Category not found" });
continue;
}
int categoryId = fareCategory.ID;
string strFacility = row["Facility"].ToString();
string strDescription = row["Description"].ToString();
if (!string.IsNullOrEmpty(strFacility) && !string.IsNullOrEmpty(strDescription))
{
int fareTypeId = 0;
int minLength = 0;
int maxLength = 0;
decimal amount = 0.0m;
decimal byFootAmount = 0.0m;
string strMinLength = row["Minlength"].ToString();
string strMaxLength = row["Maxlength"].ToString();
string strAmount = row["Amount"].ToString();
string strByFootAmount = row["Byfootamt"].ToString();
decimal.TryParse(strByFootAmount, out byFootAmount);
FareType existingFareType = FareType.GetFareTypeByValue(operatorId, categoryId, strFacility, strDescription);
if (existingFareType == null)
{
if (decimal.TryParse(strAmount, out amount))
{
int.TryParse(strMinLength, out minLength);
int.TryParse(strMaxLength, out maxLength);
if (strCategory == EnumFareCategory.CARDECK.ToString())
{
VehicleType newVehicleType = new VehicleType();
newVehicleType.OperatorId = operatorId;
newVehicleType.CategoryId = categoryId;
newVehicleType.FareTypeName = strFacility;
newVehicleType.FareTypeDescription = strDescription;
newVehicleType.MinLegth = minLength;
newVehicleType.MaxLegth = maxLength;
newVehicleType.ByFootAmount = byFootAmount;
VehicleType.DoInsert(newVehicleType);
fareTypeId = newVehicleType.ID;
}
else if (strCategory == EnumFareCategory.PASSAGE.ToString())
{
int defaultMinAge = 0;
int defaultMaxAge = 0;
switch (strFacility.ToUpper())
{
case "ADT":
defaultMinAge = 12;
defaultMaxAge = 65;
break;
case "CHD":
defaultMinAge = 6;
defaultMaxAge = 12;
break;
case "SRC":
defaultMinAge = 65;
defaultMaxAge = 99;
break;
case "UND":
defaultMinAge = 0;
defaultMaxAge = 6;
break;
default:
break;
}
PassengerType newPassegerType = new PassengerType();
newPassegerType.OperatorId = operatorId;
newPassegerType.CategoryId = categoryId;
newPassegerType.FareTypeName = strFacility;
newPassegerType.FareTypeDescription = strDescription;
if (minLength == 0)
{
minLength = defaultMinAge;
newPassegerType.MinAge = defaultMinAge;
}
else
newPassegerType.MinAge = minLength;
if (maxLength == 0)
{
maxLength = defaultMaxAge;
newPassegerType.MaxAge = defaultMaxAge;
}
else
newPassegerType.MaxAge = maxLength;
PassengerType.DoInsert(newPassegerType);
fareTypeId = newPassegerType.ID;
}
else
{
FareType newFareType = new FareType();
newFareType.OperatorId = operatorId;
newFareType.CategoryId = categoryId;
newFareType.FareTypeName = strFacility;
newFareType.FareTypeDescription = strDescription;
FareType.DoInsert(newFareType);
fareTypeId = newFareType.ID;
}
}
else
{
dtErrInfo.Rows.Add(new object[] { rowNumber, "Minlength/Maxlength/Amount", "Null", "Minlength/Maxlength/Amount is worng format or value" });
continue;
}
}
else
{
int.TryParse(strMinLength, out minLength);
int.TryParse(strMaxLength, out maxLength);
decimal.TryParse(strAmount, out amount);
fareTypeId = existingFareType.ID;
}
if (FareItem.GetFareItemByValues(fareTypeId, fareId, minLength, maxLength, amount) == null)
{
FareItem newFareItem = new FareItem();
newFareItem.FareTypeId = fareTypeId;
newFareItem.FareId = fareId;
newFareItem.RangeStart = minLength;
newFareItem.RangeEnd = maxLength;
newFareItem.Amount = amount;
newFareItem.ByFootAmount = byFootAmount;
FareItem.DoInsert(newFareItem);
}
}
else
{
dtErrInfo.Rows.Add(new object[] { rowNumber, "Facility/Description", "Null", " Facility/Description is worng format or value" });
continue;
}
}
else
{
dtErrInfo.Rows.Add(new object[] { rowNumber, "StartDate/EndDate", "Null", " StartDate/EndDate is worng format or value" });
continue;
}
}
return dtErrInfo;
}
private void BindRoute()
{
int operatorInd = Convert.ToInt32(this.ddlOperator.SelectedValue);
Route r = new Route();
RouteList rlist = r.GetRouteList(operatorInd);
this.ddlRoute.DataSource = rlist;
this.ddlRoute.DataTextField = "FullName";
this.ddlRoute.DataValueField = "ID";
this.ddlRoute.DataBind();
this.ddlRoute.Items.Insert(0, new ListItem("-- Show All --", "0"));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
List<KeyValuePair<string, string>> routeList = new Route().GetKeyValueList();
routeList.Insert(0, new KeyValuePair<string, string>("0", "(select outward route)"));
ddlRoute1.DataSource = routeList;
ddlRoute1.DataValueField = "Key";
ddlRoute1.DataTextField = "Value";
ddlRoute1.DataBind();
ddlRoute1.SelectedIndex = 0;
List<KeyValuePair<string, string>> routeEmptyList = new List<KeyValuePair<string,string>>();
routeEmptyList.Insert(0, new KeyValuePair<string, string>("0", "(select return route)"));
ddlRoute2.DataSource = routeEmptyList;
ddlRoute2.DataValueField = "Key";
ddlRoute2.DataTextField = "Value";
ddlRoute2.DataBind();
ddlRoute2.SelectedIndex = 0;
ddlRoute3.DataSource = routeEmptyList;
ddlRoute3.DataValueField = "Key";
ddlRoute3.DataTextField = "Value";
ddlRoute3.DataBind();
ddlRoute3.SelectedIndex = 0;
ddlRoute4.DataSource = routeEmptyList;
ddlRoute4.DataValueField = "Key";
ddlRoute4.DataTextField = "Value";
ddlRoute4.DataBind();
ddlRoute4.SelectedIndex = 0;
List<KeyValuePair<int, string>> passengerList = new List<KeyValuePair<int,string>>();
passengerList.Add(new KeyValuePair<int, string>(0, "Select total passengers"));
for (int i = 1; i < 10; i++)
{
passengerList.Add(new KeyValuePair<int, string>(i, i.ToString() + " passengers"));
}
List<KeyValuePair<int, string>> vehicleList = new List<KeyValuePair<int, string>>();
vehicleList.Add(new KeyValuePair<int, string>(0, "Select total vehicles"));
for (int i = 1; i < 10; i++)
{
vehicleList.Add(new KeyValuePair<int, string>(i, i.ToString() + " vehicles"));
}
ddlPassengers.DataSource = passengerList;
ddlPassengers.DataValueField = "Key";
ddlPassengers.DataTextField = "Value";
ddlPassengers.DataBind();
ddlPassengers.SelectedIndex = 0;
ddlVehicles.DataSource = vehicleList;
ddlVehicles.DataValueField = "Key";
ddlVehicles.DataTextField = "Value";
ddlVehicles.DataBind();
ddlVehicles.SelectedIndex = 0;
string jscript;
jscript = string.Format(
@"
var route1 = document.getElementById('{0}');
var route2 = document.getElementById('{1}');
var route3 = document.getElementById('{2}');
var route4 = document.getElementById('{3}');
var passengers = document.getElementById('{4}');
var vehicles = document.getElementById('{5}');
route3.style.display = 'none';
route4.style.display = 'none';
var singleRb = document.getElementById('{6}');
var returnRb = document.getElementById('{7}');
var multiRb = document.getElementById('{8}');
"
, this.ddlRoute1.ClientID
,this.ddlRoute2.ClientID
,this.ddlRoute3.ClientID
,this.ddlRoute4.ClientID
,this.ddlPassengers.ClientID
,this.ddlVehicles.ClientID
,this.rbSingle.ClientID
,this.rbReturn.ClientID
,this.rbMulti.ClientID
);
jscript += "initRouteDataSource();";
Page.ClientScript.RegisterStartupScript(this.GetType(), "StartUp", jscript, true);
rbReturn.Attributes.Add("onChange", "javascript:return on_rbReturn();");
rbSingle.Attributes.Add("onChange", "javascript:return on_rbSingle();");
rbMulti.Attributes.Add("onChange", "javascript:return on_rbMulti();");
ddlRoute1.Attributes.Add("onChange", "javascript:return on_route1_change();");
}
}
public void DoDelete(int ID)
{
Route route = new Route().GetById(ID, false);
route.Delete();
}
public static void DoInsert(Route route)
{
route.Create();
}
public Route GetRouteBySchedule(int scheduleId)
{
Schedule schedule = new Schedule().GetById(scheduleId, false);
Fare fare = new Fare().GetById(schedule.FareId.Value, false);
Route route = new Route().GetById(fare.RoutesID.Value, false);
return route;
}