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;
}
}
