public void Add(RecurringDeposit RecurringDeposit) { try { string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(SELECT_ID, RecurringDeposit.Id)); DataBase.DBService.BeginTransaction(); DataBase.DBService.ExecuteCommandString(string.Format(INSERT_RecurringDeposit, RecurringDeposit.Pid, RecurringDeposit.InvesterName, RecurringDeposit.AccountNo, RecurringDeposit.BankName, RecurringDeposit.Branch, RecurringDeposit.Balance, RecurringDeposit.IntRate, RecurringDeposit.DepositDate.ToString("yyyy-MM-dd hh:mm:ss"), RecurringDeposit.MaturityAmt, RecurringDeposit.MaturityDate.ToString("yyyy-MM-dd hh:mm:ss"), RecurringDeposit.MonthlyInstallment, RecurringDeposit.GoalId, RecurringDeposit.CreatedOn.ToString("yyyy-MM-dd hh:mm:ss"), RecurringDeposit.CreatedBy, RecurringDeposit.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"), RecurringDeposit.UpdatedBy), true); Activity.ActivitiesService.Add(ActivityType.CreateRecurringDeposit, EntryStatus.Success, Source.Server, RecurringDeposit.UpdatedByUserName, RecurringDeposit.AccountNo, RecurringDeposit.MachineName); DataBase.DBService.CommitTransaction(); } catch (Exception ex) { DataBase.DBService.RollbackTransaction(); StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); throw ex; } }
public IList <RecurringDeposit> GetAll(int plannerId) { try { Logger.LogInfo("Get: RecurringDeposit process start"); IList <RecurringDeposit> lstRecurringDepositOption = new List <RecurringDeposit>(); DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL, plannerId)); foreach (DataRow dr in dtAppConfig.Rows) { RecurringDeposit mf = convertToRecurringDeposit(dr); lstRecurringDepositOption.Add(mf); } Logger.LogInfo("Get: RecurringDeposit fund process completed."); return(lstRecurringDepositOption); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); return(null); } }
private RecurringDeposit convertToRecurringDeposit(DataRow dr) { RecurringDeposit RecurringDeposit = new RecurringDeposit(); RecurringDeposit.Id = dr.Field <int>("ID"); RecurringDeposit.Pid = dr.Field <int>("PID"); RecurringDeposit.InvesterName = dr.Field <string>("InvesterName"); RecurringDeposit.AccountNo = dr.Field <string>("AccountNo"); RecurringDeposit.BankName = dr.Field <string>("BankName"); RecurringDeposit.Branch = dr.Field <string>("Branch"); RecurringDeposit.Balance = Double.Parse(dr["Balance"].ToString()); RecurringDeposit.IntRate = float.Parse(dr["IntRate"].ToString()); RecurringDeposit.DepositDate = dr.Field <DateTime>("DepositDate"); RecurringDeposit.MaturityAmt = Double.Parse(dr["MaturityAmt"].ToString()); RecurringDeposit.MaturityDate = dr.Field <DateTime>("MaturityDate"); RecurringDeposit.MonthlyInstallment = Double.Parse(dr["MonthlyInstallment"].ToString()); RecurringDeposit.GoalId = dr.Field <int>("GoalId"); RecurringDeposit.UpdatedBy = dr.Field <int>("UpdatedBy"); RecurringDeposit.UpdatedOn = dr.Field <DateTime>("UpdatedOn"); RecurringDeposit.UpdatedByUserName = dr.Field <string>("UpdatedByUserName"); RecurringDeposit.UpdatedBy = dr.Field <int>("UpdatedBy"); RecurringDeposit.UpdatedOn = dr.Field <DateTime>("UpdatedOn"); RecurringDeposit.UpdatedByUserName = dr.Field <string>("UpdatedByUserName"); return(RecurringDeposit); }
public Result Delete(RecurringDeposit RecurringDeposit) { var result = new Result(); try { RecurringDepositService RecurringDepositService = new RecurringDepositService(); RecurringDepositService.Delete(RecurringDeposit); result.IsSuccess = true; } catch (Exception exception) { result.IsSuccess = false; result.ExceptionInfo = exception; } return(result); }
internal bool Update(RecurringDeposit RecurringDeposit) { try { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + UPDATE_RecurringDeposit_API; RestAPIExecutor restApiExecutor = new RestAPIExecutor(); var restResult = restApiExecutor.Execute <RecurringDeposit>(apiurl, RecurringDeposit, "POST"); return(true); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); return(false); } }
public static void ValidateDepositType(ref string depositType) { var depositTypes = new string[] { SavingDeposit.GetDepositType(), CurrentDeposit.GetDepositType(), FixedDeposit.GetDepositType(), RecurringDeposit.GetDepositType(), }; do { var iter = 0; Console.WriteLine("Возможные типы депозитов:"); foreach (var dep in depositTypes) { Console.WriteLine($"{++iter}.{dep}"); } Console.Write("Введите тип депозита: "); depositType = Console.ReadLine(); } while (!depositTypes.Contains(depositType)); }
public RecurringDeposit Get(int id) { try { Logger.LogInfo("Get: RecurringDeposit by id process start"); RecurringDeposit RecurringDeposit = new RecurringDeposit(); DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ID, id)); foreach (DataRow dr in dtAppConfig.Rows) { RecurringDeposit = convertToRecurringDeposit(dr); } Logger.LogInfo("Get: RecurringDeposit by id process completed"); return(RecurringDeposit); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); return(null); } }
public void Delete(RecurringDeposit RecurringDeposit) { try { string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(SELECT_ID, RecurringDeposit.Id)); DataBase.DBService.BeginTransaction(); DataBase.DBService.ExecuteCommandString(string.Format(DELETE_RecurringDeposit, RecurringDeposit.Id), true); Activity.ActivitiesService.Add(ActivityType.DeleteRecurringDeposit, EntryStatus.Success, Source.Server, RecurringDeposit.UpdatedByUserName, RecurringDeposit.AccountNo, RecurringDeposit.MachineName); DataBase.DBService.CommitTransaction(); } catch (Exception ex) { DataBase.DBService.RollbackTransaction(); StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); throw ex; } }