private void tsbSave_Click(object sender, EventArgs e)
{
var header = new clsInstallmentPlan();
header.strInstallmentPlanName = txtPlanName.Text.Trim();
header.strIntallmentPlanCode = txtPlanCode.Text.Trim();
header.bInactive = chkInactive.Checked;
int PlanID = 0;
var result = da.AddInstallmentPlan(header, ref PlanID);
List <clsInstallmentPlanDetails> lst = new List <clsInstallmentPlanDetails>();
foreach (DataGridViewRow dgr in dgInstallments.Rows)
{
clsInstallmentPlanDetails detail = new clsInstallmentPlanDetails();
detail.strInstallmentPlanCode = txtPlanCode.Text;
detail.intInstallmentDueAfterMonths = Convert.ToInt32(dgr.Cells["DueAfter"].Value);
detail.intInstallmentPercentage = Convert.ToInt32(dgr.Cells["Percentage"].Value);
detail.intInstallmentNumber = Convert.ToInt32(dgr.Cells["SNo"].Value);
detail.intInstallmentType = Convert.ToInt32(dgr.Cells["InstallmentTypeId"].Value);
detail.intId = Convert.ToInt32(dgr.Cells["InstallmentId"].Value);
detail.intInstallmentPlanID = PlanID;
lst.Add(detail);
}
foreach (var item in lst)
{
result = da.AddInstallmentPlanDetail(item);
}
}
private void tsbSave_Click(object sender, EventArgs e)
{
if (txtPlanCode.Text.Trim() == "")
{
MessageBox.Show("Please enter a plan code.");
return;
}
if (txtPlanName.Text.Trim() == "")
{
MessageBox.Show("Please enter a plan name.");
return;
}
int intNumber = 0;
bool result = false;
result = Int32.TryParse(txtInstallments.Text, out intNumber);
if (result == false || intNumber <= 0)
{
MessageBox.Show("Number of installments is not valid.");
return;
}
result = Int32.TryParse(txtStartAfterBooking.Text, out intNumber);
if (result == false || intNumber <= 0)
{
MessageBox.Show("Start after booking number is not valid.");
return;
}
decimal decNumber = 0;
result = decimal.TryParse(txtInstallmentAmount.Text, out decNumber);
if (result == false || decNumber <= 0)
{
MessageBox.Show("Installment amount is not valid.");
return;
}
var header = new clsInstallmentPlan();
header.strInstallmentPlanName = txtPlanName.Text.Trim();
header.strIntallmentPlanCode = txtPlanCode.Text.Trim();
header.bInactive = chkInactive.Checked;
if (cmbFrequency.Text == "Monthly")
{
header.intInstallmentFrequency = 1;
}
else if (cmbFrequency.Text == "BiMonthly")
{
header.intInstallmentFrequency = 2;
}
else if (cmbFrequency.Text == "Quaterly")
{
header.intInstallmentFrequency = 3;
}
else if (cmbFrequency.Text == "BiAnnually")
{
header.intInstallmentFrequency = 4;
}
else if (cmbFrequency.Text == "Annually")
{
header.intInstallmentFrequency = 5;
}
header.intNoOfInstallments = Convert.ToInt32(txtInstallments.Text);
header.intInstallmentStartAfter = Convert.ToInt32(txtStartAfterBooking.Text);
header.decInstallmentAmount = Convert.ToDecimal(txtInstallmentAmount.Text);
header.strProjectNo = cmbProject.Text;
header.strSizeCode = cmbSizeCode.Text;
header.intId = id;
int PlanID = 0;
var res = da.AddInstallmentPlan(header, ref PlanID);
List <clsOtherRecoveryPlan> lstRecPlanRow = new List <clsOtherRecoveryPlan>();
foreach (DataGridViewRow dgr in dgList.Rows)
{
var recPlanRow = new clsOtherRecoveryPlan();
recPlanRow.intInstallmentNo = Convert.ToInt32(dgr.Cells["InstallmentNo"].Value);
recPlanRow.strRecoveryType = dgr.Cells["RecoveryType"].Value.ToString();
recPlanRow.intRecoveryTypeid = Convert.ToInt32(dgr.Cells["RecoveryTypeid"].Value);
recPlanRow.strSizeCode = cmbSizeCode.Text;
recPlanRow.strProject = cmbProject.Text;
recPlanRow.strPlan = txtPlanCode.Text;
recPlanRow.decAmountDue = Convert.ToDecimal(dgr.Cells["AmountDue"].Value);
recPlanRow.intDueAfterMonths = Convert.ToInt32(dgr.Cells["DueAfterMonths"].Value);
lstRecPlanRow.Add(recPlanRow);
}
if (lstRecPlanRow.Count > 0)
{
result = da.DeleteOtherRecoveryPlan(txtPlanCode.Text);
if (result == false)
{
MessageBox.Show("Operation failed. Please contact system administrator.");
return;
}
result = da.AddOtherRecoveryPlan(lstRecPlanRow);
if (result == false)
{
MessageBox.Show("Operation failed. Please contact system administrator.");
return;
}
}
Clear();
}
