public List <StandData> RetriveStandData()
{
List <StandData> lstStandData = null;
try
{
StandData oStandData = new StandData();
lstStandData = oStandData.GetStandData(FromDate, ToDate, Task);
}
catch (Exception)
{
}
return(lstStandData);
}
public List <StandData> GetStandData(DateTime dtFromDate, DateTime dtToDate, string sTask)
{
DataTable _dt = null;
List <StandData> lstStandData = null;
DBParameters _DBParameters = new DBParameters();
DataAccess _DataAccess = new DataAccess();
try
{
_DataAccess.OpenConnection(false);
_DBParameters.clear();
_DBParameters.Add("@FROM_DATE_TIME", dtFromDate, ParameterDirection.Input, SqlDbType.DateTime);
_DBParameters.Add("@TO_DATE_TIME", dtToDate, ParameterDirection.Input, SqlDbType.DateTime);
_DBParameters.Add("@TASK", sTask, ParameterDirection.Input, SqlDbType.VarChar);
_DataAccess.Retrive("GET_STAND_DATA", _DBParameters, out _dt);
_DataAccess.CloseConnection(false);
if (_dt != null && _dt.Rows.Count > 0)
{
lstStandData = new List <StandData>();
foreach (DataRow dr in _dt.Rows)
{
StandData oStandData = new StandData();
oStandData.FLIGHT_ID = Convert.ToString(dr["FLIGHT ID"]);
oStandData.FLIGHT_NUMBER = Convert.ToString(dr["FLIGHT No."]);
oStandData.FLIGHT_DATE = Convert.ToDateTime(dr["FLIGHT DATE"]);
oStandData.AIRLINE_NAME = Convert.ToString(dr["AIRLINE NAME"]);
oStandData.AIRCRAFT_REGN = Convert.ToString(dr["AIRCRAFT REGN"]);
oStandData.AIRCRAFT_TYPE = Convert.ToString(dr["AIRCRAFT TYPE"]);
oStandData.FLIGHT_TYPE = Convert.ToString(dr["FLIGHT TYPE"]);
oStandData.STAND_NAME = Convert.ToString(dr["STAND NAME"]);
oStandData.STAND_IN_DATE = Convert.ToDateTime(dr["STAND IN DATE"]);
oStandData.STAND_IN_TIME = Convert.ToString(dr["STAND IN TIME"]);
oStandData.STAND_OUT_DATE = Convert.ToDateTime(dr["STAND OUT DATE"]);
oStandData.STAND_OUT_TIME = Convert.ToString(dr["STAND OUT TIME"]);
if (Convert.ToString(dr["IS ASSOCIATED"]).ToLower() == "yes")
{
oStandData.PROCESSING_DONE = true;
}
else
{
oStandData.PROCESSING_DONE = false;
}
oStandData.DATA_SOURCE_TYPE = Convert.ToString(dr["DATA SOURCE"]);
lstStandData.Add(oStandData);
oStandData.Dispose();
oStandData = null;
}
}
}
catch (Exception)
{
if (_DataAccess != null)
{
_DataAccess.RollBack(); _DataAccess.CloseConnection(false);
}
}
finally
{
if (_DBParameters != null)
{
_DBParameters.Dispose();
}
}
return(lstStandData);
}
