public DataSet UpdateCurrEffecToDate(clsCurrExchangeRate objclsCurrExchangeRate)
 {
     dataAccess = new DataAccess();
     Object[] parametes = new Object[] {
         objclsCurrExchangeRate.CurrExchangeRateId,
         objclsCurrExchangeRate.CurrencyCode,
         objclsCurrExchangeRate.EffectiveFromDate
     };
     return(dataAccess.LoadDataSet(parametes, "P_TM_CurrEffecTo_Update", "TM_CurrExchangeRateMaster"));
 }
        public DataSet LoadCurrExchangeRate(clsCurrExchangeRate objclsCurrExchangeRate)
        {
            dataAccess = new DataAccess();
            DataSet ds = new DataSet();

            Object[] parametes = new Object[] {
                objclsCurrExchangeRate.CurrExchangeRateId
            };
            ds = dataAccess.LoadDataSet(parametes, "P_TM_CurrExchangeRateMaster_select", "TM_CurrExchangeRateMaster");
            return(ds);
        }
 public DataSet SaveCurrExchangeRate(clsCurrExchangeRate objclsCurrExchangeRate)
 {
     dataAccess = new DataAccess();
     Object[] parametes = new Object[] {
         objclsCurrExchangeRate.CurrExchangeRateId,
         objclsCurrExchangeRate.CurrencyId,
         objclsCurrExchangeRate.CurrencyCode,
         objclsCurrExchangeRate.isExport,
         objclsCurrExchangeRate.EffectiveFromDate,
         objclsCurrExchangeRate.EffectiveToDate,
         objclsCurrExchangeRate.ExchangeRateToCurr,
         objclsCurrExchangeRate.ExchangeRateToHKD,
         objclsCurrExchangeRate.AccYear,
         objclsCurrExchangeRate.User,
         objclsCurrExchangeRate.PrevCurrExchangeRateId
     };
     return(dataAccess.LoadDataSet(parametes, "P_TM_CurrExchangeRateMaster_InsertUpdate", "TM_CurrExchangeRateMaster"));
 }