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(); }