public IList <RecommendedSchemes> GetAll(int investmentsegmentid)
{
try
{
Logger.LogInfo("Get: Recommended scheme process start");
IList <RecommendedSchemes> RecommededSchemess = new List <RecommendedSchemes>();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL, investmentsegmentid));
foreach (DataRow dr in dtAppConfig.Rows)
{
RecommendedSchemes riskPrfile = convertToRecommededSchemesObject(dr);
RecommededSchemess.Add(riskPrfile);
}
Logger.LogInfo("Get: Recommended scheme process completed.");
return(RecommededSchemess);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
public void Update(RecommendedSchemes recommededSchemes)
{
try
{
string riskProfileName = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_RISK_PROFILE_NAME_QUERY, recommededSchemes.InvestmentSegmentID));
DataBase.DBService.BeginTransaction();
DataBase.DBService.ExecuteCommandString(string.Format(UPDATE_QUERY,
recommededSchemes.SchemeName,
recommededSchemes.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"),
recommededSchemes.UpdatedBy,
recommededSchemes.Id), true);
Activity.ActivitiesService.Add(ActivityType.UpdateSchemes, EntryStatus.Success,
Source.Server, recommededSchemes.UpdatedByUserName, riskProfileName, recommededSchemes.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 void btnSchemeSave_Click(object sender, EventArgs e)
{
RecommendedSchemes recommendedSchemes = getRecommendedSchemesData();
bool isSaved = false;
if (recommendedSchemes != null && recommendedSchemes.Id == 0)
{
isSaved = invBifurcationIno.Add(recommendedSchemes);
}
else
{
isSaved = invBifurcationIno.Update(recommendedSchemes);
}
if (isSaved)
{
MessageBox.Show("Record save successfully.", "Record Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
fillupSchemes();
grpScheme.Enabled = false;
}
else
{
MessageBox.Show("Unable to save record.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private RecommendedSchemes convertToRecommededSchemesObject(DataRow dr)
{
RecommendedSchemes invSeg = new RecommendedSchemes();
invSeg.Id = dr.Field <int>("ID");
invSeg.InvestmentSegmentID = dr.Field <int>("InvestmentSegmentID");
invSeg.SchemeName = dr.Field <string>("SchemeName");
return(invSeg);
}
private void btnDeleteScheme_Click(object sender, EventArgs e)
{
if (lstSchemeName.SelectedItems.Count > 0)
{
if (MessageBox.Show("Are you sure, you want to delete this record?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
RecommendedSchemes recommendedSchemes = getRecommendedSchemesData();
invBifurcationIno.Delete(recommendedSchemes);
fillupSchemes();
}
}
}
private RecommendedSchemes getRecommendedSchemesData()
{
RecommendedSchemes recScheme = new RecommendedSchemes();
recScheme.Id = int.Parse(txtSchemeName.Tag.ToString());
recScheme.InvestmentSegmentID = int.Parse(txtSegmentName.Tag.ToString());
recScheme.SchemeName = txtSchemeName.Text;
recScheme.CreatedOn = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
recScheme.CreatedBy = Program.CurrentUser.Id;
recScheme.UpdatedOn = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
recScheme.UpdatedBy = Program.CurrentUser.Id;
recScheme.UpdatedByUserName = Program.CurrentUser.UserName;
recScheme.MachineName = System.Environment.MachineName;
return(recScheme);
}
public Result Delete(RecommendedSchemes RecommededSchemes)
{
var result = new Result();
try
{
RecommendedSchemesService recommendedSchemesService = new RecommendedSchemesService();
recommendedSchemesService.Delete(RecommededSchemes);
result.IsSuccess = true;
}
catch (Exception exception)
{
result.IsSuccess = false;
result.ExceptionInfo = exception;
}
return(result);
}
internal bool Delete(RecommendedSchemes recommendedSchemes)
{
try
{
FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization();
string apiurl = Program.WebServiceUrl + "/" + DELETE_RECOMMENDEDSCHEME;
RestAPIExecutor restApiExecutor = new RestAPIExecutor();
var restResult = restApiExecutor.Execute <RecommendedSchemes>(apiurl, recommendedSchemes, "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);
}
}
