public int InsertLoanCycle(LoanCycle loanCycle)
{
if (_productManager.IsLoanCycleNameAlreadyExist(loanCycle.Name))
throw new OpenCbsPackageSaveException(OpenCbsPackageSaveExceptionEnum.LoanCycleNameAlreadyExists);
using (SqlConnection conn = _productManager.GetConnection())
using (SqlTransaction t = conn.BeginTransaction())
{
try
{
loanCycle.Id = _productManager.InsertLoanCycle(loanCycle, t);
t.Commit();
return loanCycle.Id;
}
catch (Exception ex)
{
t.Rollback();
throw ex;
}
}
}
public List<LoanCycle> SelectLoanCycles()
{
List<LoanCycle> loanCycles = new List<LoanCycle>();
string q = @"SELECT [id], [name] FROM [dbo].[Cycles]";
using (SqlConnection conn = GetConnection())
using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
using (OpenCbsReader r = c.ExecuteReader())
{
while (r.Read())
{
LoanCycle loanCycle = new LoanCycle();
loanCycle.Id = r.GetInt("id");
loanCycle.Name = r.GetString("name");
loanCycles.Add(loanCycle);
}
}
return loanCycles;
}
private void buttonNewAmountCycles_Click(object sender, EventArgs e)
{
try
{
InputBox inputBox = new InputBox();
string inputBoxText = MultiLanguageStrings.GetString(Ressource.PackagesForm, "InputNameCaption.Text");
inputBox.Text = inputBoxText;
inputBox.ShowDialog();
if (inputBox.Result != null)
{
listViewLoanCycles.Items.Clear();
buttonRemoveAmountCycles.Enabled = false;
buttonAmountCyclesSave.Enabled = false;
buttonAddAmountCycle.Enabled = true;
panelAmountCycles.Enabled = true;
panelAmountCycles.Visible = true;
groupBoxAmountCycle.Text = MultiLanguageStrings.GetString(Ressource.FrmAddLoanProduct, "messageAmountCycle.Text");
buttonSave.Enabled = true;
LoanCycle loanCycle = new LoanCycle();
loanCycle.Name = inputBox.Result;
loanCycle.Id = ServicesProvider.GetInstance().GetProductServices().InsertLoanCycle(loanCycle);
InitializeComboBoxLoanCycles();
SelectLoanCycleItemInComboBox(loanCycle.Id);
groupBoxAmountCycle.Text = MultiLanguageStrings.GetString(Ressource.FrmAddLoanProduct, "messageAmountCycle.Text");
}
}
catch (Exception ex)
{
new frmShowError(CustomExceptionHandler.ShowExceptionText(ex)).ShowDialog();
}
}
/// <summary>
/// Add a loan cycle into the databse
/// </summary>
/// <param name="loanCycle">An instance of the class LoanCycle</param>
/// <param name="transac">SQL transaction</param>
/// <returns></returns>
public int InsertLoanCycle(LoanCycle loanCycle, SqlTransaction t)
{
const string q = "INSERT INTO Cycles (name) VALUES (@name) SELECT SCOPE_IDENTITY()";
using (OpenCbsCommand c = new OpenCbsCommand(q, t.Connection, t))
{
c.AddParam("@name", loanCycle.Name);
return Convert.ToInt32(c.ExecuteScalar());
}
}