public List <Airline> GetAirlineInformation(Int64 nAIRLINE_CODE_ID, string sTask) { DataTable _dt = null; List <Airline> lstAirline = null; DBParameters _DBParameters = new DBParameters(); DataAccess _DataAccess = new DataAccess(); try { _DataAccess.OpenConnection(false); _DBParameters.clear(); _DBParameters.Add("@AIRLINE_CODE_ID", nAIRLINE_CODE_ID, ParameterDirection.Input, SqlDbType.BigInt); _DBParameters.Add("@TASK", sTask, ParameterDirection.Input, SqlDbType.VarChar); _DataAccess.Retrive("SP_GET_AIRLINE_DATA", _DBParameters, out _dt); _DataAccess.CloseConnection(false); if (_dt != null && _dt.Rows.Count > 0) { lstAirline = new List <Airline>(); Int64 count = 0; foreach (DataRow dr in _dt.Rows) { Airline oAirline = new Airline(); oAirline.SRNO = ++count; oAirline.AIRLINE_CODE_ID = Convert.ToInt64(dr["AIRLINE_CODE_ID"]); oAirline.AIRLINE_CODE = Convert.ToString(dr["AIRLINE_CODE"]); oAirline.AIRLINE_NAME = Convert.ToString(dr["AIRLINE_NAME"]); oAirline.DOM_MIN_USAGE = Convert.ToDouble(dr["DOM_MIN_USAGE"]); oAirline.INT_MIN_USAGE = Convert.ToDouble(dr["INT_MIN_USAGE"]); oAirline.DOM_ROUNDINNG_OFF_VALUE = Convert.ToBoolean(dr["DOM_ROUNDINNG_OFF_VALUE"]); oAirline.INT_ROUNDINNG_OFF_VALUE = Convert.ToBoolean(dr["INT_ROUNDINNG_OFF_VALUE"]); oAirline.THRESHOLD_LIMIT = Convert.ToDouble(dr["THRESHOLD_LIMIT"]); oAirline.SAP_ACCOUNT_CODE = Convert.ToString(dr["SAP_ACCOUNT_CODE"]); oAirline.TAX_ACCOUNT_CODE = Convert.ToString(dr["TAX_ACCOUNT_CODE"]); oAirline.FGP_N_ARR_INT_DEP_INT_RATE = Convert.ToDouble(dr["FGP_N_ARR_INT_DEP_INT_RATE"]); oAirline.PCA_N_ARR_INT_DEP_INT_RATE = Convert.ToDouble(dr["PCA_N_ARR_INT_DEP_INT_RATE"]); oAirline.FGP_N_ARR_DOM_DEP_DOM_RATE = Convert.ToDouble(dr["FGP_N_ARR_DOM_DEP_DOM_RATE"]); oAirline.PAC_N_ARR_DOM_DEP_DOM_RATE = Convert.ToDouble(dr["PAC_N_ARR_DOM_DEP_DOM_RATE"]); oAirline.FGP_N_ARR_INT_DEP_DOM_RATE = Convert.ToDouble(dr["FGP_N_ARR_INT_DEP_DOM_RATE"]); oAirline.PCA_N_ARR_INT_DEP_DOM_RATE = Convert.ToDouble(dr["PCA_N_ARR_INT_DEP_DOM_RATE"]); oAirline.FGP_N_ARR_DOM_DEP_INT_RATE = Convert.ToDouble(dr["FGP_N_ARR_DOM_DEP_INT_RATE"]); oAirline.PCA_N_ARR_DOM_DEP_INT_RATE = Convert.ToDouble(dr["PCA_N_ARR_DOM_DEP_INT_RATE"]); oAirline.FGP_T_ARR_INT_DEP_INT_RATE = Convert.ToDouble(dr["FGP_T_ARR_INT_DEP_INT_RATE"]); oAirline.PCA_T_ARR_INT_DEP_INT_RATE = Convert.ToDouble(dr["PCA_T_ARR_INT_DEP_INT_RATE"]); oAirline.FGP_T_ARR_DOM_DEP_DOM_RATE = Convert.ToDouble(dr["FGP_T_ARR_DOM_DEP_DOM_RATE"]); oAirline.PAC_T_ARR_DOM_DEP_DOM_RATE = Convert.ToDouble(dr["PAC_T_ARR_DOM_DEP_DOM_RATE"]); oAirline.FGP_T_ARR_INT_DEP_DOM_RATE = Convert.ToDouble(dr["FGP_T_ARR_INT_DEP_DOM_RATE"]); oAirline.PCA_T_ARR_INT_DEP_DOM_RATE = Convert.ToDouble(dr["PCA_T_ARR_INT_DEP_DOM_RATE"]); oAirline.FGP_T_ARR_DOM_DEP_INT_RATE = Convert.ToDouble(dr["FGP_T_ARR_DOM_DEP_INT_RATE"]); oAirline.PCA_T_ARR_DOM_DEP_INT_RATE = Convert.ToDouble(dr["PCA_T_ARR_DOM_DEP_INT_RATE"]); lstAirline.Add(oAirline); oAirline.Dispose(); oAirline = null; } } } catch (Exception) { if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); } } finally { if (_DBParameters != null) { _DBParameters.Dispose(); } } return(lstAirline); }
public int InsertUpdateDeleteAirline(Airline oAirline, string sTask) { int nResult = 0; DataTable _dt = null; DBParameters _DBParameters = new DBParameters(); DataAccess _DataAccess = new DataAccess(); try { _DataAccess.OpenConnection(false); _DBParameters.clear(); _DBParameters.Add("@TASK", sTask, ParameterDirection.Input, SqlDbType.VarChar); //_DBParameters.Add("@Company_ID", oCompany.Company_ID, ParameterDirection.Input, SqlDbType.BigInt); _DBParameters.Add("@AIRLINE_CODE_ID", oAirline.AIRLINE_CODE_ID, ParameterDirection.Input, SqlDbType.BigInt); _DBParameters.Add("@AIRLINE_CODE", oAirline.AIRLINE_CODE, ParameterDirection.Input, SqlDbType.VarChar); _DBParameters.Add("@AIRLINE_NAME", oAirline.AIRLINE_NAME, ParameterDirection.Input, SqlDbType.VarChar); _DBParameters.Add("@DOM_MIN_USAGE", oAirline.DOM_MIN_USAGE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@INT_MIN_USAGE", oAirline.INT_MIN_USAGE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@DOM_ROUNDINNG_OFF_VALUE", oAirline.DOM_ROUNDINNG_OFF_VALUE, ParameterDirection.Input, SqlDbType.Bit); _DBParameters.Add("@INT_ROUNDINNG_OFF_VALUE", oAirline.INT_ROUNDINNG_OFF_VALUE, ParameterDirection.Input, SqlDbType.Bit); _DBParameters.Add("@THRESHOLD_LIMIT", oAirline.THRESHOLD_LIMIT, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@SAP_ACCOUNT_CODE", oAirline.SAP_ACCOUNT_CODE, ParameterDirection.Input, SqlDbType.VarChar); _DBParameters.Add("@TAX_ACCOUNT_CODE", oAirline.TAX_ACCOUNT_CODE, ParameterDirection.Input, SqlDbType.VarChar); _DBParameters.Add("@FGP_N_ARR_INT_DEP_INT_RATE", oAirline.FGP_N_ARR_INT_DEP_INT_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@PCA_N_ARR_INT_DEP_INT_RATE", oAirline.PCA_N_ARR_INT_DEP_INT_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@FGP_N_ARR_DOM_DEP_DOM_RATE", oAirline.FGP_N_ARR_DOM_DEP_DOM_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@PAC_N_ARR_DOM_DEP_DOM_RATE", oAirline.PAC_N_ARR_DOM_DEP_DOM_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@FGP_N_ARR_INT_DEP_DOM_RATE", oAirline.FGP_N_ARR_INT_DEP_DOM_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@PCA_N_ARR_INT_DEP_DOM_RATE", oAirline.PCA_N_ARR_INT_DEP_DOM_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@FGP_N_ARR_DOM_DEP_INT_RATE", oAirline.FGP_N_ARR_DOM_DEP_INT_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@PCA_N_ARR_DOM_DEP_INT_RATE", oAirline.PCA_N_ARR_DOM_DEP_INT_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@FGP_T_ARR_INT_DEP_INT_RATE", oAirline.FGP_T_ARR_INT_DEP_INT_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@PCA_T_ARR_INT_DEP_INT_RATE", oAirline.PCA_T_ARR_INT_DEP_INT_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@FGP_T_ARR_DOM_DEP_DOM_RATE", oAirline.FGP_T_ARR_DOM_DEP_DOM_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@PAC_T_ARR_DOM_DEP_DOM_RATE", oAirline.PAC_T_ARR_DOM_DEP_DOM_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@FGP_T_ARR_INT_DEP_DOM_RATE", oAirline.FGP_T_ARR_INT_DEP_DOM_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@PCA_T_ARR_INT_DEP_DOM_RATE", oAirline.PCA_T_ARR_INT_DEP_DOM_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@FGP_T_ARR_DOM_DEP_INT_RATE", oAirline.FGP_T_ARR_DOM_DEP_INT_RATE, ParameterDirection.Input, SqlDbType.Float); _DBParameters.Add("@PCA_T_ARR_DOM_DEP_INT_RATE", oAirline.PCA_T_ARR_DOM_DEP_INT_RATE, ParameterDirection.Input, SqlDbType.Float); _DataAccess.Retrive("SP_Create_Update_Airline_Code_Master", _DBParameters, out _dt); _DataAccess.CloseConnection(false); if (_dt != null && _dt.Rows.Count > 0) { nResult = Convert.ToInt32(_dt.Rows[0][0]); } } catch (Exception) { if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); } } finally { if (_DBParameters != null) { _DBParameters.Dispose(); } } return(nResult); }