protected void uiLinkButtonSave_Click(object sender, EventArgs e)
{
if (!IsEdit)
{
CurrentSector = new Sector();
CurrentSector.AddNew();
}
CurrentSector.AirCraft_AirPlaneID = 1;
CurrentSector.FlightNo = uiTextBoxSectorFlightNo.Text;
CurrentSector.SectorDate = DateTime.ParseExact(uiTextBoxDate.Text, "dd/MM/yyyy", null);
CurrentSector.IsPAX = true;
CurrentSector.From_AirportID = Convert.ToInt32(uiDropDownListSectorFrom.SelectedValue);
CurrentSector.To_AirportID = Convert.ToInt32(uiDropDownListSectorTo.SelectedValue);
CurrentSector.Save();
if (IsEdit)
{
SectorPilot Oldpilots = new SectorPilot();
Oldpilots.GetPilotBySectorID(CurrentSector.SectorID);
Oldpilots.DeleteAll();
Oldpilots.Save();
SectorCrew OldCrew = new SectorCrew();
OldCrew.GetCrewBySectorID(CurrentSector.SectorID);
OldCrew.DeleteAll();
OldCrew.Save();
}
CurrentPilots = new SectorPilot();
for(int i=0 ;i< CurrentPilotsTable.Rows.Count ; i++)
{
CurrentPilots.AddNew();
CurrentPilots.SectorID = CurrentSector.SectorID;
CurrentPilots.PilotID = Convert.ToInt32(CurrentPilotsTable.Rows[i]["PilotID"]);
// CurrentPilots.PositionID = Convert.ToInt32(CurrentPilotsTable.Rows[i]["PositionID"]);
}
CurrentPilots.Save();
CurrentCrew = new SectorCrew();
for (int i = 0; i < CurrentCrewTable.Rows.Count; i++)
{
CurrentCrew.AddNew();
CurrentCrew.SectorID = CurrentSector.SectorID;
CurrentCrew.CrewID = Convert.ToInt32(CurrentCrewTable.Rows[i]["CrewID"]);
// CurrentCrew.PositionID = Convert.ToInt32(CurrentCrewTable.Rows[i]["PositionID"]);
}
CurrentCrew.Save();
if (MasterSector != null)
{
MasterSector.ReturnSectorID = CurrentSector.SectorID;
CurrentSector.IsReturnSector = true;
MasterSector.Save();
CurrentSector.Save();
}
BindReportData();
uiPanelViewAll.Visible = true;
uiPanelEdit.Visible = false;
MasterSector = null;
CurrentSector = null;
CurrentCrew = null;
CurrentPilots = null;
CurrentCrewTable = null;
CurrentPilotsTable = null;
}
protected void uiLinkButtonSaveSector_Click(object sender, EventArgs e)
{
if (CurrentSector != null)
{
Sector objData = CurrentSector;
objData.IsPAX = false;
if (!string.IsNullOrEmpty(uiTextBoxFule.Text))
{
objData.FuleUplifted = Convert.ToInt32(uiTextBoxFule.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxActualBurn.Text))
{
objData.ActualBurnOff = Convert.ToInt32(uiTextBoxActualBurn.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxPlanBurnOff.Text))
{
objData.StandardBurnOff = Convert.ToInt32(uiTextBoxPlanBurnOff.Text);
}
TimeSpan STD = new TimeSpan(Convert.ToInt32(uiDropDownListSTDHours.Text), Convert.ToInt32(uiDropDownListSTDMins.Text), 0);
objData.STD = Convert.ToDateTime(STD.ToString());
TimeSpan ATD = new TimeSpan(Convert.ToInt32(uiDropDownListATDHours.Text), Convert.ToInt32(uiDropDownListATDMins.Text), 0);
objData.ATD = Convert.ToDateTime(ATD.ToString());
TimeSpan ATA = new TimeSpan(Convert.ToInt32(uiDropDownListATAHours.Text), Convert.ToInt32(uiDropDownListATAMins.Text), 0);
if (Convert.ToInt32(uiDropDownListATAHours.Text) < Convert.ToInt32(uiDropDownListATDHours.Text))
{
objData.ATA = Convert.ToDateTime(ATA.ToString()).AddDays(1);
}
else
{
objData.ATA = Convert.ToDateTime(ATA.ToString());
}
TimeSpan OFF = new TimeSpan(Convert.ToInt32(uiDropDownListOFFHours.Text), Convert.ToInt32(uiDropDownListOFFMins.Text), 0);
objData.ChoxOff = Convert.ToDateTime(OFF.ToString());
TimeSpan On = new TimeSpan(Convert.ToInt32(uiDropDownListOnHours.Text), Convert.ToInt32(uiDropDownListOnMins.Text), 0);
if (Convert.ToInt32(uiDropDownListOnHours.Text) < Convert.ToInt32(uiDropDownListOFFHours.Text))
{
objData.ChoxOn = Convert.ToDateTime(On.ToString()).AddDays(1);
}
else
{
objData.ChoxOn = Convert.ToDateTime(On.ToString());
}
TimeSpan STA = new TimeSpan(Convert.ToInt32(uiDropDownListSTAHours.Text), Convert.ToInt32(uiDropDownListSTAMins.Text), 0);
if (Convert.ToInt32(uiDropDownListSTAHours.Text) < Convert.ToInt32(uiDropDownListSTDHours.Text))
{
objData.STA = Convert.ToDateTime(STA.ToString()).AddDays(1);
}
else
{
objData.STA = Convert.ToDateTime(STA.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListDelay1Code.SelectedValue))
{
objData.DepDelayID1 = Convert.ToInt32(uiDropDownListDelay1Code.SelectedValue);
TimeSpan Delay1 = new TimeSpan(Convert.ToInt32(uiDropDownListDelay1Hours.Text), Convert.ToInt32(uiDropDownListDelay1Mins.Text), 0);
objData.DepDelayTime1 = Convert.ToDateTime(Delay1.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListDelay2Code.SelectedValue))
{
objData.DepDelayID2 = Convert.ToInt32(uiDropDownListDelay2Code.SelectedValue);
TimeSpan Delay2 = new TimeSpan(Convert.ToInt32(uiDropDownListDelay2Hours.Text), Convert.ToInt32(uiDropDownListDelay2Mins.Text), 0);
objData.DepDelayTime2 = Convert.ToDateTime(Delay2.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListDelay3Code.SelectedValue))
{
objData.DepDelayID3 = Convert.ToInt32(uiDropDownListDelay3Code.SelectedValue);
TimeSpan Delay3 = new TimeSpan(Convert.ToInt32(uiDropDownListDelay3Hours.Text), Convert.ToInt32(uiDropDownListDelay3Mins.Text), 0);
objData.DepDelayTime3 = Convert.ToDateTime(Delay3.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListArrDelay1Code.SelectedValue))
{
objData.ArrDelayID1 = Convert.ToInt32(uiDropDownListArrDelay1Code.SelectedValue);
TimeSpan ArrDelay1 = new TimeSpan(Convert.ToInt32(uiDropDownListArrDelay1Hours.Text), Convert.ToInt32(uiDropDownListArrDelay1Mins.Text), 0);
objData.ArrDelayTime1 = Convert.ToDateTime(ArrDelay1.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListArrDelay2Code.SelectedValue))
{
objData.ArrDelayID2 = Convert.ToInt32(uiDropDownListArrDelay2Code.SelectedValue);
TimeSpan ArrDelay2 = new TimeSpan(Convert.ToInt32(uiDropDownListArrDelay2Hours.Text), Convert.ToInt32(uiDropDownListArrDelay2Mins.Text), 0);
objData.ArrDelayTime2 = Convert.ToDateTime(ArrDelay2.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListArrDelay3Code.SelectedValue))
{
objData.ArrDelayID3 = Convert.ToInt32(uiDropDownListArrDelay3Code.SelectedValue);
TimeSpan ArrDelay3 = new TimeSpan(Convert.ToInt32(uiDropDownListArrDelay3Hours.Text), Convert.ToInt32(uiDropDownListArrDelay3Mins.Text), 0);
objData.ArrDelayTime3 = Convert.ToDateTime(ArrDelay3.ToString());
}
TimeSpan Day = new TimeSpan(Convert.ToInt32(uiDropDownListDayHours.Text), Convert.ToInt32(uiDropDownListDayMins.Text), 0);
objData.FlyAtDay = Convert.ToDateTime(Day.ToString());
TimeSpan Night = new TimeSpan(Convert.ToInt32(uiDropDownListNightHours.Text), Convert.ToInt32(uiDropDownListNightMins.Text), 0);
objData.FlyAtNight = Convert.ToDateTime(Night.ToString());
if (!string.IsNullOrEmpty(uiTextBoxDepFuel.Text))
{
objData.DepFule = Convert.ToInt32(uiTextBoxDepFuel.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxArrFuel.Text))
{
objData.ArrFule = Convert.ToInt32(uiTextBoxArrFuel.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxNoOFPax_A.Text))
{
objData.NoOfPax_A = Convert.ToInt32(uiTextBoxNoOFPax_A.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxNoOFPax_CH.Text))
{
objData.NoOfPax_C = Convert.ToInt32(uiTextBoxNoOFPax_CH.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxNoOFPax_I.Text))
{
objData.NoOfPax_I = Convert.ToInt32(uiTextBoxNoOFPax_I.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxTOW.Text))
{
objData.TOW = Convert.ToInt32(uiTextBoxTOW.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxZFW.Text))
{
objData.ZFW = Convert.ToInt32(uiTextBoxZFW.Text);
}
objData.Save();
}
else
{
Sector objData = new Sector();
objData.AddNew();
objData.IsPAX = false;
if (!string.IsNullOrEmpty(uiTextBoxFule.Text))
{
objData.FuleUplifted = Convert.ToInt32(uiTextBoxFule.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxActualBurn.Text))
{
objData.ActualBurnOff = Convert.ToInt32(uiTextBoxActualBurn.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxPlanBurnOff.Text))
{
objData.StandardBurnOff = Convert.ToInt32(uiTextBoxPlanBurnOff.Text);
}
TimeSpan STD = new TimeSpan(Convert.ToInt32(uiDropDownListSTDHours.Text), Convert.ToInt32(uiDropDownListSTDMins.Text), 0);
objData.STD = Convert.ToDateTime(STD.ToString());
TimeSpan ATD = new TimeSpan(Convert.ToInt32(uiDropDownListATDHours.Text), Convert.ToInt32(uiDropDownListATDMins.Text), 0);
objData.ATD = Convert.ToDateTime(ATD.ToString());
TimeSpan ATA = new TimeSpan(Convert.ToInt32(uiDropDownListATAHours.Text), Convert.ToInt32(uiDropDownListATAMins.Text), 0);
if (Convert.ToInt32(uiDropDownListATAHours.Text) < Convert.ToInt32(uiDropDownListATDHours.Text))
{
objData.ATA = Convert.ToDateTime(ATA.ToString()).AddDays(1);
}
else
{
objData.ATA = Convert.ToDateTime(ATA.ToString());
}
TimeSpan OFF = new TimeSpan(Convert.ToInt32(uiDropDownListOFFHours.Text), Convert.ToInt32(uiDropDownListOFFMins.Text), 0);
objData.ChoxOff = Convert.ToDateTime(OFF.ToString());
TimeSpan On = new TimeSpan(Convert.ToInt32(uiDropDownListOnHours.Text), Convert.ToInt32(uiDropDownListOnMins.Text), 0);
if (Convert.ToInt32(uiDropDownListOnHours.Text) < Convert.ToInt32(uiDropDownListOFFHours.Text))
{
objData.ChoxOn = Convert.ToDateTime(On.ToString()).AddDays(1);
}
else
{
objData.ChoxOn = Convert.ToDateTime(On.ToString());
}
TimeSpan STA = new TimeSpan(Convert.ToInt32(uiDropDownListSTAHours.Text), Convert.ToInt32(uiDropDownListSTAMins.Text), 0);
if (Convert.ToInt32(uiDropDownListSTAHours.Text) < Convert.ToInt32(uiDropDownListSTDHours.Text))
{
objData.STA = Convert.ToDateTime(STA.ToString()).AddDays(1);
}
else
{
objData.STA = Convert.ToDateTime(STA.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListDelay1Code.SelectedValue))
{
objData.DepDelayID1 = Convert.ToInt32(uiDropDownListDelay1Code.SelectedValue);
TimeSpan Delay1 = new TimeSpan(Convert.ToInt32(uiDropDownListDelay1Hours.Text), Convert.ToInt32(uiDropDownListDelay1Mins.Text), 0);
objData.DepDelayTime1 = Convert.ToDateTime(Delay1.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListDelay2Code.SelectedValue))
{
objData.DepDelayID2 = Convert.ToInt32(uiDropDownListDelay2Code.SelectedValue);
TimeSpan Delay2 = new TimeSpan(Convert.ToInt32(uiDropDownListDelay2Hours.Text), Convert.ToInt32(uiDropDownListDelay2Mins.Text), 0);
objData.DepDelayTime2 = Convert.ToDateTime(Delay2.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListDelay3Code.SelectedValue))
{
objData.DepDelayID3 = Convert.ToInt32(uiDropDownListDelay3Code.SelectedValue);
TimeSpan Delay3 = new TimeSpan(Convert.ToInt32(uiDropDownListDelay3Hours.Text), Convert.ToInt32(uiDropDownListDelay3Mins.Text), 0);
objData.DepDelayTime3 = Convert.ToDateTime(Delay3.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListArrDelay1Code.SelectedValue))
{
objData.ArrDelayID1 = Convert.ToInt32(uiDropDownListArrDelay1Code.SelectedValue);
TimeSpan ArrDelay1 = new TimeSpan(Convert.ToInt32(uiDropDownListArrDelay1Hours.Text), Convert.ToInt32(uiDropDownListArrDelay1Mins.Text), 0);
objData.ArrDelayTime1 = Convert.ToDateTime(ArrDelay1.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListArrDelay2Code.SelectedValue))
{
objData.ArrDelayID2 = Convert.ToInt32(uiDropDownListArrDelay2Code.SelectedValue);
TimeSpan ArrDelay2 = new TimeSpan(Convert.ToInt32(uiDropDownListArrDelay2Hours.Text), Convert.ToInt32(uiDropDownListArrDelay2Mins.Text), 0);
objData.ArrDelayTime2 = Convert.ToDateTime(ArrDelay2.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListArrDelay3Code.SelectedValue))
{
objData.ArrDelayID3 = Convert.ToInt32(uiDropDownListArrDelay3Code.SelectedValue);
TimeSpan ArrDelay3 = new TimeSpan(Convert.ToInt32(uiDropDownListArrDelay3Hours.Text), Convert.ToInt32(uiDropDownListArrDelay3Mins.Text), 0);
objData.ArrDelayTime3 = Convert.ToDateTime(ArrDelay3.ToString());
}
TimeSpan Day = new TimeSpan(Convert.ToInt32(uiDropDownListDayHours.Text), Convert.ToInt32(uiDropDownListDayMins.Text), 0);
objData.FlyAtDay = Convert.ToDateTime(Day.ToString());
TimeSpan Night = new TimeSpan(Convert.ToInt32(uiDropDownListNightHours.Text), Convert.ToInt32(uiDropDownListNightMins.Text), 0);
objData.FlyAtNight = Convert.ToDateTime(Night.ToString());
if (!string.IsNullOrEmpty(uiTextBoxDepFuel.Text))
{
objData.DepFule = Convert.ToInt32(uiTextBoxDepFuel.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxArrFuel.Text))
{
objData.ArrFule = Convert.ToInt32(uiTextBoxArrFuel.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxNoOFPax_A.Text))
{
objData.NoOfPax_A = Convert.ToInt32(uiTextBoxNoOFPax_A.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxNoOFPax_CH.Text))
{
objData.NoOfPax_C = Convert.ToInt32(uiTextBoxNoOFPax_CH.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxNoOFPax_I.Text))
{
objData.NoOfPax_I = Convert.ToInt32(uiTextBoxNoOFPax_I.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxTOW.Text))
{
objData.TOW = Convert.ToInt32(uiTextBoxTOW.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxZFW.Text))
{
objData.ZFW = Convert.ToInt32(uiTextBoxZFW.Text);
}
objData.Save();
}
ClearSectorFields();
Response.Redirect("~/Operation/SectorsList.aspx?" + Request.QueryString.ToString());
}
protected void uiLinkButtonSaveSector_Click(object sender, EventArgs e)
{
if (CurrentSector != null)
{
Sector objData = CurrentSector;
//objData.ReportID = CurrentFlightReport.ReportID;
objData.SectorDate = DateTime.ParseExact(uiTextBoxDate.Text, "dd/MM/yyyy", null);
objData.From_AirportID = Convert.ToInt32(uiDropDownListSectorFrom.SelectedValue);
objData.To_AirportID = Convert.ToInt32(uiDropDownListSectorTo.SelectedValue);
objData.FlightNo = uiTextBoxSectorFlightNo.Text;
objData.IsHeavy = uiCheckBoxIsHeavy.Checked;
objData.AirCraft_AirPlaneID = Convert.ToInt32(uiDropDownListAirCraftRegistration.SelectedValue);
objData.IsPAX = false;
TimeSpan STD = new TimeSpan(Convert.ToInt32(uiDropDownListSTDHours.Text), Convert.ToInt32(uiDropDownListSTDMins.Text), 0);
objData.STD = Convert.ToDateTime(STD.ToString());
TimeSpan STA = new TimeSpan(Convert.ToInt32(uiDropDownListSTAHours.Text), Convert.ToInt32(uiDropDownListSTAMins.Text), 0);
if (Convert.ToInt32(uiDropDownListSTAHours.Text) < Convert.ToInt32(uiDropDownListSTDHours.Text))
{
objData.STA = Convert.ToDateTime(STA.ToString()).AddDays(1);
}
else
{
objData.STA = Convert.ToDateTime(STA.ToString());
}
if (uiDropDownListClients.SelectedIndex > -1)
{
if (uiDropDownListClients.SelectedValue != "0")
objData.ClientID = Convert.ToInt32(uiDropDownListClients.SelectedValue);
else
objData.SetColumnNull("ClientID");
}
objData.Save();
}
else
{
Sector objData = new Sector();
objData.AddNew();
//objData.ReportID = CurrentFlightReport.ReportID;
objData.SectorDate = DateTime.ParseExact(uiTextBoxDate.Text, "dd/MM/yyyy", null);
objData.From_AirportID = Convert.ToInt32(uiDropDownListSectorFrom.SelectedValue);
objData.To_AirportID = Convert.ToInt32(uiDropDownListSectorTo.SelectedValue);
objData.AirCraft_AirPlaneID = Convert.ToInt32(uiDropDownListAirCraftRegistration.SelectedValue);
objData.FlightNo = uiTextBoxSectorFlightNo.Text;
objData.IsHeavy = uiCheckBoxIsHeavy.Checked;
objData.IsPAX = false;
TimeSpan STD = new TimeSpan(Convert.ToInt32(uiDropDownListSTDHours.Text), Convert.ToInt32(uiDropDownListSTDMins.Text), 0);
objData.STD = Convert.ToDateTime(STD.ToString());
TimeSpan STA = new TimeSpan(Convert.ToInt32(uiDropDownListSTAHours.Text), Convert.ToInt32(uiDropDownListSTAMins.Text), 0);
if (Convert.ToInt32(uiDropDownListSTAHours.Text) < Convert.ToInt32(uiDropDownListSTDHours.Text))
{
objData.STA = Convert.ToDateTime(STA.ToString()).AddDays(1);
}
else
{
objData.STA = Convert.ToDateTime(STA.ToString());
}
if (uiDropDownListClients.SelectedIndex > -1)
{
if (uiDropDownListClients.SelectedValue != "0")
objData.ClientID = Convert.ToInt32(uiDropDownListClients.SelectedValue);
else
objData.SetColumnNull("ClientID");
}
objData.Save();
CurrentSector = null;
}
ClearSectorFields();
Response.Redirect("~/Operation/SectorsList.aspx?" + Request.QueryString.ToString());
}
protected void uiLinkButtonSaveSector_Click(object sender, EventArgs e)
{
if (CurrentSector != null)
{
Sector objData = CurrentSector;
objData.ReportID = CurrentFlightReport.ReportID;
objData.From_AirportID = Convert.ToInt32(uiDropDownListSectorFrom.SelectedValue);
objData.To_AirportID = Convert.ToInt32(uiDropDownListSectorTo.SelectedValue);
objData.FlightNo = CurrentFlightReport.FlightNo;
objData.IsPAX = true;
objData.Save();
}
else
{
Sector objData = new Sector();
objData.AddNew();
objData.ReportID = CurrentFlightReport.ReportID;
objData.From_AirportID = Convert.ToInt32(uiDropDownListSectorFrom.SelectedValue);
objData.To_AirportID = Convert.ToInt32(uiDropDownListSectorTo.SelectedValue);
objData.FlightNo = CurrentFlightReport.FlightNo;
objData.IsPAX = true;
objData.Save();
}
ClearSectorFields();
CurrentSector = null;
BindSectors();
}
/*****************************************************************************************/
/**************** Sector section ********************/
protected void uiLinkButtonSaveSector_Click(object sender, EventArgs e)
{
if (CurrentSector != null)
{
Sector objData = CurrentSector;
//objData.ReportID = CurrentFlightReport.ReportID;
objData.SectorDate = DateTime.ParseExact(uiTextBoxDate.Text, "dd/MM/yyyy", null);
objData.From_AirportID = Convert.ToInt32(uiDropDownListSectorFrom.SelectedValue);
objData.To_AirportID = Convert.ToInt32(uiDropDownListSectorTo.SelectedValue);
objData.FlightNo = uiTextBoxSectorFlightNo.Text;
objData.IsHeavy = uiCheckBoxIsHeavy.Checked;
objData.AirCraft_AirPlaneID = Convert.ToInt32(uiDropDownListAirCraftRegistration.SelectedValue);
objData.IsPAX = false;
if (!string.IsNullOrEmpty(uiTextBoxFule.Text))
{
objData.FuleUplifted = Convert.ToInt32(uiTextBoxFule.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxActualBurn.Text))
{
objData.ActualBurnOff = Convert.ToInt32(uiTextBoxActualBurn.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxPlanBurnOff.Text))
{
objData.StandardBurnOff = Convert.ToInt32(uiTextBoxPlanBurnOff.Text);
}
TimeSpan STD = new TimeSpan(Convert.ToInt32(uiDropDownListSTDHours.Text), Convert.ToInt32(uiDropDownListSTDMins.Text), 0);
objData.STD = Convert.ToDateTime(STD.ToString());
TimeSpan ATD = new TimeSpan(Convert.ToInt32(uiDropDownListATDHours.Text), Convert.ToInt32(uiDropDownListATDMins.Text), 0);
objData.ATD = Convert.ToDateTime(ATD.ToString());
TimeSpan ATA = new TimeSpan(Convert.ToInt32(uiDropDownListATAHours.Text), Convert.ToInt32(uiDropDownListATAMins.Text), 0);
if (Convert.ToInt32(uiDropDownListATAHours.Text) < Convert.ToInt32(uiDropDownListATDHours.Text))
{
objData.ATA = Convert.ToDateTime(ATA.ToString()).AddDays(1);
}
else
{
objData.ATA = Convert.ToDateTime(ATA.ToString());
}
TimeSpan OFF = new TimeSpan(Convert.ToInt32(uiDropDownListOFFHours.Text), Convert.ToInt32(uiDropDownListOFFMins.Text), 0);
objData.ChoxOff = Convert.ToDateTime(OFF.ToString());
TimeSpan On = new TimeSpan(Convert.ToInt32(uiDropDownListOnHours.Text), Convert.ToInt32(uiDropDownListOnMins.Text), 0);
if (Convert.ToInt32(uiDropDownListOnHours.Text) < Convert.ToInt32(uiDropDownListOFFHours.Text))
{
objData.ChoxOn = Convert.ToDateTime(On.ToString()).AddDays(1);
}
else
{
objData.ChoxOn = Convert.ToDateTime(On.ToString());
}
TimeSpan STA = new TimeSpan(Convert.ToInt32(uiDropDownListSTAHours.Text), Convert.ToInt32(uiDropDownListSTAMins.Text), 0);
if (Convert.ToInt32(uiDropDownListSTAHours.Text) < Convert.ToInt32(uiDropDownListSTDHours.Text))
{
objData.STA = Convert.ToDateTime(STA.ToString()).AddDays(1);
}
else
{
objData.STA = Convert.ToDateTime(STA.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListDelay1Code.SelectedValue))
{
objData.DepDelayID1 = Convert.ToInt32(uiDropDownListDelay1Code.SelectedValue);
TimeSpan Delay1 = new TimeSpan(Convert.ToInt32(uiDropDownListDelay1Hours.Text), Convert.ToInt32(uiDropDownListDelay1Mins.Text), 0);
objData.DepDelayTime1 = Convert.ToDateTime(Delay1.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListDelay2Code.SelectedValue))
{
objData.DepDelayID2 = Convert.ToInt32(uiDropDownListDelay2Code.SelectedValue);
TimeSpan Delay2 = new TimeSpan(Convert.ToInt32(uiDropDownListDelay2Hours.Text), Convert.ToInt32(uiDropDownListDelay2Mins.Text), 0);
objData.DepDelayTime2 = Convert.ToDateTime(Delay2.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListDelay3Code.SelectedValue))
{
objData.DepDelayID3 = Convert.ToInt32(uiDropDownListDelay3Code.SelectedValue);
TimeSpan Delay3 = new TimeSpan(Convert.ToInt32(uiDropDownListDelay3Hours.Text), Convert.ToInt32(uiDropDownListDelay3Mins.Text), 0);
objData.DepDelayTime3 = Convert.ToDateTime(Delay3.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListArrDelay1Code.SelectedValue))
{
objData.ArrDelayID1 = Convert.ToInt32(uiDropDownListArrDelay1Code.SelectedValue);
TimeSpan ArrDelay1 = new TimeSpan(Convert.ToInt32(uiDropDownListArrDelay1Hours.Text), Convert.ToInt32(uiDropDownListArrDelay1Mins.Text), 0);
objData.ArrDelayTime1 = Convert.ToDateTime(ArrDelay1.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListArrDelay2Code.SelectedValue))
{
objData.ArrDelayID2 = Convert.ToInt32(uiDropDownListArrDelay2Code.SelectedValue);
TimeSpan ArrDelay2 = new TimeSpan(Convert.ToInt32(uiDropDownListArrDelay2Hours.Text), Convert.ToInt32(uiDropDownListArrDelay2Mins.Text), 0);
objData.ArrDelayTime2 = Convert.ToDateTime(ArrDelay2.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListArrDelay3Code.SelectedValue))
{
objData.ArrDelayID3 = Convert.ToInt32(uiDropDownListArrDelay3Code.SelectedValue);
TimeSpan ArrDelay3 = new TimeSpan(Convert.ToInt32(uiDropDownListArrDelay3Hours.Text), Convert.ToInt32(uiDropDownListArrDelay3Mins.Text), 0);
objData.ArrDelayTime3 = Convert.ToDateTime(ArrDelay3.ToString());
}
TimeSpan Day = new TimeSpan(Convert.ToInt32(uiDropDownListDayHours.Text), Convert.ToInt32(uiDropDownListDayMins.Text), 0);
objData.FlyAtDay = Convert.ToDateTime(Day.ToString());
TimeSpan Night = new TimeSpan(Convert.ToInt32(uiDropDownListNightHours.Text), Convert.ToInt32(uiDropDownListNightMins.Text), 0);
objData.FlyAtNight = Convert.ToDateTime(Night.ToString());
if (!string.IsNullOrEmpty(uiTextBoxDepFuel.Text))
{
objData.DepFule = Convert.ToInt32(uiTextBoxDepFuel.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxArrFuel.Text))
{
objData.ArrFule = Convert.ToInt32(uiTextBoxArrFuel.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxNoOFPax_A.Text))
{
objData.NoOfPax_A = Convert.ToInt32(uiTextBoxNoOFPax_A.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxNoOFPax_CH.Text))
{
objData.NoOfPax_C = Convert.ToInt32(uiTextBoxNoOFPax_CH.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxNoOFPax_I.Text))
{
objData.NoOfPax_I = Convert.ToInt32(uiTextBoxNoOFPax_I.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxTOW.Text))
{
objData.TOW = Convert.ToInt32(uiTextBoxTOW.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxZFW.Text))
{
objData.ZFW = Convert.ToInt32(uiTextBoxZFW.Text);
}
objData.Save();
}
else
{
Sector objData = new Sector();
objData.AddNew();
//objData.ReportID = CurrentFlightReport.ReportID;
objData.SectorDate = DateTime.ParseExact(uiTextBoxDate.Text, "dd/MM/yyyy", null);
objData.From_AirportID = Convert.ToInt32(uiDropDownListSectorFrom.SelectedValue);
objData.To_AirportID = Convert.ToInt32(uiDropDownListSectorTo.SelectedValue);
objData.AirCraft_AirPlaneID = Convert.ToInt32(uiDropDownListAirCraftRegistration.SelectedValue);
objData.FlightNo = uiTextBoxSectorFlightNo.Text;
objData.IsHeavy = uiCheckBoxIsHeavy.Checked;
objData.IsPAX = false;
if (!string.IsNullOrEmpty(uiTextBoxFule.Text))
{
objData.FuleUplifted = Convert.ToInt32(uiTextBoxFule.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxActualBurn.Text))
{
objData.ActualBurnOff = Convert.ToInt32(uiTextBoxActualBurn.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxPlanBurnOff.Text))
{
objData.StandardBurnOff = Convert.ToInt32(uiTextBoxPlanBurnOff.Text);
}
TimeSpan STD = new TimeSpan(Convert.ToInt32(uiDropDownListSTDHours.Text), Convert.ToInt32(uiDropDownListSTDMins.Text), 0);
objData.STD = Convert.ToDateTime(STD.ToString());
TimeSpan ATD = new TimeSpan(Convert.ToInt32(uiDropDownListATDHours.Text), Convert.ToInt32(uiDropDownListATDMins.Text), 0);
objData.ATD = Convert.ToDateTime(ATD.ToString());
TimeSpan ATA = new TimeSpan(Convert.ToInt32(uiDropDownListATAHours.Text), Convert.ToInt32(uiDropDownListATAMins.Text), 0);
if (Convert.ToInt32(uiDropDownListATAHours.Text) < Convert.ToInt32(uiDropDownListATDHours.Text))
{
objData.ATA = Convert.ToDateTime(ATA.ToString()).AddDays(1);
}
else
{
objData.ATA = Convert.ToDateTime(ATA.ToString());
}
TimeSpan OFF = new TimeSpan(Convert.ToInt32(uiDropDownListOFFHours.Text), Convert.ToInt32(uiDropDownListOFFMins.Text), 0);
objData.ChoxOff = Convert.ToDateTime(OFF.ToString());
TimeSpan On = new TimeSpan(Convert.ToInt32(uiDropDownListOnHours.Text), Convert.ToInt32(uiDropDownListOnMins.Text), 0);
if (Convert.ToInt32(uiDropDownListOnHours.Text) < Convert.ToInt32(uiDropDownListOFFHours.Text))
{
objData.ChoxOn = Convert.ToDateTime(On.ToString()).AddDays(1);
}
else
{
objData.ChoxOn = Convert.ToDateTime(On.ToString());
}
TimeSpan STA = new TimeSpan(Convert.ToInt32(uiDropDownListSTAHours.Text), Convert.ToInt32(uiDropDownListSTAMins.Text), 0);
if (Convert.ToInt32(uiDropDownListSTAHours.Text) < Convert.ToInt32(uiDropDownListSTDHours.Text))
{
objData.STA = Convert.ToDateTime(STA.ToString()).AddDays(1);
}
else
{
objData.STA = Convert.ToDateTime(STA.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListDelay1Code.SelectedValue))
{
objData.DepDelayID1 = Convert.ToInt32(uiDropDownListDelay1Code.SelectedValue);
TimeSpan Delay1 = new TimeSpan(Convert.ToInt32(uiDropDownListDelay1Hours.Text), Convert.ToInt32(uiDropDownListDelay1Mins.Text), 0);
objData.DepDelayTime1 = Convert.ToDateTime(Delay1.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListDelay2Code.SelectedValue))
{
objData.DepDelayID2 = Convert.ToInt32(uiDropDownListDelay2Code.SelectedValue);
TimeSpan Delay2 = new TimeSpan(Convert.ToInt32(uiDropDownListDelay2Hours.Text), Convert.ToInt32(uiDropDownListDelay2Mins.Text), 0);
objData.DepDelayTime2 = Convert.ToDateTime(Delay2.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListDelay3Code.SelectedValue))
{
objData.DepDelayID3 = Convert.ToInt32(uiDropDownListDelay3Code.SelectedValue);
TimeSpan Delay3 = new TimeSpan(Convert.ToInt32(uiDropDownListDelay3Hours.Text), Convert.ToInt32(uiDropDownListDelay3Mins.Text), 0);
objData.DepDelayTime3 = Convert.ToDateTime(Delay3.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListArrDelay1Code.SelectedValue))
{
objData.ArrDelayID1 = Convert.ToInt32(uiDropDownListArrDelay1Code.SelectedValue);
TimeSpan ArrDelay1 = new TimeSpan(Convert.ToInt32(uiDropDownListArrDelay1Hours.Text), Convert.ToInt32(uiDropDownListArrDelay1Mins.Text), 0);
objData.ArrDelayTime1 = Convert.ToDateTime(ArrDelay1.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListArrDelay2Code.SelectedValue))
{
objData.ArrDelayID2 = Convert.ToInt32(uiDropDownListArrDelay2Code.SelectedValue);
TimeSpan ArrDelay2 = new TimeSpan(Convert.ToInt32(uiDropDownListArrDelay2Hours.Text), Convert.ToInt32(uiDropDownListArrDelay2Mins.Text), 0);
objData.ArrDelayTime2 = Convert.ToDateTime(ArrDelay2.ToString());
}
if (!string.IsNullOrEmpty(uiDropDownListArrDelay3Code.SelectedValue))
{
objData.ArrDelayID3 = Convert.ToInt32(uiDropDownListArrDelay3Code.SelectedValue);
TimeSpan ArrDelay3 = new TimeSpan(Convert.ToInt32(uiDropDownListArrDelay3Hours.Text), Convert.ToInt32(uiDropDownListArrDelay3Mins.Text), 0);
objData.ArrDelayTime3 = Convert.ToDateTime(ArrDelay3.ToString());
}
TimeSpan Day = new TimeSpan(Convert.ToInt32(uiDropDownListDayHours.Text), Convert.ToInt32(uiDropDownListDayMins.Text), 0);
objData.FlyAtDay = Convert.ToDateTime(Day.ToString());
TimeSpan Night = new TimeSpan(Convert.ToInt32(uiDropDownListNightHours.Text), Convert.ToInt32(uiDropDownListNightMins.Text), 0);
objData.FlyAtNight = Convert.ToDateTime(Night.ToString());
if (!string.IsNullOrEmpty(uiTextBoxDepFuel.Text))
{
objData.DepFule = Convert.ToInt32(uiTextBoxDepFuel.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxArrFuel.Text))
{
objData.ArrFule = Convert.ToInt32(uiTextBoxArrFuel.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxNoOFPax_A.Text))
{
objData.NoOfPax_A = Convert.ToInt32(uiTextBoxNoOFPax_A.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxNoOFPax_CH.Text))
{
objData.NoOfPax_C = Convert.ToInt32(uiTextBoxNoOFPax_CH.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxNoOFPax_I.Text))
{
objData.NoOfPax_I = Convert.ToInt32(uiTextBoxNoOFPax_I.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxTOW.Text))
{
objData.TOW = Convert.ToInt32(uiTextBoxTOW.Text);
}
if (!string.IsNullOrEmpty(uiTextBoxZFW.Text))
{
objData.ZFW = Convert.ToInt32(uiTextBoxZFW.Text);
}
objData.Save();
CurrentSector = objData;
}
EnableDisableTabs();
//ClearSectorFields();
//CurrentSector = null;
//BindSectors();
}
