public void Add(LumsumInvestmentRecomendation lumsumInvestmentRecomendation)
{
try
{
DataBase.DBService.ExecuteCommand(string.Format(INSERT_LUMSUM,
lumsumInvestmentRecomendation.Pid,
lumsumInvestmentRecomendation.SchemeId,
lumsumInvestmentRecomendation.Amount,
lumsumInvestmentRecomendation.ChequeInFavourOff,
lumsumInvestmentRecomendation.FirstHolder,
lumsumInvestmentRecomendation.SecondHolder,
lumsumInvestmentRecomendation.CreatedOn.ToString("yyyy-MM-dd hh:mm:ss"),
lumsumInvestmentRecomendation.CreatedBy,
lumsumInvestmentRecomendation.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"),
lumsumInvestmentRecomendation.UpdatedBy,
lumsumInvestmentRecomendation.ThirdHolder,
lumsumInvestmentRecomendation.Nominee));
Activity.ActivitiesService.Add(ActivityType.CreateInvestmentRecommendation, EntryStatus.Success,
Source.Server, lumsumInvestmentRecomendation.UpdatedByUserName, lumsumInvestmentRecomendation.SchemeName, lumsumInvestmentRecomendation.MachineName);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
public Result Delete(LumsumInvestmentRecomendation lumsumInvestmentRecomendation)
{
var result = new Result();
try
{
LumsumInvestmentRecomendationService lumsumInvestmentRecomendationService =
new LumsumInvestmentRecomendationService();
lumsumInvestmentRecomendationService.Delete(lumsumInvestmentRecomendation);
result.IsSuccess = true;
}
catch (Exception exception)
{
result.IsSuccess = false;
result.ExceptionInfo = exception;
}
return(result);
}
private LumsumInvestmentRecomendation convertToLumsumInvestmentRecomendationObject(DataRow dr)
{
LumsumInvestmentRecomendation lumsumInvestmentRecomendation = new LumsumInvestmentRecomendation();
lumsumInvestmentRecomendation.Pid = dr.Field <int>("PId");
lumsumInvestmentRecomendation.SchemeId = dr.Field <int>("SchemeId");
lumsumInvestmentRecomendation.SchemeName = dr.Field <string>("SchemeName");
lumsumInvestmentRecomendation.Amount = double.Parse(dr["Amount"].ToString());
lumsumInvestmentRecomendation.Category = dr.Field <string>("Category");
lumsumInvestmentRecomendation.ChequeInFavourOff = dr.Field <string>("ChequeInfavourOff");
lumsumInvestmentRecomendation.FirstHolder = dr.Field <string>("FirstHolder");
lumsumInvestmentRecomendation.SecondHolder = dr.Field <string>("SecondHolder");
lumsumInvestmentRecomendation.ThirdHolder = dr.Field <string>("ThirdHolder");
lumsumInvestmentRecomendation.Type = dr.Field <string>("Type");
lumsumInvestmentRecomendation.AMC = dr.Field <string>("AMC");
lumsumInvestmentRecomendation.Nominee = dr.Field <string>("Nominee");
return(lumsumInvestmentRecomendation);
}
public void Delete(LumsumInvestmentRecomendation lumsumInvestmentRecomendation)
{
try
{
string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_CLIENT_NAME_QUERY, lumsumInvestmentRecomendation.Pid));
DataBase.DBService.ExecuteCommand(string.Format(DELETE_QUERY,
lumsumInvestmentRecomendation.Pid, lumsumInvestmentRecomendation.SchemeId, lumsumInvestmentRecomendation.Amount));
Activity.ActivitiesService.Add(ActivityType.DeleteInvestmentRecommendation, EntryStatus.Success,
Source.Server, lumsumInvestmentRecomendation.UpdatedByUserName, lumsumInvestmentRecomendation.SchemeName,
lumsumInvestmentRecomendation.MachineName);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
public IList <LumsumInvestmentRecomendation> GetAll(int plannerId)
{
IList <LumsumInvestmentRecomendation> lumsumInvestmentRecomendations = new List <LumsumInvestmentRecomendation>();
try
{
Logger.LogInfo("Get: Lumsum investment process start");
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL, plannerId));
foreach (DataRow dr in dtAppConfig.Rows)
{
LumsumInvestmentRecomendation lumsumInvestmentRecomendation = convertToLumsumInvestmentRecomendationObject(dr);
lumsumInvestmentRecomendations.Add(lumsumInvestmentRecomendation);
}
Logger.LogInfo("Get: Lumsum investment process completed.");
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
}
return(lumsumInvestmentRecomendations);
}
