public IList <ULIP> GetAll(int plannerId)
{
try
{
Logger.LogInfo("Get: Mutual fund process start");
IList <ULIP> lstULIPOption = new List <ULIP>();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL, plannerId));
foreach (DataRow dr in dtAppConfig.Rows)
{
ULIP mf = convertToULIP(dr);
lstULIPOption.Add(mf);
}
Logger.LogInfo("Get: Mutual fund process completed.");
return(lstULIPOption);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
public void Add(ULIP ULIP)
{
try
{
string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(SELECT_ID, ULIP.Id));
DataBase.DBService.BeginTransaction();
DataBase.DBService.ExecuteCommandString(string.Format(INSERT_ULIP,
ULIP.Pid, ULIP.InvesterName, ULIP.SchemeName,
ULIP.FolioNo,
ULIP.Nav, ULIP.Units, ULIP.EquityRatio,
ULIP.GoldRatio, ULIP.DebtRatio, ULIP.SIP, ULIP.FreeUnit,
ULIP.RedumptionAmount, ULIP.GoalID,
ULIP.CreatedOn.ToString("yyyy-MM-dd hh:mm:ss"), ULIP.CreatedBy,
ULIP.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"), ULIP.UpdatedBy,
ULIP.FirstHolder, ULIP.SecondHolder, ULIP.Nominee,
ULIP.InvestmentReturnRate), true);
Activity.ActivitiesService.Add(ActivityType.CreateULIP, EntryStatus.Success,
Source.Server, ULIP.UpdatedByUserName, "ULIP", ULIP.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;
}
}
private ULIP convertToULIP(DataRow dr)
{
ULIP ULIP = new ULIP();
ULIP.Id = dr.Field <int>("ID");
ULIP.Pid = dr.Field <int>("PID");
ULIP.InvesterName = dr.Field <string>("InvesterName");
ULIP.SchemeName = dr.Field <string>("SchemeName");
ULIP.FolioNo = dr.Field <string>("FolioNo");
ULIP.Nav = float.Parse(dr["NAV"].ToString());
ULIP.Units = dr.Field <int>("units");
ULIP.EquityRatio = float.Parse(dr["EquityRatio"].ToString());
ULIP.GoldRatio = float.Parse(dr["GoldRatio"].ToString());
ULIP.DebtRatio = float.Parse(dr["DebtRatio"].ToString());
ULIP.SIP = double.Parse(dr["SIP"].ToString());
ULIP.FreeUnit = dr.Field <int>("FreeUnits");
ULIP.RedumptionAmount = double.Parse(dr["RedumptionAmount"].ToString());
ULIP.GoalID = dr.Field <int>("GoalId");
ULIP.UpdatedBy = dr.Field <int>("UpdatedBy");
ULIP.UpdatedOn = dr.Field <DateTime>("UpdatedOn");
ULIP.UpdatedByUserName = dr.Field <string>("UpdatedByUserName");
ULIP.FirstHolder = dr.Field <string>("FirstHolder");
ULIP.SecondHolder = dr.Field <string>("SecondHolder");
ULIP.Nominee = dr.Field <string>("Nominee");
ULIP.InvestmentReturnRate = float.Parse(dr["InvestmentReturnRate"].ToString());
return(ULIP);
}
public Result Delete(ULIP ulip)
{
var result = new Result();
try
{
ULIPService ULIPService = new ULIPService();
ULIPService.Delete(ulip);
result.IsSuccess = true;
}
catch (Exception exception)
{
result.IsSuccess = false;
result.ExceptionInfo = exception;
}
return(result);
}
internal bool Update(ULIP ULIP)
{
try
{
FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization();
string apiurl = Program.WebServiceUrl + "/" + UPDATE_ULIP_API;
RestAPIExecutor restApiExecutor = new RestAPIExecutor();
var restResult = restApiExecutor.Execute <ULIP>(apiurl, ULIP, "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 ULIP Get(int id)
{
try
{
Logger.LogInfo("Get: Mutual fund by id process start");
ULIP ULIP = new ULIP();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ID, id));
foreach (DataRow dr in dtAppConfig.Rows)
{
ULIP = convertToULIP(dr);
}
Logger.LogInfo("Get: Mutual fund by id process completed");
return(ULIP);
}
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(ULIP ULIP)
{
try
{
string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(SELECT_ID, ULIP.Id));
DataBase.DBService.BeginTransaction();
DataBase.DBService.ExecuteCommandString(string.Format(DELETE_ULIP,
ULIP.Id), true);
Activity.ActivitiesService.Add(ActivityType.DeleteULIP, EntryStatus.Success,
Source.Server, ULIP.UpdatedByUserName, "ULIP", ULIP.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;
}
}
