public void Add(SCSS SCSS)
{
try
{
string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(SELECT_ID, SCSS.Id));
DataBase.DBService.BeginTransaction();
DataBase.DBService.ExecuteCommandString(string.Format(INSERT_SCSS,
SCSS.Pid, SCSS.InvesterName, SCSS.AccountNo,
SCSS.Bank,
SCSS.OpeningDate.ToString("yyyy-MM-dd hh:mm:ss"),
SCSS.MaturityDate.ToString("yyyy-MM-dd hh:mm:ss"),
SCSS.CurrentValue,
SCSS.GoalId,
SCSS.CreatedOn.ToString("yyyy-MM-dd hh:mm:ss"), SCSS.CreatedBy,
SCSS.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"), SCSS.UpdatedBy,
SCSS.InvestmentReturnRate), true);
Activity.ActivitiesService.Add(ActivityType.CreateSCSS, EntryStatus.Success,
Source.Server, SCSS.UpdatedByUserName, SCSS.AccountNo, SCSS.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 <SCSS> GetAll(int plannerId)
{
try
{
Logger.LogInfo("Get: SCSS process start");
IList <SCSS> lstSCSSOption = new List <SCSS>();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL, plannerId));
foreach (DataRow dr in dtAppConfig.Rows)
{
SCSS mf = convertToSCSS(dr);
lstSCSSOption.Add(mf);
}
Logger.LogInfo("Get: SCSS fund process completed.");
return(lstSCSSOption);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
public Result Delete(SCSS SCSS)
{
var result = new Result();
try
{
SCSSService SCSSService = new SCSSService();
SCSSService.Delete(SCSS);
result.IsSuccess = true;
}
catch (Exception exception)
{
result.IsSuccess = false;
result.ExceptionInfo = exception;
}
return(result);
}
internal bool Update(SCSS SCSS)
{
try
{
FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization();
string apiurl = Program.WebServiceUrl + "/" + UPDATE_SCSS_API;
RestAPIExecutor restApiExecutor = new RestAPIExecutor();
var restResult = restApiExecutor.Execute <SCSS>(apiurl, SCSS, "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);
}
}
private SCSS convertToSCSS(DataRow dr)
{
SCSS SCSS = new SCSS();
SCSS.Id = dr.Field <int>("ID");
SCSS.Pid = dr.Field <int>("PID");
SCSS.InvesterName = dr.Field <string>("InvesterName");
SCSS.AccountNo = dr.Field <string>("AccountNo");
SCSS.Bank = dr.Field <string>("Bank");
SCSS.OpeningDate = dr.Field <DateTime>("OpeningDate");
SCSS.CurrentValue = Double.Parse(dr["CurrentValue"].ToString());
SCSS.MaturityDate = dr.Field <DateTime>("MaturityDate");
SCSS.GoalId = dr.Field <int>("GoalId");
SCSS.UpdatedBy = dr.Field <int>("UpdatedBy");
SCSS.UpdatedOn = dr.Field <DateTime>("UpdatedOn");
SCSS.UpdatedByUserName = dr.Field <string>("UpdatedByUserName");
SCSS.UpdatedBy = dr.Field <int>("UpdatedBy");
SCSS.UpdatedOn = dr.Field <DateTime>("UpdatedOn");
SCSS.UpdatedByUserName = dr.Field <string>("UpdatedByUserName");
SCSS.InvestmentReturnRate = float.Parse(dr["InvestmentReturnRate"].ToString());
return(SCSS);
}
public SCSS Get(int id)
{
try
{
Logger.LogInfo("Get: SCSS by id process start");
SCSS SCSS = new SCSS();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ID, id));
foreach (DataRow dr in dtAppConfig.Rows)
{
SCSS = convertToSCSS(dr);
}
Logger.LogInfo("Get: SCSS by id process completed");
return(SCSS);
}
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(SCSS SCSS)
{
try
{
string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(SELECT_ID, SCSS.Id));
DataBase.DBService.BeginTransaction();
DataBase.DBService.ExecuteCommandString(string.Format(DELETE_SCSS,
SCSS.Id), true);
Activity.ActivitiesService.Add(ActivityType.DeleteSCSS, EntryStatus.Success,
Source.Server, SCSS.UpdatedByUserName, SCSS.AccountNo, SCSS.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;
}
}
