// 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;
}
}
