private void buttonAddAmountCycle_Click(object sender, EventArgs e)
{
int loanCycle;
if (listViewLoanCycles.Items.Count == 0)
loanCycle = 0;
else
loanCycle = ((Cycle)listViewLoanCycles.Items[listViewLoanCycles.Items.Count - 1].Tag).LoanCycle + 1;
textBoxCycleMin.TextChanged -= textBoxCycleMin_TextChanged;
textBoxCycleMax.TextChanged -= textBoxCycleMax_TextChanged;
textBoxCycleMin.Text = "0";
textBoxCycleMax.Text = "0";
textBoxCycleMin.TextChanged += textBoxCycleMin_TextChanged;
textBoxCycleMax.TextChanged += textBoxCycleMax_TextChanged;
buttonRemoveAmountCycles.Enabled = true;
buttonAmountCyclesSave.Enabled = true;
int cycleObjectId = ((CycleObject)cbxCycleObjects.SelectedItem).Id;
switch (cycleObjectId)
{
case 1:
var parameter = new LoanAmountCycle
{
CycleId = ((LoanCycle)comboBoxLoanCyclesName.SelectedItem).Id,
CycleObjectId = cycleObjectId,
Min = 0,
Max = 0,
LoanCycle = loanCycle
};
var amountCycleItem = new ListViewItem((parameter.LoanCycle + 1).ToString()) { Tag = parameter };
amountCycleItem.SubItems.Add(parameter.Min.ToString());
amountCycleItem.SubItems.Add(parameter.Max.ToString());
listViewLoanCycles.Items.Add(amountCycleItem);
_product.LoanAmountCycleParams.Add(parameter);
break;
case 2:
var rateCycleParam = new RateCycle
{
CycleId = ((LoanCycle)comboBoxLoanCyclesName.SelectedItem).Id,
CycleObjectId = cycleObjectId,
Min = 0,
Max = 0,
LoanCycle = loanCycle
};
var interestRateCycleItem = new ListViewItem((rateCycleParam.LoanCycle + 1).ToString()) { Tag = rateCycleParam };
interestRateCycleItem.SubItems.Add(rateCycleParam.Min.ToString());
interestRateCycleItem.SubItems.Add(rateCycleParam.Max.ToString());
listViewLoanCycles.Items.Add(interestRateCycleItem);
_product.RateCycleParams.Add(rateCycleParam);
break;
case 3:
var maturityCycleParam = new MaturityCycle
{
CycleId = ((LoanCycle)comboBoxLoanCyclesName.SelectedItem).Id,
CycleObjectId = cycleObjectId,
Min = 0,
Max = 0,
LoanCycle = loanCycle
};
var maturityCycleItem = new ListViewItem((maturityCycleParam.LoanCycle + 1).ToString()) { Tag = maturityCycleParam };
maturityCycleItem.SubItems.Add(maturityCycleParam.Min.ToString());
maturityCycleItem.SubItems.Add(maturityCycleParam.Max.ToString());
listViewLoanCycles.Items.Add(maturityCycleItem);
_product.MaturityCycleParams.Add(maturityCycleParam);
break;
default: break;
}
listViewLoanCycles.Items[listViewLoanCycles.Items.Count - 1].Selected = true;
}
private List<MaturityCycle> GetMaturityCycles()
{
var maturityCycle = new MaturityCycle();
maturityCycle.CycleId = 2;
maturityCycle.LoanCycle = 0;
maturityCycle.CycleObjectId = 3;
maturityCycle.Min = 10;
maturityCycle.Max = 20;
var maturityCycles = new List<MaturityCycle>();
maturityCycles.Add(maturityCycle);
maturityCycle = new MaturityCycle();
maturityCycle.CycleId = 2;
maturityCycle.LoanCycle = 1;
maturityCycle.CycleObjectId = 3;
maturityCycle.Min = 20;
maturityCycle.Max = 30;
maturityCycles.Add(maturityCycle);
maturityCycle = new MaturityCycle();
maturityCycle.CycleId = 2;
maturityCycle.LoanCycle = 2;
maturityCycle.CycleObjectId = 3;
maturityCycle.Min = 30;
maturityCycle.Max = 40;
maturityCycles.Add(maturityCycle);
return maturityCycles;
}
public List<MaturityCycle> SelectMaturityCycleParams(int cycleId)
{
List<MaturityCycle> cycleParameters = new List<MaturityCycle>();
string q = @"SELECT [id]
,[loan_cycle]
,[min]
,[max]
,[cycle_object_id]
,[cycle_id]
FROM [dbo].[CycleParameters]
WHERE [cycle_object_id]=3
AND [cycle_id]=@cycle_id
ORDER BY [loan_cycle]";
using (SqlConnection conn = GetConnection())
using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
{
c.AddParam("@cycle_id", cycleId);
using (OpenCbsReader r = c.ExecuteReader())
{
while (r.Read())
{
MaturityCycle parameter = new MaturityCycle();
parameter.Id = r.GetInt("id");
parameter.LoanCycle = r.GetInt("loan_cycle");
parameter.Min = r.GetDecimal("min");
parameter.Max = r.GetDecimal("max");
parameter.CycleObjectId = r.GetInt("cycle_object_id");
parameter.CycleId = r.GetNullInt("cycle_id");
cycleParameters.Add(parameter);
}
}
}
return cycleParameters;
}
