private void DeleteSelectedAppRecord(string applicationID)
{
SqlConnection conn = ConnectDB.GetConnection();
string strDelete = "Delete from LoanApplication where LoanApplicationID=" + applicationID;
SqlCommand cmd = new SqlCommand(strDelete, conn);
try
{
conn.Open();
int rowAffected = cmd.ExecuteNonQuery();
if (rowAffected > 0)
{
//MessageBox.Show("The Selected Record has been Deleted", "Loan Application", MessageBoxButtons.OK, MessageBoxIcon.Information);
strFilterMonth = string.Empty;
strFilterYear = string.Empty;
loadAllLoanApplicationRecords(strFilterMonth, strFilterYear);
string userId = this.MdiParent.Controls["lblLoggedInUserID"].Text;
ActivityLog.logActivity(userId, "Delete Loan Application", "Loan Application with ID - " + applicationID + " was deleted.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
private void ExecuteDeleteOps(string savingsID)
{
SqlConnection conn = ConnectDB.GetConnection();
try
{
conn.Open();
SqlTransaction sqlTrans = conn.BeginTransaction();
SqlCommand cmd = conn.CreateCommand();
cmd.Transaction = sqlTrans;
string strQuery1 = "Delete from SavingsWithdrawal where savingsID='" + savingsID + "'";
string strQuery2 = "Delete from Savings where savingsID='" + savingsID + "'";
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery1;
int rowAffected = cmd.ExecuteNonQuery();
if (rowAffected > 0)
{
cmd.CommandText = strQuery2;
rowAffected = cmd.ExecuteNonQuery();
if (rowAffected > 0)
{
sqlTrans.Commit();
MessageBox.Show("The Selected Record has been deleted.", "Withdrawal", MessageBoxButtons.OK, MessageBoxIcon.Information);
string logMessage = "Withdrawal Record DELETED with Savings ID: " + savingsID + ", Savings Type: " + savingsType + ", Amount: " + withdrawalAmt;
ActivityLog.logActivity(UserId, "Withdrawal", logMessage);
DeleteWithdrawal deleteWithdrawal = new DeleteWithdrawal(UserId);
deleteWithdrawal.MdiParent = this.ParentForm;
deleteWithdrawal.Show();
this.Close();
}
else
{
sqlTrans.Rollback();
MessageBox.Show("An error occurred! Operation has been aborted.", "Withdrawal", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
sqlTrans.Rollback();
MessageBox.Show("An error occurred! Operation has been aborted.", "Withdrawal", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
private void logUserActivity(string userId, string ActivityType, string Description)
{
ActivityLog.logActivity(userId, ActivityType, Description);
}
private void saveLoanApplication()
{
SqlConnection conn = ConnectDB.GetConnection();
string strQuery = "Insert into LoanApplication(AppMonth,AppYear,MemberID,LoanCategoryID,LoanTypeID," +
"LoanAmount,FormFee,StartRepaymentMonth,StartRepaymentYear,SuretyMemberID1,SuretyMemberID2,WitnessMemberID," +
"NonMemberSurety1,NonMemberSurety2,NonMemberWitness,LoanDuration,InterestRate,InterestAmount," +
"TotalRepayment,MonthlyRepayment,TransactionID)values(@AppMonth,@AppYear,@MemberID,@LoanCategoryID,@LoanTypeID," +
"@LoanAmount,@FormFee,@StartRepaymentMonth,@StartRepaymentYear,@SuretyMemberID1,@SuretyMemberID2,@WitnessMemberID," +
"@NonMemberSurety1,@NonMemberSurety2,@NonMemberWitness,@LoanDuration,@InterestRate,@InterestAmount," +
"@TotalRepayment,@MonthlyRepayment,@TransactionID)";
string transactionID = "LOA" + DateTime.Now.ToString("ddMMyyhhmmss");
SqlCommand cmd = new SqlCommand(strQuery, conn);
#region parameters
cmd.Parameters.Add("@AppMonth", SqlDbType.Int);
cmd.Parameters["@AppMonth"].Value = DateFunction.getMonthByDate(cboMonth.Text);
cmd.Parameters.Add("@AppYear", SqlDbType.Int);
cmd.Parameters["@AppYear"].Value = Convert.ToInt32(cboYear.Text);
cmd.Parameters.Add("@MemberID", SqlDbType.Int);
cmd.Parameters["@MemberID"].Value = memberID;
cmd.Parameters.Add("@LoanCategoryID", SqlDbType.Int);
cmd.Parameters["@LoanCategoryID"].Value = Convert.ToInt32(cboCategory.SelectedValue.ToString());
cmd.Parameters.Add("@LoanTypeID", SqlDbType.Int);
cmd.Parameters["@LoanTypeID"].Value = Convert.ToInt32(cboType.SelectedValue.ToString());
cmd.Parameters.Add("@LoanAmount", SqlDbType.Decimal);
cmd.Parameters["@LoanAmount"].Value = Convert.ToDecimal(txtAmount.Text);
cmd.Parameters.Add("@FormFee", SqlDbType.Decimal);
cmd.Parameters["@FormFee"].Value = Convert.ToDecimal(txtFormFee.Text);
int startRepaymentMonth = 0;
int startRepaymentYear = 0;
if ((chkStartRepayment.Checked == true) && (cboStartRepaymentMonth.Text != string.Empty) && (cboStartRepaymentYear.Text != string.Empty))
{
startRepaymentMonth = DateFunction.getMonthByDate(cboStartRepaymentMonth.Text);
startRepaymentYear = Convert.ToInt32(cboStartRepaymentYear.Text);
}
else
{
//DateTime currentDate = DateTime.Now;
//int currentMonth = currentDate.Month;
string strAppDate = cboMonth.Text + " " + cboYear.Text;
DateTime appDate = DateTime.Parse(strAppDate);
DateTime nextMonth = appDate.AddMonths(1);
startRepaymentMonth = nextMonth.Month;
startRepaymentYear = nextMonth.Year;
}
cmd.Parameters.Add("@StartRepaymentMonth", SqlDbType.Int);
cmd.Parameters["@StartRepaymentMonth"].Value = startRepaymentMonth;
cmd.Parameters.Add("@StartRepaymentYear", SqlDbType.Int);
cmd.Parameters["@StartRepaymentYear"].Value = startRepaymentYear;
cmd.Parameters.Add("@SuretyMemberID1", SqlDbType.NVarChar, 10);
cmd.Parameters["@SuretyMemberID1"].Value = lblSuretyMemberID_1.Text;
cmd.Parameters.Add("@SuretyMemberID2", SqlDbType.NVarChar, 10);
cmd.Parameters["@SuretyMemberID2"].Value = lblSuretyMemberID_2.Text;
cmd.Parameters.Add("@WitnessMemberID", SqlDbType.NVarChar, 10);
cmd.Parameters["@WitnessMemberID"].Value = lblSuretyMemberID_3.Text;
cmd.Parameters.Add("@NonMemberSurety1", SqlDbType.NVarChar, 100);
cmd.Parameters["@NonMemberSurety1"].Value = txtSuretyName1.Text;
cmd.Parameters.Add("@NonMemberSurety2", SqlDbType.NVarChar, 100);
cmd.Parameters["@NonMemberSurety2"].Value = txtSuretyName2.Text;
cmd.Parameters.Add("@NonMemberWitness", SqlDbType.NVarChar, 100);
cmd.Parameters["@NonMemberWitness"].Value = txtWitnessName.Text;
cmd.Parameters.Add("@LoanDuration", SqlDbType.Int);
cmd.Parameters["@LoanDuration"].Value = Convert.ToInt32(txtLoanDuration.Text);
cmd.Parameters.Add("@InterestRate", SqlDbType.Decimal);
cmd.Parameters["@InterestRate"].Value = Convert.ToDecimal(txtLoanInterestRate.Text);
cmd.Parameters.Add("@InterestAmount", SqlDbType.Decimal);
cmd.Parameters["@InterestAmount"].Value = Convert.ToDecimal(txtInterestAmount.Text);
cmd.Parameters.Add("@TotalRepayment", SqlDbType.Decimal);
cmd.Parameters["@TotalRepayment"].Value = Convert.ToDecimal(txtTotalRepaymentAmount.Text);
cmd.Parameters.Add("@MonthlyRepayment", SqlDbType.Decimal);
cmd.Parameters["@MonthlyRepayment"].Value = Convert.ToDecimal(txtMonthRepayment.Text);
cmd.Parameters.Add("@TransactionID", SqlDbType.NVarChar, 50);
cmd.Parameters["@TransactionID"].Value = transactionID;
#endregion
try
{
conn.Open();
int rowAffected = cmd.ExecuteNonQuery();
if (rowAffected > 0)
{
MessageBox.Show("Loan Application has been Successfully saved.", "Loan Application", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
clearAllFields();
string ActivityType = "Loan Application";
string Description = "Loan Application of " + cboType.Text + ". Amount: " + txtAmount.Text + " for " + cboFileNo.Text + " with TransactionID: " + transactionID;
ActivityLog.logActivity(userId, ActivityType, Description);
}
else
{
MessageBox.Show("An error has occurred!", "Loan Application", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}catch (Exception ex)
{
MessageBox.Show(ex.Message);
}finally
{
conn.Close();
}
}
private void executeDeduction()
{
int numOfRecords = lstDeductions.Items.Count;
int currentRecord;
SqlConnection conn = ConnectDB.GetConnection();
SqlTransaction sqlTrans = null;
SqlCommand cmd;
try
{
conn.Open();
sqlTrans = conn.BeginTransaction();
cmd = conn.CreateCommand();
cmd.Transaction = sqlTrans;
int selectedMonth = Convert.ToInt16(cboMonth.SelectedValue);
int selectedYear = Convert.ToInt16(cboYear.Text);
#region loop through records
//loop through records
for (currentRecord = 0; currentRecord < numOfRecords; currentRecord++)
{
cmd.Parameters.Clear();
memberID = Convert.ToInt16(lstDeductions.Items[currentRecord].SubItems[1].Text);
decimal monthlyLoanRepayment = Convert.ToDecimal(lstDeductions.Items[currentRecord].SubItems[5].Text);
decimal lstAllSavingsDeduction = Convert.ToDecimal(lstDeductions.Items[currentRecord].SubItems[4].Text);
decimal lstAllLoansDeduction = Convert.ToDecimal(lstDeductions.Items[currentRecord].SubItems[5].Text);
decimal lstTotalDeductions = Convert.ToDecimal(lstDeductions.Items[currentRecord].SubItems[6].Text);
totalSavings = Convert.ToDecimal(lstDeductions.Items[currentRecord].SubItems[4].Text);
string transactionID = "DED" + DateTime.Now.ToString("ddMMyyhhmmss");
Deduction newPosting = new Deduction();
string postSavingsStatus = newPosting.postSavings(conn, cmd, sqlTrans, memberID, transactionID, totalSavings, numOfRows, errorflag, selectedMonth, selectedYear);
//MessageBox.Show("Post Savings Status: " + postSavingsStatus);
string postLoansStatus = newPosting.postLoans(conn, cmd, sqlTrans, memberID, transactionID, currentRecord, selectedMonth, selectedYear, numOfRows, errorflag, monthlyLoanRepayment);
//MessageBox.Show("PostLoan Status: " + postLoansStatus);
string recordDeductionStatus = newPosting.recordDeduction(cmd, memberID, transactionID, currentRecord, selectedMonth, selectedYear, lstAllSavingsDeduction, lstAllLoansDeduction, lstTotalDeductions, numOfRows, errorflag);
//MessageBox.Show("Record Deductions status: " + recordDeductionStatus);
string recordDeductionDetailsStatus = newPosting.recordDeductionDetails(cmd, memberID, transactionID, currentRecord, numOfRows, errorflag, lstAllSavingsDeduction, lstAllLoansDeduction, repaymentLoanType, servicingLoan, loanMoreThanSavings);
//MessageBox.Show("Record Deduction Detail Status: " + recordDeductionDetailsStatus);
if (errorflag == 0)
{
//MessageBox.Show("Posted");
//lstDeductions.Items[currentRecord].SubItems[7].Text = "Posted";
}
}
//end of for loop
#endregion end of loop
if (errorflag == 0)
{
Deduction newDeductionPosting = new Deduction();
string deductionDateRecord = newDeductionPosting.recordDeductionDate(selectedMonth, selectedYear);
if (deductionDateRecord == "1")
{
sqlTrans.Commit();
MessageBox.Show("Transaction has been Successfully Posted");
getDeductionList();
ActivityLog.logActivity(userId, "Post Deduction - Collective", "Deduction Posting for Month:" + selectedMonth + " " + selectedYear);
}
else
{
sqlTrans.Rollback();
MessageBox.Show("Posting Transaction Failed");
}
}
else
{
sqlTrans.Rollback();
MessageBox.Show("Posting Transaction Failed");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}//end of executeDeduction
private void btnSingleUnpost_Click(object sender, EventArgs e)
{
int memberID;
if (dtGrdSingleDeductions.SelectedRows.Count > 0)
{
selDeductionId = Convert.ToInt16(dtGrdSingleDeductions.SelectedRows[0].Cells[0].Value.ToString());
selDelMonth = dtGrdSingleDeductions.SelectedRows[0].Cells[1].Value.ToString();
selDelYear = Convert.ToInt16(dtGrdSingleDeductions.SelectedRows[0].Cells[2].Value.ToString());
memberID = Convert.ToInt16(dtGrdSingleDeductions.SelectedRows[0].Cells[3].Value.ToString());
selDedTransactionId = dtGrdSingleDeductions.SelectedRows[0].Cells[8].Value.ToString();
//MessageBox.Show("ID: " + selDeductionId.ToString() + "Month: " + selDelMonth.ToString() + " Year: " + selDelYear.ToString() + "MemberID: " + memberID.ToString() + "TransactionID: " + selDedTransactionId);
}
else
{
MessageBox.Show("Choose a Member Deduction Record to Delete", "Unpost Deduction", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
DialogResult res = MessageBox.Show("Do you wish to Unpost the Selected Record?", "Unpost", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
SqlConnection conn = ConnectDB.GetConnection();
SqlCommand cmd = conn.CreateCommand();
try
{
conn.Open();
SqlTransaction sqlTrans = conn.BeginTransaction();
cmd.CommandType = CommandType.Text;
cmd.Transaction = sqlTrans;
Cl_UnpostDeductions deletePosting = new Cl_UnpostDeductions();
string savingsDelStatus = deletePosting.unpostSavingsDeductions(conn, cmd, memberID, selDedTransactionId);
string loanDelStatus = deletePosting.unpostLoansDeduction(conn, cmd, memberID, selDedTransactionId);
string deductionDelStatus = deletePosting.unpostDeductions(conn, cmd, memberID, selDedTransactionId, selDelMonth, selDelYear);
string deductionDetailsDelStatus = deletePosting.unpostDeductionDetails(conn, cmd, memberID, selDedTransactionId);
//MessageBox.Show("Savings Status: " + savingsDelStatus + "\nLoans Status: " + loanDelStatus + "\nDeductions: " + deductionDelStatus + "\nDeduction Detials: " + deductionDetailsDelStatus);
if ((Convert.ToInt16(savingsDelStatus) != 0) || (Convert.ToInt16(deductionDetailsDelStatus) != 0) || (Convert.ToInt16(deductionDelStatus) != 0))
{
sqlTrans.Commit();
ActivityLog.logActivity(UserId, "Unpost Deduction - Single", "Unpost Deduction for MemberID:" + memberID + " for " + selDelMonth + " " + selDelYear);
MessageBox.Show("Selected record has been Successfully Deleted.", "Unpost Deduction", MessageBoxButtons.OK, MessageBoxIcon.Information);
UnpostDeductions unpostDeductions = new UnpostDeductions(UserId);
unpostDeductions.MdiParent = this.ParentForm;
unpostDeductions.Show();
this.Close();
}
else
{
sqlTrans.Rollback();
MessageBox.Show("An error has occurred.", "Unpost Deduction", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
}
private void btnBulkUnpost_Click(object sender, EventArgs e)
{
if (dtGrdBulkDeductions.SelectedRows.Count > 0)
{
selDeductionId = Convert.ToInt16(dtGrdBulkDeductions.SelectedRows[0].Cells[0].Value.ToString());
selDelMonth = dtGrdBulkDeductions.SelectedRows[0].Cells[1].Value.ToString();
selDelYear = Convert.ToInt16(dtGrdBulkDeductions.SelectedRows[0].Cells[2].Value.ToString());
//MessageBox.Show("ID: " + selDeductionId.ToString() + "Month: " + selDelMonth.ToString() + " Year: " + selDelYear.ToString());
}
else
{
MessageBox.Show("Choose a Deduction Record to Delete", "Unpost Deduction", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
DialogResult res = MessageBox.Show("Do you wish to Unpost the Selected Deduction?", "Unpost Deduction", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
SqlConnection conn = ConnectDB.GetConnection();
SqlCommand cmd;
try
{
conn.Open();
SqlTransaction sqlTrans = conn.BeginTransaction();
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.Transaction = sqlTrans;
cmd.CommandText = "Select distinct d.TransactionID from Deductions d " +
"inner join MonthByName m on m.MonthID=d.Month " +
"where m.month='" + selDelMonth + "' And d.Year=" + selDelYear;
SqlDataReader reader = cmd.ExecuteReader();
selDeductionTransactionDel.Clear();
while (reader.Read())
{
selDeductionTransactionDel.Add(reader["TransactionID"].ToString());
}
reader.Close();
//MessageBox.Show(selDeductionTransactionDel.Count.ToString());
Cl_UnpostDeductions deletePosting = new Cl_UnpostDeductions();
string savingsDelStatus = deletePosting.unpostSavingsDeductions(conn, cmd, selDeductionTransactionDel);
string loanDelStatus = deletePosting.unpostLoansDeduction(conn, cmd, selDeductionTransactionDel);
string deductionDelStatus = deletePosting.unpostDeductions(conn, cmd, selDeductionTransactionDel, selDelMonth, selDelYear);
string deductionDetailsDelStatus = deletePosting.unpostDeductionDetails(conn, cmd, selDeductionTransactionDel);
string deductionDatesDelStatus = deletePosting.unpostDeductionDates(conn, cmd, selDelMonth, selDelYear);
//MessageBox.Show("Savings Status: " + savingsDelStatus + "\nLoans Status: " + loanDelStatus + "\nDeductions: " + deductionDelStatus + "\nDeduction Detials: " + deductionDetailsDelStatus);
if ((Convert.ToInt16(deductionDelStatus) != 0) && (Convert.ToInt16(deductionDetailsDelStatus) != 0) && (Convert.ToInt16(deductionDelStatus) != 0))
{
sqlTrans.Commit();
ActivityLog.logActivity(UserId, "Unpost Deduction - Bulk", "Unpost Deduction Record ID:" + selDeductionId + " for " + selDelMonth + " " + selDelYear);
MessageBox.Show("Selected record has been Successfully Deleted.", "Unpost Deduction", MessageBoxButtons.OK, MessageBoxIcon.Information);
UnpostDeductions unpostDeductions = new UnpostDeductions(UserId);
unpostDeductions.MdiParent = this.ParentForm;
unpostDeductions.Show();
this.Close();
}
else
{
sqlTrans.Rollback();
MessageBox.Show("An error has occurred.", "Unpost Deduction", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
}
private void btnPost_Click(object sender, EventArgs e)
{
if (CheckForNumber.isNumeric(txtWithdrawAmt.Text) && (Convert.ToDecimal(txtWithdrawAmt.Text) > 0))
{
DialogResult res = MessageBox.Show("Do you wish to post this Transaction?", "Withdrawal", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
#region ExecutePost
string strMonth = dateTimePicker1.Value.Month.ToString();
string strYear = dateTimePicker1.Value.Year.ToString();
string transactionID = "WIT" + DateTime.Now.ToString("ddMMyyhhmmss");
SqlConnection conn = ConnectDB.GetConnection();
conn.Open();
SqlTransaction mySqlTrans = conn.BeginTransaction();
string strInsertSavings = "Insert into Savings(MemberID,SavingSource,Amount,Month,Year,TransactionID)values(@MemberID," +
"@SavingSource,@Amount,@Month,@Year,@TransactionID)";
string strInsertSavingsWithdrawal = "Insert into SavingsWithdrawal(SavingsID,MemberID,SavingsTypeID,Amount," +
"WithdrawAmount,Balance)values(@SavingsID,@MemberID,@SavingsTypeID,@Amount,@WithdrawalAmount,@Balance)";
string strQuery = "Select SavingsID from Savings where TransactionID=@TransactionID";
SqlCommand cmd = conn.CreateCommand();
cmd.Transaction = mySqlTrans;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strInsertSavings;
#region cmdParameters
cmd.Parameters.Add("@MemberID", SqlDbType.Int);
cmd.Parameters["@MemberID"].Value = memberID;
cmd.Parameters.Add("@SavingSource", SqlDbType.NVarChar, 50);
cmd.Parameters["@SavingSource"].Value = "Withdrawal";
cmd.Parameters.Add("@Amount", SqlDbType.Decimal);
cmd.Parameters["@Amount"].Value = "-" + txtWithdrawAmt.Text;
cmd.Parameters.Add("@Month", SqlDbType.NVarChar, 50);
cmd.Parameters["@Month"].Value = strMonth;
cmd.Parameters.Add("@Year", SqlDbType.NVarChar, 50);
cmd.Parameters["@Year"].Value = strYear;
cmd.Parameters.Add("@TransactionID", SqlDbType.NVarChar, 30);
cmd.Parameters["@TransactionID"].Value = transactionID;
#endregion cmdParameters
try
{
int rowAffected = cmd.ExecuteNonQuery();
if (rowAffected > 0)
{
cmd.CommandText = strQuery;
cmd.Parameters["@TransactionID"].Value = transactionID;
int savingsID = Convert.ToInt16(cmd.ExecuteScalar());
cmd.CommandText = strInsertSavingsWithdrawal;
#region cmdParameters - strInsertSavingsWithrawal
cmd.Parameters.Add("@SavingsID", SqlDbType.Int);
cmd.Parameters["@SavingsID"].Value = savingsID;
cmd.Parameters["@MemberID"].Value = memberID;
cmd.Parameters.Add("@SavingsTypeID", SqlDbType.Int);
cmd.Parameters["@SavingsTypeID"].Value = cboSavingsType.SelectedValue;
cmd.Parameters["@Amount"].Value = lblAcctAmount.Text;
cmd.Parameters.Add("@WithdrawalAmount", SqlDbType.Decimal);
cmd.Parameters["@WithdrawalAmount"].Value = txtWithdrawAmt.Text;
cmd.Parameters.Add("@Balance", SqlDbType.Decimal);
cmd.Parameters["@Balance"].Value = lblAmtBalance.Text;
#endregion
rowAffected = cmd.ExecuteNonQuery();
if (rowAffected > 0)
{
mySqlTrans.Commit();
MessageBox.Show("Transaction is Successfully Posted", "Withdrawal", MessageBoxButtons.OK, MessageBoxIcon.Information);
string logDescription = cboSavingsType.Text + " withdrawal of " + txtWithdrawAmt.Text +
" from Member with ID " + memberID;
txtWithdrawAmt.Text = string.Empty;
txtWithdrawAmt.Enabled = false;
btnPost.Enabled = false;
getPreviousWithdrawals();
ActivityLog.logActivity(UserID, "Withdrawal", logDescription);
}
else
{
mySqlTrans.Rollback();
MessageBox.Show("An error has occurred!", "Withdrawal", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
mySqlTrans.Rollback();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
#endregion
}
}
else
{
MessageBox.Show("Withdrawal Amount has not been Supplied", "Withdrawal", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void executeEditLoansBF()
{
if (txtAmount.Text != string.Empty && txtInterest.Text != string.Empty && txtTotalRepayment.Text != string.Empty && txtAmountPaid.Text != string.Empty && txtMonthlyRepayment.Text != string.Empty)
{
SqlConnection conn = ConnectDB.GetConnection();
conn.Open();
try
{
SqlTransaction sqlTrans = conn.BeginTransaction();
string QueryLoanApp = "Update LoanApplication set AppMonth=@AppMonth, AppYear=@AppYear,LoanCategoryID=@LoanCategoryID, " +
"LoanTypeID=@LoanTypeID,LoanAmount=@LoanAmount,StartRepaymentMonth=@StartRepaymentMonth,StartRepaymentYear=@StartRepaymentYear," +
"LoanDuration=@LoanDuration,InterestRate=@InterestRate,InterestAmount=@InterestAmount,TotalRepayment=@TotalRepayment, " +
"MonthlyRepayment=@MonthlyRepayment where LoanApplicationID=@LoanApplicationID";
SqlCommand cmd = new SqlCommand(QueryLoanApp, conn);
cmd.Transaction = sqlTrans;
//MessageBox.Show("Application ID: " + loanApplicationID.ToString());
#region parameters
cmd.Parameters.Add("@AppMonth", SqlDbType.Int);
cmd.Parameters["@AppMonth"].Value = dtAppDate.Value.Month.ToString();
cmd.Parameters.Add("@AppYear", SqlDbType.Int);
cmd.Parameters["@AppYear"].Value = dtAppDate.Value.Year.ToString();
cmd.Parameters.Add("@LoanCategoryID", SqlDbType.Int);
cmd.Parameters["@LoanCategoryID"].Value = cboLoanCategory.SelectedValue;
cmd.Parameters.Add("@LoanTypeID", SqlDbType.Int);
cmd.Parameters["@LoanTypeID"].Value = cboLoanType.SelectedValue;
cmd.Parameters.Add("@LoanAmount", SqlDbType.Decimal);
cmd.Parameters["@LoanAmount"].Value = txtAmount.Text;
cmd.Parameters.Add("@StartRepaymentMonth", SqlDbType.Int);
cmd.Parameters["@StartRepaymentMonth"].Value = dtStartRepayment.Value.Month.ToString();
cmd.Parameters.Add("@StartRepaymentYear", SqlDbType.Int);
cmd.Parameters["@StartRepaymentYear"].Value = dtStartRepayment.Value.Year.ToString();
cmd.Parameters.Add("@LoanDuration", SqlDbType.Int);
cmd.Parameters["@LoanDuration"].Value = lblDuration.Text;
cmd.Parameters.Add("@InterestRate", SqlDbType.Decimal);
cmd.Parameters["@InterestRate"].Value = lblInterestRate.Text;
cmd.Parameters.Add("@InterestAmount", SqlDbType.Decimal);
cmd.Parameters["@InterestAmount"].Value = txtInterest.Text;
cmd.Parameters.Add("@TotalRepayment", SqlDbType.Decimal);
cmd.Parameters["@TotalRepayment"].Value = txtTotalRepayment.Text;
cmd.Parameters.Add("@MonthlyRepayment", SqlDbType.Decimal);
cmd.Parameters["@MonthlyRepayment"].Value = txtMonthlyRepayment.Text;
cmd.Parameters.Add("@LoanApplicationID", SqlDbType.Int);
cmd.Parameters["@LoanApplicationID"].Value = loanApplicationID;
#endregion
int rowAffected_QueryLoanApp = cmd.ExecuteNonQuery();
MessageBox.Show("QueryLoanApp: " + rowAffected_QueryLoanApp.ToString());
string QueryLoans;
if (dateFinishedPayment != string.Empty)
{
QueryLoans = "Update Loans set RepaymentAmount=@RepaymentAmount,AmountPaid=@AmountPaid,OutstandingAmount=@OutstandingAmount, " +
"PaymentStatus=@PaymentStatus,PaymentFinished=@PaymentFinished,DateFinishedPayment=@DateFinishedPayment,Remark=@Remark " +
"where LoanApplicationID=@LoanApplicationID";
}
else
{
QueryLoans = "Update Loans set RepaymentAmount=@RepaymentAmount,AmountPaid=@AmountPaid,OutstandingAmount=@OutstandingAmount, " +
"PaymentStatus=@PaymentStatus,PaymentFinished=@PaymentFinished,Remark=@Remark " +
"where LoanApplicationID=@LoanApplicationID";
}
cmd.CommandText = QueryLoans;
//cmd.Transaction = sqlTrans;
#region parameters
cmd.Parameters.Add("@RepaymentAmount", SqlDbType.Decimal);
cmd.Parameters["@RepaymentAmount"].Value = txtTotalRepayment.Text;
cmd.Parameters.Add("@AmountPaid", SqlDbType.Decimal);
cmd.Parameters["@AmountPaid"].Value = txtAmountPaid.Text;
cmd.Parameters.Add("@OutstandingAmount", SqlDbType.Decimal);
cmd.Parameters["@OutstandingAmount"].Value = txtOutstandingAmt.Text;
cmd.Parameters.Add("@PaymentStatus", SqlDbType.NVarChar, 10);
cmd.Parameters["@PaymentStatus"].Value = paymentStatus;
cmd.Parameters.Add("@PaymentFinished", SqlDbType.NVarChar, 5);
cmd.Parameters["@PaymentFinished"].Value = paymentFinished;
if (dateFinishedPayment != string.Empty)
{
cmd.Parameters.Add("@DateFinishedPayment", SqlDbType.Date);
cmd.Parameters["@DateFinishedPayment"].Value = DateTime.Parse(dateFinishedPayment);
}
cmd.Parameters.Add("@Remark", SqlDbType.NVarChar, 1000);
cmd.Parameters["@Remark"].Value = txtRemark.Text;
cmd.Parameters["@LoanApplicationID"].Value = loanApplicationID;
#endregion
int rowAffected_QueryLoans = cmd.ExecuteNonQuery();
MessageBox.Show("QueryLoans: " + rowAffected_QueryLoans.ToString());
if ((rowAffected_QueryLoanApp > 0) && (rowAffected_QueryLoans > 0))
{
sqlTrans.Commit();
MessageBox.Show("Record has been successfully edited.", "Loans Forward", MessageBoxButtons.OK, MessageBoxIcon.Information);
ActivityLog.logActivity(userId, "LoansForward", "Edit Loans Brought Forward with LoanApplication ID of " + loanApplicationID);
EditLoansBroughtForward editLoansBroughtForward = new EditLoansBroughtForward(userId);
editLoansBroughtForward.MdiParent = this.ParentForm;
editLoansBroughtForward.Show();
this.Close();
}
else
{
sqlTrans.Rollback();
MessageBox.Show("An error occurred editing record.", "Loans Forward", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}//end of if statement check
}
private void executePosting()
{
btnPost.Enabled = false;
string appMonth = dtAppDate.Value.Month.ToString();
string appYear = dtAppDate.Value.Year.ToString();
string rePay_StartMonth = dtStartRepayment.Value.Month.ToString();
string rePay_StartYear = dtStartRepayment.Value.Year.ToString();
string transactionID = "LBF" + DateTime.Now.ToString("ddMMyyhhmmss");
SqlConnection conn = ConnectDB.GetConnection();
conn.Open();
try
{
SqlTransaction sqlTrans = conn.BeginTransaction();
string strQuery = "Insert into LoanApplication(AppMonth,AppYear,MemberID,LoanCategoryID," +
"LoanTypeID,LoanAmount,StartRepaymentMonth,StartRepaymentYear,LoanDuration,InterestRate," +
"InterestAmount,TotalRepayment,MonthlyRepayment,ApprovalStatus,TransactionID)" +
"values(@AppMonth,@AppYear,@MemberID,@LoanCategoryID,@LoanTypeID,@LoanAmount,@StartRepaymentMonth,@StartRepaymentYear," +
"@LoanDuration,@InterestRate,@InterestAmount,@TotalRepayment,@MonthlyRepayment,@ApprovalStatus,@TransactionID)";
SqlCommand cmd = new SqlCommand(strQuery, conn);
cmd.Transaction = sqlTrans;
#region Parameters
cmd.Parameters.Add("@AppMonth", SqlDbType.Int);
cmd.Parameters["@AppMonth"].Value = appMonth;
cmd.Parameters.Add("@AppYear", SqlDbType.Int);
cmd.Parameters["@AppYear"].Value = appYear;
cmd.Parameters.Add("@MemberID", SqlDbType.Int);
cmd.Parameters["@MemberID"].Value = memberID;
cmd.Parameters.Add("@LoanCategoryID", SqlDbType.Int);
cmd.Parameters["@LoanCategoryID"].Value = cboLoanCategory.SelectedValue.ToString();
cmd.Parameters.Add("@LoanTypeID", SqlDbType.Int);
cmd.Parameters["@LoanTypeID"].Value = cboLoanType.SelectedValue.ToString();
cmd.Parameters.Add("@LoanAmount", SqlDbType.Decimal);
cmd.Parameters["@LoanAmount"].Value = txtAmount.Text;
cmd.Parameters.Add("@StartRepaymentMonth", SqlDbType.Decimal);
cmd.Parameters["@StartRepaymentMonth"].Value = rePay_StartMonth;
cmd.Parameters.Add("@StartRepaymentYear", SqlDbType.Decimal);
cmd.Parameters["@StartRepaymentYear"].Value = rePay_StartYear;
cmd.Parameters.Add("@LoanDuration", SqlDbType.Int);
cmd.Parameters["@LoanDuration"].Value = lblDuration.Text;
cmd.Parameters.Add("@InterestRate", SqlDbType.Decimal);
cmd.Parameters["@InterestRate"].Value = lblInterestRate.Text;
cmd.Parameters.Add("@InterestAmount", SqlDbType.Decimal);
cmd.Parameters["@InterestAmount"].Value = txtInterest.Text;
cmd.Parameters.Add("@TotalRepayment", SqlDbType.Decimal);
cmd.Parameters["@TotalRepayment"].Value = txtTotalRepayment.Text;
cmd.Parameters.Add("@MonthlyRepayment", SqlDbType.Decimal);
cmd.Parameters["@MonthlyRepayment"].Value = txtMonthlyRepayment.Text;
cmd.Parameters.Add("@ApprovalStatus", SqlDbType.NVarChar, 3);
cmd.Parameters["@ApprovalStatus"].Value = "Yes";
cmd.Parameters.Add("@TransactionID", SqlDbType.NVarChar, 50);
cmd.Parameters["@TransactionID"].Value = transactionID;
#endregion
string strQuery1;
if (dateFinishedPayment != string.Empty)
{
strQuery1 = "Insert into Loans(LoanApplicationID,RepaymentAmount,AmountPaid,OutstandingAmount," +
"PaymentStatus,PaymentFinished,DateFinishedPayment,TransactionID,Remark)values(@LoanApplicationID," +
"@RepaymentAmount,@AmountPaid,@OutstandingAmount,@PaymentStatus,@PaymentFinished,@DateFinishedPayment," +
"@TransactionID,@Remark)";
}
else
{
strQuery1 = "Insert into Loans(LoanApplicationID,RepaymentAmount,AmountPaid,OutstandingAmount," +
"PaymentStatus,PaymentFinished,TransactionID,Remark)values(@LoanApplicationID," +
"@RepaymentAmount,@AmountPaid,@OutstandingAmount,@PaymentStatus,@PaymentFinished," +
"@TransactionID,@Remark)";
}
string strQuery3 = "Select LoanApplicationID from LoanApplication where TransactionID='" + transactionID + "'";
int rowAffected = cmd.ExecuteNonQuery();
//MessageBox.Show(rowAffected.ToString());
if (rowAffected > 0)
{
cmd = new SqlCommand(strQuery3, conn);
cmd.Transaction = sqlTrans;
int loanApplicationID = Convert.ToInt16(cmd.ExecuteScalar());
//MessageBox.Show(loanApplicationID.ToString());
cmd = new SqlCommand(strQuery1, conn);
cmd.Transaction = sqlTrans;
#region parameters strQuery1
cmd.Parameters.Add("@LoanApplicationID", SqlDbType.Int);
cmd.Parameters["@LoanApplicationID"].Value = loanApplicationID;
cmd.Parameters.Add("@RepaymentAmount", SqlDbType.Decimal);
cmd.Parameters["@RepaymentAmount"].Value = txtTotalRepayment.Text;
cmd.Parameters.Add("@AmountPaid", SqlDbType.Decimal);
cmd.Parameters["@AmountPaid"].Value = txtAmountPaid.Text;
cmd.Parameters.Add("@OutstandingAmount", SqlDbType.Decimal);
cmd.Parameters["@OutstandingAmount"].Value = txtOutstandingAmt.Text;
cmd.Parameters.Add("@PaymentStatus", SqlDbType.NVarChar, 10);
cmd.Parameters["@PaymentStatus"].Value = paymentStatus;
cmd.Parameters.Add("@PaymentFinished", SqlDbType.NVarChar, 3);
cmd.Parameters["@PaymentFinished"].Value = paymentFinished;
if (dateFinishedPayment != string.Empty)
{
cmd.Parameters.Add("@DateFinishedPayment", SqlDbType.NVarChar, 40);
cmd.Parameters["@DateFinishedPayment"].Value = dateFinishedPayment;
}
cmd.Parameters.Add("@TransactionID", SqlDbType.NVarChar, 50);
cmd.Parameters["@TransactionID"].Value = transactionID;
cmd.Parameters.Add("@Remark", SqlDbType.NVarChar, 1000);
cmd.Parameters["@Remark"].Value = txtRemark.Text;
#endregion
//Execute strQuery1
rowAffected = cmd.ExecuteNonQuery();
if (rowAffected > 0)
{
sqlTrans.Commit();
MessageBox.Show("Transaction has been successfully posted.", "Loans", MessageBoxButtons.OK, MessageBoxIcon.Information);
ActivityLog.logActivity(userId, "LoansForward", "Added a new Loans Brought Forward record with TransactionID of " + transactionID);
}
else
{
sqlTrans.Rollback();
MessageBox.Show("An error has occurred! Operation has been aborted.", "Loans", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Close existing form and reopen active form
NewLoanBroughtForward newLoanBroughtForward = new NewLoanBroughtForward(userId);
newLoanBroughtForward.MdiParent = this.ParentForm;
newLoanBroughtForward.Show();
this.Close();
}
else
{
MessageBox.Show("An error has occurred!", "Loans", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
private void UpdateSavings()
{
int rowAffected = 0;
bool errorflag = false;
int savingsTypeID = 0;
int savingsForwardID = 0;
string temp = string.Empty;
decimal amount = 0;
string comment = string.Empty;
string strQuery = string.Empty;
SqlConnection conn = ConnectDB.GetConnection();
strQuery = "Update Savings set Amount=@Amount where TransactionID=@TransactionID";
conn.Open();
SqlTransaction sqlTrans = conn.BeginTransaction();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = strQuery;
cmd.Parameters.Add("@Amount", SqlDbType.Decimal);
cmd.Parameters["@Amount"].Value = Convert.ToDecimal(lblSavingsTotal.Text);
cmd.Parameters.Add("@TransactionID", SqlDbType.NVarChar, 100);
cmd.Parameters["@TransactionID"].Value = lblSavingsID.Text;
cmd.Transaction = sqlTrans;
try
{
rowAffected = cmd.ExecuteNonQuery();
if (rowAffected > 0)
{
for (int i = 0; i < lstVwSavingDetails.Items.Count; i++)
{
strQuery = "Update SavingsForward set SavingsTypeID=@SavingsTypeID,Amount=@Amount,Comment=@Comment where SavingsForwardID=@SavingsForwardID" +
" and TransactionID=@TransactionID";
cmd.CommandText = strQuery;
#region cmd parameters
savingsForwardID = Convert.ToInt16(lstVwSavingDetails.Items[i].SubItems[0].Text.ToString());
savingsTypeID = Convert.ToInt16(lstVwSavingDetails.Items[i].SubItems[1].Text.ToString());
temp = lstVwSavingDetails.Items[i].SubItems[3].Text.ToString();
amount = Convert.ToDecimal(temp);
comment = lstVwSavingDetails.Items[i].SubItems[4].Text.ToString();
cmd.Parameters.Clear();
//MessageBox.Show("Savings TypeID - " + savingsTypeID.ToString() + " - " + amount.ToString());
cmd.Parameters.Add("@SavingsTypeID", SqlDbType.Int);
cmd.Parameters["@SavingsTypeID"].Value = savingsTypeID;
cmd.Parameters.Add("@Amount", SqlDbType.Decimal);
cmd.Parameters["@Amount"].Value = amount;
cmd.Parameters.Add("@Comment", SqlDbType.NVarChar, 400);
cmd.Parameters["@Comment"].Value = comment;
cmd.Parameters.Add("@TransactionID", SqlDbType.NVarChar, 400);
cmd.Parameters["@TransactionID"].Value = lblSavingsID.Text;
cmd.Parameters.Add("@SavingsForwardID", SqlDbType.Int);
cmd.Parameters["@SavingsForwardID"].Value = savingsForwardID;
#endregion
rowAffected = cmd.ExecuteNonQuery();
if (rowAffected == 0)
{
errorflag = true;
}
}
}
else
{
errorflag = true;
}
//check if there was no error and commit, if there is error rollback
if (errorflag == false)
{
sqlTrans.Commit();
ActivityLog.logActivity(userId, "SavingsForward", "Update Savings Record " + lblSavingsID.Text);
MessageBox.Show("Savings has been successfully Updated", "Savings", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
sqlTrans.Rollback();
MessageBox.Show("An error occurred! Update has been cancelled.", "Savings", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//reset view
loadDataSetSavingsForward();
lstVwSavingDetails.Items.Clear();
cboSavingsType.SelectedIndex = 0;
txtAmount.Text = string.Empty;
txtComment.Text = string.Empty;
lblSavingsTotal.Text = "0.00";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
private void ExecuteSave()
{
SqlConnection conn = null;
SqlCommand cmd = null;
bool errorFlag = false;
int rowAffected;
string strQuery;
if ((lstVwSavings.Items.Count != 0) && (totalAmount > 0) && (cboMonth.Text != string.Empty) && (cboYear.Text != string.Empty))
{
conn = ConnectDB.GetConnection();
conn.Open();
SqlTransaction sqlTrans = conn.BeginTransaction();
cmd = conn.CreateCommand();
cmd.Transaction = sqlTrans;
string transactionID = "SAV" + DateTime.Now.ToString("ddMMyyhhmmss");
strQuery = "Insert into Savings(MemberID,SavingSource,Amount,Month,Year,TransactionID)" +
"values(@MemberID,@SavingSource,@Amount,@Month,@Year,@TransactionID)";
#region cmd parameters
cmd.Parameters.Add("@MemberID", SqlDbType.Int);
cmd.Parameters["@MemberID"].Value = memberID;
cmd.Parameters.Add("@SavingSource", SqlDbType.NVarChar, 40);
cmd.Parameters["@SavingSource"].Value = "SavingsForward";
cmd.Parameters.Add("@Amount", SqlDbType.Decimal);
cmd.Parameters["@Amount"].Value = totalAmount;
cmd.Parameters.Add("@Month", SqlDbType.Int);
cmd.Parameters["@Month"].Value = Convert.ToInt16(cboMonth.SelectedIndex);
cmd.Parameters.Add("@Year", SqlDbType.Int);
cmd.Parameters["@Year"].Value = Convert.ToInt16(cboYear.Text);
cmd.Parameters.Add("@TransactionID", SqlDbType.NVarChar, 50);
cmd.Parameters["@TransactionID"].Value = transactionID;
#endregion
cmd.CommandText = strQuery;
try
{
rowAffected = cmd.ExecuteNonQuery();
#region if Statement of rowAffected
if (rowAffected > 0)
{
//Get SavingsID from the savings Table
strQuery = "Select SavingsID from Savings where TransactionID='" + transactionID + "'";
cmd.CommandText = strQuery;
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
string SavingsID = reader["SavingsID"].ToString();
reader.Close();
cmd.Parameters.Add("@SavingsID", SqlDbType.Int);
cmd.Parameters.Add("@SavingsTypeID", SqlDbType.Int);
cmd.Parameters.Add("@Comment", SqlDbType.NVarChar, 400);
for (int i = 0; i < lstVwSavings.Items.Count; i++)
{
strQuery = "Insert into SavingsForward(SavingsID,Month,Year,SavingsTypeID,Amount,Comment,TransactionID)" +
"values(@SavingsID,@Month,@Year,@SavingsTypeID,@Amount,@Comment,@TransactionID)";
#region cmd parameters
cmd.Parameters["@SavingsID"].Value = SavingsID;
cmd.Parameters["@Month"].Value = Convert.ToInt16(cboMonth.SelectedIndex);
cmd.Parameters["@Year"].Value = Convert.ToInt16(cboYear.Text);
cmd.Parameters["@SavingsTypeID"].Value = Convert.ToInt16(lstVwSavings.Items[i].SubItems[0].Text.ToString());
cmd.Parameters["@Amount"].Value = Convert.ToDecimal(lstVwSavings.Items[i].SubItems[2].Text.ToString());
cmd.Parameters["@Comment"].Value = txtComment.Text.Trim();
cmd.Parameters["@TransactionID"].Value = transactionID;
#endregion
cmd.CommandText = strQuery;
rowAffected = cmd.ExecuteNonQuery();
if (rowAffected == 0)
{
MessageBox.Show("An error has occurred", "Savings", MessageBoxButtons.OK, MessageBoxIcon.Error);
errorFlag = true;
break;
}
}
}
else
{
errorFlag = true;
}
#endregion end of if statement
//Check if Transaction has been successful without error and commit or rollback
if (errorFlag == false)
{
sqlTrans.Commit();
ActivityLog.logActivity(userId, "SavingsForward", "Added a new Savings record with TransactionID of " + transactionID);
MessageBox.Show("Savings has been successfully posted", "Savings", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadDataSetSavingsForward();
loadDataSetMemberSavings();
}
else
{
sqlTrans.Rollback();
MessageBox.Show("An error has occurred posting savings", "Savings", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
clearFields();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
else
{
MessageBox.Show("Month, Year and Amount are required", "Savings", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void executeDeduction()
{
int numOfRecords = lstMonthlyDeductions.Items.Count;
int currentRecord;
SqlConnection conn = ConnectDB.GetConnection();
SqlTransaction sqlTrans = null;
SqlCommand cmd;
try
{
conn.Open();
sqlTrans = conn.BeginTransaction();
cmd = conn.CreateCommand();
cmd.Transaction = sqlTrans;
int selectedMonth = Convert.ToInt16(cboMonth.SelectedValue);
int selectedYear = Convert.ToInt16(cboYear.Text);
#region loop through records
//loop through records
for (currentRecord = 0; currentRecord < numOfRecords; currentRecord++)
{
cmd.Parameters.Clear();
memberID = Convert.ToInt16(lstMonthlyDeductions.Items[currentRecord].SubItems[1].Text);
decimal monthlyLoanRepayment = Convert.ToDecimal(lstMonthlyDeductions.Items[currentRecord].SubItems[5].Text);
decimal lstAllSavingsDeduction = Convert.ToDecimal(lstMonthlyDeductions.Items[currentRecord].SubItems[4].Text);
decimal lstAllLoansDeduction = Convert.ToDecimal(lstMonthlyDeductions.Items[currentRecord].SubItems[5].Text);
decimal lstTotalDeductions = Convert.ToDecimal(lstMonthlyDeductions.Items[currentRecord].SubItems[6].Text);
string transactionID = "DED" + DateTime.Now.ToString("ddMMyyhhmmss");
totalSavings = Convert.ToDecimal(lblTotalSavings.Text);
Deduction newPosting = new Deduction();
string postSavingsStatus = newPosting.postSavings(conn, cmd, sqlTrans, memberID, transactionID, lstAllSavingsDeduction, numOfRows, errorflag, selectedMonth, selectedYear);
//MessageBox.Show("Post Savings Status: " + postSavingsStatus);
string postLoansStatus = newPosting.postLoans(conn, cmd, sqlTrans, memberID, transactionID, currentRecord, selectedMonth, selectedYear, numOfRows, errorflag, monthlyLoanRepayment);
//MessageBox.Show("PostLoan Status: " + postLoansStatus);
string recordDeductionStatus = newPosting.recordDeduction(cmd, memberID, transactionID, currentRecord, selectedMonth, selectedYear, lstAllSavingsDeduction, lstAllLoansDeduction, lstTotalDeductions, numOfRows, errorflag);
//MessageBox.Show("Record Deductions status: " + recordDeductionStatus);
//string recordDeductionDetailsStatus = newPosting.recordDeductionDetails(cmd, memberID, transactionID, currentRecord, numOfRows, errorflag, lstAllSavingsDeduction, lstAllLoansDeduction, repaymentLoanType, servicingLoan, loanMoreThanSavings);
//MessageBox.Show("Record Deduction Detail Status: " + recordDeductionDetailsStatus);
int recordDeductionDetailStatus = recordDeductionDetails(cmd, memberID, transactionID, errorflag, numOfRows);
//MessageBox.Show(recordDeductionDetailStatus.ToString());
}
//end of for loop
#endregion end of loop
if (errorflag == 0)
{
sqlTrans.Commit();
MessageBox.Show("Member Deduction has been successfully posted.", "Deduction Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
getMonthlyDeductionsInfo(memberID);
getMemberPreviousDeductions(memberID);
getPreviousDeductionDate(memberID);
//Display Savings and Loan information
//lstMonthlyDeductions_SelectedIndexChanged(sender, e);
string selectedMemberID = lstMonthlyDeductions.Items[0].SubItems[1].Text;
getSavingsInfo(selectedMemberID);
getLoansInfo(selectedMemberID);
txtChangeSavingsAmt.Text = string.Empty;
txtChangeLoanAmount.Text = string.Empty;
ActivityLog.logActivity(UserId, "Posting Deduction - Individual", "Deduction Posting for MemberID:" + memberID + " for Month:" + selectedMonth + " " + selectedYear);
}
else
{
sqlTrans.Rollback();
MessageBox.Show("Deduction Transaction failed and is aborted!", "Deduction Info", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
