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(); }