private InvestmentSegment getInvestmentSegmentData() { InvestmentSegment invSeg = new InvestmentSegment(); invSeg.RiskProfileId = _riskProfileId; invSeg.Id = int.Parse(txtSegmentName.Tag.ToString()); invSeg.SegmentName = txtSegmentName.Text; if (rdoEquity.Checked) { invSeg.InvestmentType = rdoEquity.Text; } if (rdoGold.Checked) { invSeg.InvestmentType = rdoGold.Text; } if (rdoDebt.Checked) { invSeg.InvestmentType = rdoDebt.Text; } invSeg.SegmentRatio = string.IsNullOrEmpty(txtSegmentRatio.Text) ? 0 : float.Parse(txtSegmentRatio.Text); invSeg.CreatedOn = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); invSeg.CreatedBy = Program.CurrentUser.Id; invSeg.UpdatedOn = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); invSeg.UpdatedBy = Program.CurrentUser.Id; invSeg.MachineName = Environment.MachineName; return(invSeg); }
private void btnSaveSegment_Click(object sender, EventArgs e) { InvestmentSegment invSegment = getInvestmentSegmentData(); bool isSaved = false; if (invSegment != null && invSegment.Id == 0) { isSaved = invBifurcationIno.Add(invSegment); } else { isSaved = invBifurcationIno.Update(invSegment); } if (isSaved) { MessageBox.Show("Record save successfully.", "Record Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); fillSegmentInfo(); grpSegment.Enabled = false; } else { MessageBox.Show("Unable to save record.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Update(InvestmentSegment investmentSegment) { try { string riskProfileName = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_RISK_PROFILE_NAME_QUERY, investmentSegment.RiskProfileId)); DataBase.DBService.BeginTransaction(); DataBase.DBService.ExecuteCommandString(string.Format(UPDATE_QUERY, investmentSegment.InvestmentType, investmentSegment.SegmentName, investmentSegment.SegmentRatio, investmentSegment.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"), investmentSegment.UpdatedBy, investmentSegment.Id), true); Activity.ActivitiesService.Add(ActivityType.UpdateInvestmentSegement, EntryStatus.Success, Source.Server, investmentSegment.UpdatedByUserName, investmentSegment.SegmentName, investmentSegment.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 <InvestmentSegment> GetAll(int riskProfileId) { try { Logger.LogInfo("Get: Investment segment process start"); IList <InvestmentSegment> investmentSegments = new List <InvestmentSegment>(); DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL, riskProfileId)); foreach (DataRow dr in dtAppConfig.Rows) { InvestmentSegment riskPrfile = convertToInvestmentSegmentObject(dr); investmentSegments.Add(riskPrfile); } Logger.LogInfo("Get: Investment segment process completed."); return(investmentSegments); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); return(null); } }
private InvestmentSegment convertToInvestmentSegmentObject(DataRow dr) { InvestmentSegment invSeg = new InvestmentSegment(); invSeg.Id = dr.Field <int>("ID"); invSeg.RiskProfileId = dr.Field <int>("RISKPROFIILEID"); invSeg.InvestmentType = dr.Field <string>("InvestmentType"); invSeg.SegmentName = dr.Field <string>("SegmentName"); invSeg.SegmentRatio = float.Parse(dr["SegmentRatio"].ToString()); return(invSeg); }
private void btnDeleteSegment_Click(object sender, EventArgs e) { if (dtGridSegment.SelectedRows.Count > 0) { if (MessageBox.Show("Are you sure, you want to delete this record?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { InvestmentSegment invSegment = getInvestmentSegmentData(); invBifurcationIno.Delete(invSegment); fillSegmentInfo(); } } }
public Result Delete(InvestmentSegment investmentSegment) { var result = new Result(); try { InvestmentSegmentService invSegmentService = new InvestmentSegmentService(); invSegmentService.Delete(investmentSegment); result.IsSuccess = true; } catch (Exception exception) { result.IsSuccess = false; result.ExceptionInfo = exception; } return(result); }
internal bool Delete(InvestmentSegment invSegment) { try { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + DELETE_InvestmentSegment_API; RestAPIExecutor restApiExecutor = new RestAPIExecutor(); var restResult = restApiExecutor.Execute <InvestmentSegment>(apiurl, invSegment, "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); } }