/// <summary> /// This methods string of funding source ids belonging /// to a particular currency /// </summary> /// <param name="currId">currId</param> /// <returns></returns> public string GetAllTransferFundingSourceOfParticularCurrency(int currId) { try { using (var unitOfWork = new EFUnitOfWork()) { var sourceAcceptedCurrRepo = new FundingSourceAcceptedCurrencyRepository(new EFRepository <FundingSourceAcceptedCurrency>(), unitOfWork); ObjectSet <FundingSourceAcceptedCurrency> acceptedCurrObjSet = ((CurrentDeskClientsEntities)sourceAcceptedCurrRepo.Repository.UnitOfWork.Context) .FundingSourceAcceptedCurrencies; string returnStr = String.Empty; //Get all ids of source of a currency var acceptedSource = acceptedCurrObjSet.Where(src => src.IsDeleted == false && (src.FK_LCurrencyValueID == currId || src.FK_LCurrencyValueID == 6)) .GroupBy(s => s.FK_FundingSourceID) .Select(a => new CurrencyFundingSource { ID = (int)a.Key }).ToList(); foreach (var res in acceptedSource) { returnStr += res.ID + ","; } return(returnStr.TrimEnd(',')); } } catch (Exception ex) { CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); throw; } }
/// <summary> /// This method returns string of accepted currencies of funding source /// </summary> /// <param name="pkFundingSourceID">pkFundingSourceID</param> /// <returns></returns> public string GetAllAcceptedCurrenciesofSource(int pkFundingSourceID) { try { using (var unitOfWork = new EFUnitOfWork()) { string strAcceptedCurrencies = String.Empty; L_CurrencyValueBO lCurrValueBO = new L_CurrencyValueBO(); var sourceAcceptedCurrRepo = new FundingSourceAcceptedCurrencyRepository(new EFRepository <FundingSourceAcceptedCurrency>(), unitOfWork); ObjectSet <FundingSourceAcceptedCurrency> acceptedCurrObjSet = ((CurrentDeskClientsEntities)sourceAcceptedCurrRepo.Repository.UnitOfWork.Context).FundingSourceAcceptedCurrencies; //Get all currencies var acceptedCurrencies = acceptedCurrObjSet.Where(curr => curr.FK_FundingSourceID == pkFundingSourceID && curr.IsDeleted == false).ToList(); //Make string of currencies comma separated foreach (var curr in acceptedCurrencies) { strAcceptedCurrencies += lCurrValueBO.GetCurrencySymbolFromID((int)curr.FK_LCurrencyValueID) + ", "; } return(strAcceptedCurrencies.TrimEnd(' ').TrimEnd(',')); } } catch (Exception ex) { CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); return(String.Empty); } }
/// <summary> /// This method updates funding source accepted currencies /// </summary> /// <param name="pkFundingSourceID">pkFundingSourceID</param> /// <param name="acceptedCurr">acceptedCurr</param> /// <returns></returns> public bool UpdateFundingSourceAcceptedCurrency(int pkFundingSourceID, string acceptedCurr) { try { using (var unitOfWork = new EFUnitOfWork()) { //Get array of currencies var allCurr = acceptedCurr.Split(','); int parseResult; var sourceAcceptedCurrRepo = new FundingSourceAcceptedCurrencyRepository(new EFRepository <FundingSourceAcceptedCurrency>(), unitOfWork); ObjectSet <FundingSourceAcceptedCurrency> acceptedCurrObjSet = ((CurrentDeskClientsEntities)sourceAcceptedCurrRepo.Repository.UnitOfWork.Context).FundingSourceAcceptedCurrencies; //Get old records and set IsDelete true var oldRecords = acceptedCurrObjSet.Where(curr => curr.FK_FundingSourceID == pkFundingSourceID).ToList(); foreach (var record in oldRecords) { record.IsDeleted = true; } //Insert to repo for each currency foreach (var curr in allCurr) { if (Int32.TryParse(curr, out parseResult)) { FundingSourceAcceptedCurrency fundAcceptedCurr = new FundingSourceAcceptedCurrency(); fundAcceptedCurr.FK_FundingSourceID = pkFundingSourceID; fundAcceptedCurr.FK_LCurrencyValueID = Convert.ToInt32(curr); fundAcceptedCurr.IsDeleted = false; sourceAcceptedCurrRepo.Add(fundAcceptedCurr); } } //Save sourceAcceptedCurrRepo.Save(); return(true); } } catch (Exception ex) { CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); return(false); } }
// Add your own data access methods here. If you wish to // expose your public method to a WCF service, marked them with // the attribute [NCPublish], and another T4 template will generate your service contract /// <summary> /// This method inserts each row for various currency accepted by funding source /// </summary> /// <param name="pkFundingSourceID"></param> /// <param name="acceptedCurr"></param> /// <returns></returns> public bool AddFundingSourceAcceptedCurrency(int pkFundingSourceID, string acceptedCurr) { try { using (var unitOfWork = new EFUnitOfWork()) { var sourceAcceptedCurrRepo = new FundingSourceAcceptedCurrencyRepository(new EFRepository <FundingSourceAcceptedCurrency>(), unitOfWork); //Get array of currencies var allCurr = acceptedCurr.Split(','); int parseResult; //Insert to repo for each currency foreach (var curr in allCurr) { if (Int32.TryParse(curr, out parseResult)) { FundingSourceAcceptedCurrency fundAcceptedCurr = new FundingSourceAcceptedCurrency(); fundAcceptedCurr.FK_FundingSourceID = pkFundingSourceID; fundAcceptedCurr.FK_LCurrencyValueID = Convert.ToInt32(curr); fundAcceptedCurr.IsDeleted = false; sourceAcceptedCurrRepo.Add(fundAcceptedCurr); } } //Save sourceAcceptedCurrRepo.Save(); return(true); } } catch (Exception ex) { CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); return(false); } }