// To get Airline scheuled capacity public string ScheduleCapacity(string str) { try { DataSet ds = new DataSet(); SqlParameter[] Parameters = { new SqlParameter("@AIRCRAFTSNO", str) }; ds = SqlHelper.ExecuteDataset(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "getScheduleCapacity", Parameters); FlightOpenService fos = new FlightOpenService(); return(fos.DStoJSON(ds)); } catch (Exception ex)// { throw ex; } }
public string Getcheck_Z_Code(string str) { try { DataSet ds = new DataSet(); SqlParameter[] Parameters = { new SqlParameter("@Trucking", str) }; ds = SqlHelper.ExecuteDataset(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "check_Z_Code", Parameters); FlightOpenService fos = new FlightOpenService(); return(fos.DStoJSON(ds)); } catch (Exception ex)// { throw ex; } }
//public string GetFlight(string FlightNo, string FlightDate) //{ // SqlParameter[] Parameters = { // new SqlParameter("@FlightNo", FlightNo), // new SqlParameter("@FlightDate", FlightDate) }; // DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetDailyFlight", Parameters); // return ds.Tables[0].Rows[0][0].ToString(); //} public string GetEditFlightDetail(int SNo) { try { DataSet ds = new DataSet(); SqlParameter[] Parameters = { new SqlParameter("@SNo", SNo) }; ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "Get_EditFlightDetail", Parameters); FlightOpenService fos = new FlightOpenService(); return(fos.DStoJSON(ds)); } catch (Exception ex)// { throw ex; } }
public string GetFlightDetail(FlightDetail model) { try { DataSet ds = new DataSet(); SqlParameter[] Parameters = { new SqlParameter("@Date", model.Date), new SqlParameter("@flightNo", model.FlightNo), new SqlParameter("@Origin", model.Origin), new SqlParameter("@Destination", model.Destination) }; ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "Get_ViewEditFlightDetail", Parameters); FlightOpenService fos = new FlightOpenService(); return(fos.DStoJSON(ds)); } catch (Exception ex)// { throw ex; } }
public string GetAirCraftWeight(String AirCraftSno, int Ori, int Dest, int AirlineSNo) { try { DataSet ds = new DataSet(); SqlParameter[] Parameters = { new SqlParameter("@AirCraftSno", AirCraftSno), new SqlParameter("@Ori", Ori), new SqlParameter("@Dest", Dest), new SqlParameter("@AirlineSNo", AirlineSNo) }; ds = SqlHelper.ExecuteDataset(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "Get_AirCraftWeightDetail", Parameters); FlightOpenService fos = new FlightOpenService(); return(fos.DStoJSON(ds)); } catch (Exception ex)// { throw ex; } }