public void addChildrenRelationship(int ind) { string relship; bool childgend; if (tableChild.Rows[ind][3].ToString() == "1") { relship = "Son"; childgend = true; } else { relship = "Daughter"; childgend = false; } SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO FAMILYBACKGROUND (fName,mName, lName, birthDate, gender, relationship, MemberID) VALUES (@fName, @mName, @lName, @birthDate, @gender, @relationship, @MemberID)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@fName", tableChild.Rows[ind][1].ToString()); parameters.Add("@mName", tableChild.Rows[ind][2].ToString()); parameters.Add("@lName", tableChild.Rows[ind][0].ToString()); parameters.Add("@birthDate", tableChild.Rows[ind][4].ToString()); parameters.Add("@gender", childgend); parameters.Add("@relationship", relship.ToString()); parameters.Add("@MemberID", MemberID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); }
private void btnSave_Click(object sender, EventArgs e) { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO SAVINGSTRANSACTION(transactionDate, transactionType, transactionAmount, transactionRepresentative, currentBalance, SavingsAccountID) VALUES (@transactionDate, @transactionType, @transactionAmount, @transactionRepresentative, @currentBalance, @SavingsAccountID)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@transactionDate", Convert.ToDateTime(DateTime.Now.ToLongDateString())); parameters.Add("@transactionType", '2'); parameters.Add("@transactionAmount", Convert.ToDecimal(txtCurrentBalance.Text)); parameters.Add("@transactionRepresentative", txtMemberName.Text); parameters.Add("@currentBalance", '0'); parameters.Add("@SavingsAccountID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "UPDATE SAVINGSACCOUNT SET dateClosed = @dateClosed, currentBalance = '0' WHERE SavingsAccountID = @SavingsAccountID"; parameters = new Dictionary<string, object>(); parameters.Add("@dateClosed", Convert.ToDateTime(DateTime.Now.ToLongDateString())); parameters.Add("@SavingsAccountID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Closing a savings account is successful.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); defaultAll(); btnSave.Enabled = false; } } else { MessageBox.Show("Closing a savings account is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnStatus_Click(object sender, EventArgs e) { if (SLS.Static.ID != 0) { if (btnStatus.Text == "DELETE") { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE SAVINGSTYPE SET [status] = @status WHERE SavingsTypeID = @SavingsTypeID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@status", false); parameters.Add("@SavingsTypeID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("A Savings Type is Updated.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); loadDatabase(); btnStatus.Text = "DELETE"; } else { MessageBox.Show("A Savings Type is Not Updated.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE SAVINGSTYPE SET [status] = @status WHERE SavingsTypeID = @SavingsTypeID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@status", true); parameters.Add("@SavingsTypeID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("A Savings Type is Updated.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); loadDatabase(); btnStatus.Text = "DELETE"; } else { MessageBox.Show("A Savings Type is Not Updated.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show("Please choose a record to be updated.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnStatus_Click(object sender, EventArgs e) { if (btnStatus.Text == "DELETE") { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE TIMEDEPOSITRATES SET [status] = @status WHERE TimeDepositRatesID = @TimeDepositRatesID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@status", false); parameters.Add("@TimeDepositRatesID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a time deposit rate is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); SLS.Static.ID = 0; loadDatabase(); } else { MessageBox.Show("Updating a time deposit rate is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE TIMEDEPOSITRATES SET [status] = @status WHERE TimeDepositRatesID = @TimeDepositRatesID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@status", true); parameters.Add("@TimeDepositRatesID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a time deposit rate is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); SLS.Static.ID = 0; loadDatabase(); } else { MessageBox.Show("Updating a time deposit rate is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnSave_Click(object sender, EventArgs e) { if (SLS.Static.ID == 0) { if (checkValues() == 0) { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO MODE (modeName, daysInterval, [status]) VALUES (@modeName, @daysInterval, @status)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@modeName", txtModeName.Text); parameters.Add("@daysInterval", txtDaysInterval.Text); parameters.Add("@status", true); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Adding a mode of payment is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("Adding a mode of payment is not successful.", "Error", MessageBoxButtons.OK); } } else { MessageBox.Show("Some required fields are missing/invalid!", "Error"); } } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE MODE SET modeName = @modeName, daysInterval = @daysInterval WHERE ModeID = " + SLS.Static.ID + " "; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@modeName", txtModeName.Text); parameters.Add("@daysInterval", txtDaysInterval.Text); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a mode of payment is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); defaultAll(); this.Close(); } else { MessageBox.Show("Updating a mode of payment is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnStatus_Click(object sender, EventArgs e) { if(SLS.Static.selected == 0) { if(btnStatus.Text == "DELETE") { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE MODE SET [status] = @status WHERE ModeID = @ModeID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@status", false); parameters.Add("@ModeID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a time deposit rate is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); SLS.Static.ID = 0; loadDatabase(); } else { MessageBox.Show("Updating a time deposit rate is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if(btnStatus.Text == "ACTIVATE") { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "SELECT daysInterval FROM MODE WHERE ModeID = " + SLS.Static.ID + " "; SqlDataReader reader = con.executeReader(sql); Int32 isValid = 0; if(reader.HasRows && isValid == 0) { reader.Read(); if(daysInterval == reader.GetInt32(0)) { isValid = 1; } } if(isValid == 0) { con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "UPDATE MODE SET [status] = @status WHERE ModeID = @ModeID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@status", true); parameters.Add("@ModeID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a time deposit rate is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); SLS.Static.ID = 0; loadDatabase(); } else { MessageBox.Show("Updating a time deposit rate is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("There is an existing mode of payment.","Error"); } } } else if (SLS.Static.selected == 1) { if (btnStatus.Text == "DELETE") { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE TERM SET [status] = @status WHERE TermID = @TermID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@status", false); parameters.Add("@TermID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a time deposit rate is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); SLS.Static.ID = 0; loadDatabase(); } else { MessageBox.Show("Updating a time deposit rate is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (btnStatus.Text == "ACTIVATE") { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "SELECT noOfDays FROM TERM WHERE TermID = " + SLS.Static.ID + " "; SqlDataReader reader = con.executeReader(sql); Int32 isValid = 0; if (reader.HasRows && isValid == 0) { reader.Read(); if (noOfDays == reader.GetInt32(0)) { isValid = 1; } } if (isValid == 0) { con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "UPDATE TERM SET [status] = @status WHERE TermID = @TermID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@status", true); parameters.Add("@TermID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a time deposit rate is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); SLS.Static.ID = 0; loadDatabase(); } else { MessageBox.Show("Updating a time deposit rate is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("There is an existing mode of payment.", "Error"); } } } else if (SLS.Static.selected == 2) { if (btnStatus.Text == "DELETE") { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE CHARGE SET [status] = @status WHERE ChargeID = @ChargeID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@status", false); parameters.Add("@ChargeID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a time deposit rate is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); SLS.Static.ID = 0; loadDatabase(); } else { MessageBox.Show("Updating a time deposit rate is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (btnStatus.Text == "ACTIVATE") { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE CHARGE SET [status] = @status WHERE ChargeID = @ChargeID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@status", true); parameters.Add("@ChargeID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a time deposit rate is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); SLS.Static.ID = 0; loadDatabase(); } else { MessageBox.Show("Updating a time deposit rate is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnSave_Click(object sender, EventArgs e) { if(checkValues() == 1) { MessageBox.Show("Some required field/s are missing or invalid.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO SAVINGSTRANSACTION(transactionDate, transactionType, transactionAmount, transactionRepresentative, currentBalance, SavingsAccountID) VALUES (@transactionDate, @transactionType, @transactionAmount, @transactionRepresentative, @currentBalance, @SavingsAccountID)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@transactionDate", Convert.ToDateTime(txtTransDate.Text)); parameters.Add("@transactionType", Convert.ToInt32(cobTransType.SelectedIndex) + 1); parameters.Add("@transactionAmount", txtAmount.Text); parameters.Add("@transactionRepresentative", txtRep.Text); if(cobTransType.SelectedIndex == 0) { parameters.Add("@currentBalance", Convert.ToDecimal(txtCurrentBalance.Text) + Convert.ToDecimal(txtAmount.Text)); } else { parameters.Add("@currentBalance", Convert.ToDecimal(txtCurrentBalance.Text) - Convert.ToDecimal(txtAmount.Text)); } parameters.Add("@SavingsAccountID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if(result == 1) { MessageBox.Show("Transaction is successful.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "UPDATE SAVINGSACCOUNT SET currentBalance = @currentBalance WHERE SavingsAccountID = @SavingsAccountID"; parameters = new Dictionary<string, object>(); if(cobTransType.SelectedIndex == 0) { parameters.Add("@currentBalance", Convert.ToDecimal(txtCurrentBalance.Text) + Convert.ToDecimal(txtAmount.Text)); } else { parameters.Add("@currentBalance", Convert.ToDecimal(txtCurrentBalance.Text) - Convert.ToDecimal(txtAmount.Text)); } parameters.Add("@SavingsAccountID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); defaultAll(); } else { MessageBox.Show("Transaction is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public void addToEmployed() { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO EMPLOYED (employerName, employerAddress, employerType, employerTelNo, dateStarted, monthlySalary, department, EmploymentInformationID) VALUES (@employerName, @employerAddress, @employerType, @employerTelNo, @dateStarted, @monthlySalary, @department, @EmploymentInformationID)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@employerName", txtEmployerName.Text); parameters.Add("@employerAddress", txtEmployerAddress.Text); parameters.Add("@employerType", emptype); parameters.Add("@employerTelNo", txtEmployerTelNo.Text); parameters.Add("@dateStarted", txtDateStarted.Text); parameters.Add("@monthlySalary", Convert.ToDecimal(txtMonthlySalary.Text)); parameters.Add("@department", txtDepartment.Text); parameters.Add("@EmploymentInformationID", EmploymentInformationID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); }
private void btnSave_Click(object sender, EventArgs e) { if (SLS.Static.ID == 0) { if (checkValues() == 1) { MessageBox.Show("Some required field/s are missing or invalid.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO MEMBERTYPE (MemberTypeName, SavingsApplicable, TimeApplicable, LoanApplicable, MinAgeRequired, MaxAgeRequired, Fee, ShareRequired, [status]) VALUES (@MemberTypeName, @SavingsApplicable, @TimeApplicable, @LoanApplicable, @MinAgeRequired, @MaxAgeRequired, @Fee, @ShareRequired, @status)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@MemberTypeName", txtMemName.Text); parameters.Add("@SavingsApplicable", ckbSavings.CheckState); parameters.Add("@TimeApplicable", ckbTime.CheckState); parameters.Add("@LoanApplicable", ckbLoan.CheckState); parameters.Add("@minAgeRequired", txtMinAge.Text); parameters.Add("@maxAgeRequired", txtMaxAge.Text); parameters.Add("@Fee", txtFee.Text); parameters.Add("@ShareRequired", txtShare.Text); parameters.Add("@status", true); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Adding member type is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); defaultAll(); this.Close(); } else { MessageBox.Show("Adding a member type is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { if (checkValues() == 1) { MessageBox.Show("Some required field/s are missing or invalid.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE MEMBERTYPE SET memberTypeName = @memberTypeName, SavingsApplicable = @SavingsApplicable, TimeApplicable = @TimeApplicable, LoanApplicable = @LoanApplicable, MinAgeRequired = @MinAgeRequired, MaxAgeRequired = @MaxAgeRequired, Fee = @Fee, ShareRequired = @ShareRequired WHERE MemberTypeID = @MemberTypeID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@MemberTypeName", txtMemName.Text); parameters.Add("@SavingsApplicable", ckbSavings.CheckState); parameters.Add("@TimeApplicable", ckbTime.CheckState); parameters.Add("@LoanApplicable", ckbLoan.CheckState); parameters.Add("@MinAgeRequired", txtMinAge.Text); parameters.Add("@MaxAgeRequired", txtMaxAge.Text); parameters.Add("@Fee", txtFee.Text); parameters.Add("@ShareRequired", txtShare.Text); parameters.Add("@MemberTypeID", MemberTypeID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a member type is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); defaultAll(); this.Close(); } else { MessageBox.Show("Updating a member type is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnSave_Click(object sender, EventArgs e) { if (SLS.Static.ID == 0) { if(checkValues() == 1) { MessageBox.Show("Some required field/s are missing or invalid.", "Error", MessageBoxButtons.OK); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO TIMEDEPOSITPENALTY (minElapsed, maxElapsed, reducedBy, [status]) VALUES (@minElapsed, @maxElapsed, @reducedBy, @status)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@minElapsed", Convert.ToDecimal(txtMin.Text)); parameters.Add("@maxElapsed", Convert.ToDecimal(txtMax.Text)); parameters.Add("@reducedBy", Convert.ToDecimal(txtReducedBy.Text)); parameters.Add("@status", true); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Adding a time deposit penalty is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("Adding a time deposit penalty is successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { if (checkValues() == 1) { MessageBox.Show("Some required field/s are missing or invalid.", "Error", MessageBoxButtons.OK); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE TIMEDEPOSITPENALTY SET minElapsed = @minElapsed, maxElapsed = @maxElapsed, reducedBy = @reducedBy WHERE TimeDepositPenaltyID = @TimeDepositPenaltyID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@minElapsed", Convert.ToDecimal(txtMin.Text)); parameters.Add("@maxElapsed", Convert.ToDecimal(txtMax.Text)); parameters.Add("@reducedBy", Convert.ToDecimal(txtReducedBy.Text)); parameters.Add("@TimeDepositPenaltyID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a time deposit is successful.", "Saved", MessageBoxButtons.OK); this.Close(); } else { MessageBox.Show("Updating a time deposit is not successful.", "Error", MessageBoxButtons.OK); } } } }
private void btnStatus_Click(object sender, EventArgs e) { if (SLS.Static.ID != 0) { if (btnStatus.Text == "DELETE") { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE DORMANCY SET [status] = 'false' WHERE DormancyID = @DormancyID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@DormancyID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a dormancy is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "UPDATE SAVINGSTYPE SET hasDormancy = 'false' WHERE SavingsTypeID = (SELECT SavingsTypeID FROM DORMANCY WHERE DormancyID = @DormancyID)"; parameters = new Dictionary<string, object>(); parameters.Add("@DormancyID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { loadDatabase(); btnStatus.Text = "DELETE"; } } else { MessageBox.Show("Updating a dormancy is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "SELECT SAVINGSTYPE.hasDormancy FROM SAVINGSTYPE, DORMANCY WHERE SAVINGSTYPE.SavingsTypeID = DORMANCY.SavingsTypeID and DORMANCY.DormancyID = "+ SLS.Static.ID +" "; SqlDataReader reader = con.executeReader(sql); if (reader.HasRows) { reader.Read(); if(Convert.ToString(reader.GetValue(0)) == "False") { con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "UPDATE DORMANCY SET [status] = 'true' WHERE DormancyID = @DormancyID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@DormancyID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a dormancy is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "UPDATE SAVINGSTYPE SET hasDormancy = 'true' WHERE SavingsTypeID = (SELECT SavingsTypeID FROM DORMANCY WHERE DormancyID = @DormancyID)"; parameters = new Dictionary<string, object>(); parameters.Add("@DormancyID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { loadDatabase(); btnStatus.Text = "DELETE"; } } else { MessageBox.Show("Updating a dormancy is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("There is an active dormancy for the savings type. \n Try to disable the currently active dormancy to activate another.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "UPDATE DORMANCY SET [status] = 'true' WHERE DormancyID = @DormancyID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters = new Dictionary<string, object>(); parameters.Add("@DormancyID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a dormancy is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "UPDATE SAVINGSTYPE SET hasDormancy = 'true' WHERE SavingsTypeID = (SELECT SavingsTypeID FROM DORMANCY WHERE DormancyID = @DormancyID)"; parameters = new Dictionary<string, object>(); parameters.Add("@DormancyID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if(result == 1) { loadDatabase(); btnStatus.Text = "DELETE"; } } else { MessageBox.Show("Updating a dormancy is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } else { MessageBox.Show("Please choose a record to be updated.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { if (SLS.Static.ID == 0) { if (checkValues() == 0) { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO MEMBER (MemberTypeID, fName, mName, lName, gender, birthDate, civilStatus, gsisNo, educAttainment, paidMembershipFee, applyDate, seminarDate, initialCapital, multiplier, isActive) VALUES ((SELECT MemberTypeID FROM MEMBERTYPE WHERE MemberTypeName = @MemberTypeName), @fName, @mName, @lName, @gender, @birthDate, @civilStatus, @gsisNo, @educAttainment, @paidMembershipFee, @applyDate, @seminarDate, @isActive); SELECT SCOPE_IDENTIY()"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@MemberTypeName", cmbMemberType.SelectedItem.ToString()); parameters.Add("@fName", txtFN.Text); parameters.Add("@mName", txtMN.Text); parameters.Add("@lName", txtLN.Text); parameters.Add("@gender", Convert.ToInt32(cmbGender.SelectedIndex)); parameters.Add("@birthDate", Convert.ToDateTime(dtDateBirth.Value)); parameters.Add("@civilStatus", Convert.ToInt32(cmbCivil.SelectedIndex)); parameters.Add("@gsisNo", txtGSISSSS.Text); parameters.Add("@educAttainment", Convert.ToInt32(cmbEduc.SelectedIndex)); parameters.Add("@paidMembershipFee", Convert.ToDecimal(txtFee.Text)); parameters.Add("@applyDate", Convert.ToDateTime(dtMembership.Value)); parameters.Add("@seminarDate", Convert.ToDateTime(dtSeminar.Value)); parameters.Add("@isActive", true); SqlDataReader reader = con.executeReader(sql, parameters); if (reader.HasRows) { reader.Read(); MemberID = reader.GetInt32(0); MessageBox.Show("Adding a member is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "INSERT INTO CONTACTPERSON (contactFN, contactLN, contactMN, contactNo, MemberID) VALUES (@contactFN, @contactLN, @contactMN, @contactNo, @MemberID)"; parameters = new Dictionary<string, object>(); parameters.Add("@contactFN", txtCPFN.Text); parameters.Add("@contactLN", txtCPLN.Text); parameters.Add("@contactMN", txtCPMN.Text); parameters.Add("@contactNo", txtContact.Text); parameters.Add("@MemberID", MemberID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); sql = "INSERT INTO CONTACTINFORMATION (street, municipality, cityProvince, zipCode, residenceSince, telephoneNo, MemberID) VALUES (@street, @municipality, @cityProvince, @zipCode, @residenceSince, @telephoneNo, @MemberID)"; parameters = new Dictionary<string, object>(); parameters.Add("@street", txtStreet.Text); parameters.Add("@municipality", txtMunicipality.Text); parameters.Add("@cityProvince", txtCity.Text); parameters.Add("@zipCode", txtZip.Text); parameters.Add("@residenceSince", txtResidence.Text); parameters.Add("@telephoneNo", txtTelNo.Text); parameters.Add("@MemberID", MemberID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (checkBox2.Checked == true) { sql = "INSERT INTO CONTACTINFORMATION (street, municipality, cityProvince, zipCode, residenceSince, telephoneNo, MemberID) VALUES (@street, @municipality, @cityProvince, @zipCode, @residenceSince, @telephoneNo, @MemberID)"; parameters = new Dictionary<string, object>(); parameters.Add("@street", txtStreet2.Text); parameters.Add("@municipality", txtMunicipality2.Text); parameters.Add("@cityProvince", txtCity2.Text); parameters.Add("@zipCode", txtZip2.Text); parameters.Add("@residenceSince", txtResidence2.Text); parameters.Add("@telephoneNo", txtTelNo2.Text); parameters.Add("@MemberID", MemberID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); } addToEmploymentInformation(); con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "SELECT ISNULL(MAX(EmploymentInformationID),1) FROM EMPLOYMENTINFORMATION"; reader = con.executeReader(sql); if (reader.HasRows) { reader.Read(); EmploymentInformationID = reader.GetInt32(0); } if (occup == 0 || occup == 1 || occup == 2) { addToEmployed(); } else if (occup == 3) { addToSelfEmployed(); } if (checkBox5.Checked == true) { addFatherRelationship(); } if (checkBox1.Checked == true) { addMotherRelationship(); } if (checkBox3.Checked == true) { addSpouseRelationship(); } if (tableChild.Rows.Count > 0) { for (int ind = 0; ind < tableChild.Rows.Count; ind++) { addChildrenRelationship(ind); } } this.Close(); } else { MessageBox.Show("Adding a member is not successful.", "Error", MessageBoxButtons.OK); } } else { MessageBox.Show("Some required fields are missing/invalid!", "Error"); } } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE MEMBER SET fName = @fName, mName = @mName, lName = @lName, gender = @gender, birthDate = @birthDate, civilStatus = @civilStatus, gsisNo = @gsisNo, educAttainment = @educAttainment, paidMembershipFee = @paidMembershipFee, applyDate = @applyDate, seminarDate = @seminarDate, initialCapital = @initialCapital, multiplier = @multiplier, MemberTypeID = (SELECT MemberTypeID FROM MEMBERTYPE WHERE MemberTypeName = @MemberTypeName) WHERE MemberID = " + SLS.Static.ID + " "; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@fName", txtFN.Text); parameters.Add("@mName", txtMN.Text); parameters.Add("@lName", txtLN.Text); parameters.Add("@birthDate", Convert.ToDateTime(dtDateBirth.Value)); parameters.Add("@gender", Convert.ToInt32(cmbGender.SelectedIndex)); parameters.Add("@MemberTypeName", cmbMemberType.SelectedItem.ToString()); parameters.Add("@civilStatus", Convert.ToInt32(cmbCivil.SelectedIndex)); parameters.Add("@gsisNo", txtGSISSSS.Text); parameters.Add("@educAttainment", Convert.ToInt32(cmbEduc.SelectedIndex)); parameters.Add("@paidMembershipFee", Convert.ToDecimal(txtFee.Text)); parameters.Add("@applyDate", Convert.ToDateTime(dtMembership.Value)); parameters.Add("@seminarDate", Convert.ToDateTime(dtSeminar.Value)); parameters.Add("@initialCapital", Convert.ToDecimal(txtInitialCapital.Text)); parameters.Add("@multiplier", Convert.ToInt32(txtMultiplier.Text)); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a member is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); //Employment Information Delete con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "SELECT EmploymentInformationID FROM EMPLOYMENTINFORMATION WHERE MemberID = " + SLS.Static.ID + ""; SqlDataReader reader = con.executeReader(sql); if (reader.HasRows) { reader.Read(); int employID = Convert.ToInt32(reader[0]); //Employed Delete sql = "DELETE FROM EMPLOYED WHERE EmploymentInformationID = employID"; parameters = new Dictionary<string, object>(); parameters.Add("employID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); //Self-Employed Delete sql = "DELETE FROM SELFEMPLOYED WHERE EmploymentInformationID = employID"; parameters = new Dictionary<string, object>(); parameters.Add("employID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); } //Contact Person Delete con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "DELETE FROM CONTACTPERSON WHERE MemberID = @MemberID"; parameters = new Dictionary<string, object>(); parameters.Add("@MemberID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); //Contact Information Delete con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "DELETE FROM CONTACTINFORMATION WHERE MemberID = @MemberID"; parameters = new Dictionary<string, object>(); parameters.Add("@MemberID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); sql = "DELETE FROM EMPLOYMENTINFORMATION WHERE MemberID = @MemberID"; parameters = new Dictionary<string, object>(); parameters.Add("@MemberID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); //Family BackGround Delete sql = "DELETE FROM FAMILYBACKGROUND WHERE MemberID = @MemberID"; parameters = new Dictionary<string, object>(); parameters.Add("@MemberID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); defaultAll(); this.Close(); } else { MessageBox.Show("Updating a member is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public void addMotherRelationship() { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO FAMILYBACKGROUND (fName,mName, lName, birthDate, gender, relationship, MemberID) VALUES (@fName, @mName, @lName, @birthDate, @gender, @relationship, @MemberID)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@fName", txtMNFN.Text); parameters.Add("@mName", txtMNMN.Text); parameters.Add("@lName", txtMNLN.Text); parameters.Add("@birthDate", Convert.ToDateTime(dtMN.Value)); parameters.Add("@gender", "2"); parameters.Add("@relationship", "Mother"); parameters.Add("@MemberID", MemberID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); }
private void btnSave_Click(object sender, EventArgs e) { if(SLS.Static.ID == 0) { if (checkValues() == 1) { MessageBox.Show("Some required field/s are missing or invalid.", "Error", MessageBoxButtons.OK); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO DORMANCY (inactivityValue, inactivityTime, deductionAmount, isPercentage, deductionMode, activationFee, [status], SavingsTypeID) VALUES (@inactivityValue, @inactivityTime, @deductionAmount, @isPercentage, @deductionMode, @activationFee, @status, (SELECT SavingsTypeID FROM SAVINGSTYPE WHERE savingsTypeName = @savingsTypeName))"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@inactivityValue", txtInactiveValue.Text); parameters.Add("@inactivityTime", cobInactiveTime.SelectedIndex); parameters.Add("@deductionAmount", txtDeductAmount.Text); parameters.Add("@isPercentage", cobDeductNature.SelectedIndex); parameters.Add("@deductionMode", cobDeductMode.SelectedIndex); parameters.Add("@activationFee", txtActivateFee.Text); parameters.Add("@status", true); parameters.Add("@savingsTypeName", cobSavingsType.SelectedItem.ToString()); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Adding a dormancy is successful.", "Saved", MessageBoxButtons.OK); con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "UPDATE SAVINGSTYPE SET hasDormancy = 'true' WHERE SavingsTypeID = (SELECT SavingsTypeID FROM DORMANCY WHERE DormancyID = (SELECT MAX(DormancyID) FROM DORMANCY))"; parameters = new Dictionary<string, object>(); parameters.Add("@status", true); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); this.Close(); } else { MessageBox.Show("Adding a dormancy is not suuccessful.", "Error", MessageBoxButtons.OK); } } } else { if (checkValues() == 1) { MessageBox.Show("Some required field/s are missing or invalid.", "Error", MessageBoxButtons.OK); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE DORMANCY SET inactivityValue = @inactivityValue, inactivityTime = @inactivityTime, deductionAmount = @deductionAmount, isPercentage = @isPercentage, deductionMode = @deductionMode, activationFee = @activationFee, [status] = @status, SavingsTypeID = (SELECT SavingsTypeID FROM SAVINGSTYPE WHERE savingsTypeName = @savingsTypeName) WHERE DormancyID = @DormancyID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@inactivityValue", txtInactiveValue.Text); parameters.Add("@inactivityTime", cobInactiveTime.SelectedIndex); parameters.Add("@deductionAmount", txtDeductAmount.Text); parameters.Add("@isPercentage", cobDeductNature.SelectedIndex); parameters.Add("@deductionMode", cobDeductMode.SelectedIndex); parameters.Add("@activationFee", txtActivateFee.Text); parameters.Add("@status", true); parameters.Add("@savingsTypeName", cobSavingsType.Text.ToString()); parameters.Add("@DormancyID", DormancyID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updated.", "Saved", MessageBoxButtons.OK); this.Close(); } else { MessageBox.Show("Not Updated.", "Error", MessageBoxButtons.OK); } } } }
public void addToSelfEmployed() { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO SELFEMPLOYED (typeOfBusiness, startingCapital, monthlyNetIncome, businessAddress, presentCapital, EmploymentInformationID) VALUES (@typeOfBusiness, @startingCapital, @monthlyNetIncome, @businessAddress, @presentCapital, @EmploymentInformationID)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@typeOfBusiness", txtTypeOfBusiness.Text); parameters.Add("@startingCapital", Convert.ToDecimal(txtStartingCapital.Text)); parameters.Add("@monthlyNetIncome", Convert.ToDecimal(txtMonthlyNetIncome.Text)); parameters.Add("@businessAddress", txtBusinessAdd.Text); parameters.Add("@presentCapital", Convert.ToDecimal(txtPresentCapital.Text)); parameters.Add("@EmploymentInformationID", EmploymentInformationID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); }
public void addToEmploymentInformation() { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO EMPLOYMENTINFORMATION (employmentNo, MemberID) VALUES (@employmentNo, @MemberID)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@employmentNo", occup); parameters.Add("@MemberID", MemberID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (rbGovernment.Checked==true) { emptype = 1; } else if (rbPrivate.Checked==true) { emptype = 2; } else if (rbAbroad.Checked==true) { emptype = 3; } }
private void btnSave_Click(object sender, EventArgs e) { if (RateID == 0 || checkValues() != 0) { if(RateID == 0) { MessageBox.Show("Choose a time deposit rate.", "Error"); } else if(checkValues() != 0) { MessageBox.Show("Some required fields are missing or invalid.", "Error"); } } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = " INSERT INTO TIMEDEPOSITACCOUNT(MemberID,TimeDepositRatesID,dateOpened,dateMaturity,currentBalance,isClosed) VALUES (@MemberID,@TimeDepositRatesID,@dateOpened,DATEADD(DAY,(SELECT noOfDays FROM TIMEDEPOSITRATES WHERE TimeDepositRatesID = @RatesID),@DateNow),@currentBalance,@isClosed)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@MemberID", SLS.Static.ID); parameters.Add("@TimeDepositRatesID", RateID); parameters.Add("@dateOpened", Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))); parameters.Add("@DateNow", Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))); parameters.Add("@RatesID", RateID); parameters.Add("@currentBalance", Convert.ToDecimal(txtAmount.Text)); parameters.Add("@isClosed", false); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); this.Close(); } }
private void btnSave_Click(object sender, EventArgs e) { if (SLS.Static.ID == 0) { if (checkValues() == 0) { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO CREDITINVESTIGATOR (fName, mName, lName, [status]) VALUES (@fName, @mName, @lName, @status)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@fName", txtFN.Text); parameters.Add("@mName", txtMN.Text); parameters.Add("@lName", txtLN.Text); parameters.Add("@status", true); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Adding a credit investigator is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("Adding a credit investigator is not successful.", "Error", MessageBoxButtons.OK); } } else { MessageBox.Show("Some required fields are missing/invalid!", "Error"); } } else { if (checkValues() == 0) { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE CREDITINVESTIGATOR SET fName = @fName, mName = @mName, lName = @lName WHERE ciID = " + SLS.Static.ID + " "; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@fName", txtFN.Text); parameters.Add("@mName", txtMN.Text); parameters.Add("@lName", txtLN.Text); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a credit investigator is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); defaultAll(); this.Close(); } else { MessageBox.Show("Updating a credit investigator is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Some required fields are missing/invalid!", "Error"); } } }
private void btnStatus_Click(object sender, EventArgs e) { if(btnStatus.Text == "DELETE") { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE TIMEDEPOSITPENALTY SET [status] = @status WHERE TimeDepositPenaltyID = @TimeDepositPenaltyID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@status", false); parameters.Add("@TimeDepositPenaltyID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a time deposit rate is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); SLS.Static.ID = 0; loadDatabase(); } else { MessageBox.Show("Updating a time deposit rate is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "SELECT minElapsed, maxElapsed FROM TIMEDEPOSITPENALTY WHERE TimeDepositPenaltyID = " + SLS.Static.ID + " "; SqlDataReader reader = con.executeReader(sql); if(reader.HasRows) { reader.Read(); min = Convert.ToDecimal(reader[0]); max = Convert.ToDecimal(reader[1]); } int isValid = 0; con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "SELECT minElapsed, maxElapsed FROM TIMEDEPOSITPENALTY WHERE [status] = 1"; reader = con.executeReader(sql); if (reader.HasRows) { while (reader.Read() && isValid == 0) { for (Decimal i = min; (i <= max) && isValid == 0; i = i + Convert.ToDecimal(0.01)) { if (i >= Convert.ToDecimal(reader[0]) && i <= Convert.ToDecimal(reader[1])) { isValid = 1; } } } } if(isValid == 0) { con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "UPDATE TIMEDEPOSITPENALTY SET [status] = @status WHERE TimeDepositPenaltyID = @TimeDepositPenaltyID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@status", true); parameters.Add("@TimeDepositPenaltyID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a time deposit rate is successful.", "Saved", MessageBoxButtons.OK); SLS.Static.ID = 0; loadDatabase(); } else { MessageBox.Show("Updating a time deposit rate is not successful.", "Error", MessageBoxButtons.OK); } } else { MessageBox.Show("Another elapsed time is active.\nDisable first the active one.", "Error", MessageBoxButtons.OK); } } }
private void btnSave_Click(object sender, EventArgs e) { if (SLS.Static.ID == 0) { if (checkValues() != 0) { MessageBox.Show("Some required field/s are missing or invalid.", "Error", MessageBoxButtons.OK); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO SAVINGSTYPE (savingsTypeName, interestRate, initialDeposit, maintainingBalance, balanceToEarn, maxWithdrawAmount, maxWithdrawMode, hasDormancy, [status]) VALUES (@savingsTypeName, @interestRate, @initialDeposit, @maintainingBalance, @balanceToEarn, @maxWithdrawAmount, @maxWithdrawMode, @hasDormancy, @status)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@savingsTypeName", txtSavName.Text); parameters.Add("@interestRate", txtInterest.Text); parameters.Add("@initialDeposit", txtInitial.Text); parameters.Add("@maintainingBalance", txtMainBal.Text); parameters.Add("@balanceToEarn", txtBalToEarn.Text); if (ckbMaxWithdraw.Checked == true) { parameters.Add("@maxWithdrawAmount", txtMaxAmount.Text); parameters.Add("@maxWithdrawMode", (cobMaxMode.SelectedIndex) + 1); } else { parameters.Add("@maxWithdrawAmount", 0); parameters.Add("@maxWithdrawMode", 0); } parameters.Add("@hasDormancy", false); parameters.Add("@status", true); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Adding a savings type is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); foreach (object itemChecked in cklbMemberType.CheckedItems) { con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "INSERT INTO APPLICABLESAVINGS (SavingsTypeID,MemberTypeID) VALUES ((SELECT MAX(SavingsTypeID) FROM SAVINGSTYPE),(SELECT MemberTypeID FROM MEMBERTYPE WHERE memberTypeName = @memberTypeName))"; parameters = new Dictionary<string, object>(); parameters.Add("@memberTypeName", itemChecked.ToString()); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); } this.Close(); } else { MessageBox.Show("Adding a savings type is not successful.", "Error", MessageBoxButtons.OK); } } } else { if (checkValues() != 0) { MessageBox.Show("Some required field/s are missing or invalid", "Error", MessageBoxButtons.OK); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE SAVINGSTYPE SET savingsTypeName = @savingsTypeName, interestRate = @interestRate, initialDeposit = @initialDeposit, maintainingBalance = @maintainingBalance, balanceToEarn = @balanceToEarn, maxWithdrawAmount = @maxWithdrawAmount, maxWithdrawMode = @maxWithdrawMode, [status] = @status WHERE SavingsTypeID = @SavingsTypeID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@savingsTypeName", txtSavName.Text); parameters.Add("@interestRate", txtInterest.Text); parameters.Add("@initialDeposit", txtInitial.Text); parameters.Add("@maintainingBalance", txtMainBal.Text); parameters.Add("@balanceToEarn", txtBalToEarn.Text); if (ckbMaxWithdraw.Checked == true) { parameters.Add("@maxWithdrawAmount", txtMaxAmount.Text); parameters.Add("@maxWithdrawMode", (cobMaxMode.SelectedIndex) + 1); } else { parameters.Add("@maxWithdrawAmount", 0); parameters.Add("@maxWithdrawMode", 0); } parameters.Add("@status", true); parameters.Add("@SavingsTypeID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a savings type is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "DELETE FROM APPLICABLESAVINGS WHERE SavingsTypeID = @SavingsTypeID"; parameters = new Dictionary<string, object>(); parameters.Add("@SavingsTypeID", SLS.Static.ID); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); foreach (object itemChecked in cklbMemberType.CheckedItems) { con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "INSERT INTO APPLICABLESAVINGS (SavingsTypeID,MemberTypeID) VALUES (@SavingsTypeID, (SELECT MemberTypeID FROM MEMBERTYPE WHERE memberTypeName = @memberTypeName))"; parameters = new Dictionary<string, object>(); parameters.Add("@SavingsTypeID", SLS.Static.ID); parameters.Add("@memberTypeName", itemChecked.ToString()); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); } this.Close(); } else { MessageBox.Show("Updating a savings type is not successful.", "Error", MessageBoxButtons.OK); } } } }
private void btnSave_Click(object sender, EventArgs e) { if(SLS.Static.ID == 0) { if(checkValues() == 1) { MessageBox.Show("Some required fields are missing or invalid.", "Error"); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO LOANTYPE (loanTypeName, minAmount, maxAmount, noOfComaker, entitlement, eligibility, [status]) VALUES (@loanTypeName, @minAmount, @maxAmount, @noOfComaker, @entitlement, @eligibility, @status); SELECT CAST(scope_identity() AS int)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@loanTypeName", txtLoanType.Text); parameters.Add("@minAmount", txtMinAmount.Text); parameters.Add("@maxAmount", txtMaxAmount.Text); parameters.Add("@noOfComaker", txtNoOfComaker.Text); parameters.Add("@entitlement", txtEntitlement.Text); parameters.Add("@eligibility", txtEligibility.Text); parameters.Add("@status", true); SqlDataReader reader = con.executeReader(sql, parameters); if (reader.HasRows) { reader.Read(); MessageBox.Show("Adding a loan type is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); foreach (object itemChecked in cListMemType.CheckedItems) { con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "INSERT INTO APPLICABLELOAN (LoanTypeID, MemberTypeID) VALUES (@LoanTypeID,(SELECT MemberTypeID FROM MEMBERTYPE WHERE memberTypeName = @memberTypeName))"; parameters = new Dictionary<string, object>(); parameters.Add("@LoanTypeID", reader[0]); parameters.Add("@memberTypeName", itemChecked.ToString()); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); } modeArr = new String[cListMode.Items.Count]; int sInd = 0; for (int i = 0; i < cListMode.Items.Count; i++) { if (cListMode.GetItemCheckState(i) == CheckState.Checked) { modeArr[sInd] = Convert.ToString(cListMode.Items[i]); sInd++; } } termArr = new Int32[cListTerm.Items.Count]; sInd = 0; for (int i = 0; i < cListTerm.Items.Count; i++) { if (cListTerm.GetItemCheckState(i) == CheckState.Checked) { termArr[sInd] = Convert.ToInt32(cListTerm.Items[i].ToString()); sInd++; } } for (int j = 0; j <= dataGridView1.Rows.Count - 1; j++) { for (int k = 2; k <= dataGridView1.Columns.Count - 1; k++) { con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "INSERT INTO LOANRATE (ModeID, ChargeID, TermID, LoanTypeID, rate) VALUES ((SELECT ModeID FROM MODE WHERE modeName = @modeName AND [status] = 1), @ChargeID, (SELECT TermID FROM TERM WHERE noOfDays = @noOfDays AND [status] = 1), @LoanTypeID, @rate)"; parameters = new Dictionary<string, object>(); parameters.Add("@modeName", modeArr[(k - 2) / cListTerm.CheckedItems.Count]); parameters.Add("@ChargeID", Convert.ToInt32(dataGridView1.Rows[j].Cells[0].Value.ToString())); parameters.Add("@noOfDays", termArr[(k - 2) / cListMode.CheckedItems.Count]); parameters.Add("@LoanTypeID", reader[0]); parameters.Add("@rate", Convert.ToDecimal(dataGridView1.Rows[j].Cells[k].Value.ToString())); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); } } this.Close(); } else { MessageBox.Show("Adding a loan type is not successful.", "Error", MessageBoxButtons.OK); } } } }
private void btnSave_Click(object sender, EventArgs e) { if (SLS.Static.ID == 0) { if (checkValues() == 0) { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO [USER] (fName, mName, lName, username, [password], accountID, securityQuestion, securityAnswer, [status]) VALUES (@fName, @mName, @lName, @username, @password, @accountID, @securityQuestion, @securityAnswer, @status)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@fName", txtFN.Text); parameters.Add("@mName", txtMN.Text); parameters.Add("@lName", txtLN.Text); parameters.Add("@username", txtUser.Text); parameters.Add("@password", txtPass.Text); parameters.Add("@accountID", Convert.ToInt32(cmbAccount.SelectedIndex)); parameters.Add("@securityQuestion", Convert.ToString(cmbQuestion.SelectedItem)); parameters.Add("@securityAnswer", txtAnswer.Text); parameters.Add("@status", true); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Adding a User Account is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("Adding a User Account is not successful.", "Error", MessageBoxButtons.OK); } } else { MessageBox.Show("Some required fields are missing/invalid!", "Error"); } } else { if (checkValues() == 0) { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE [USER SET fName = @fName, mName = @mName, lName = @lName, username = @username, [password] = @password, accountID = @accountID, securityQuestion = @securityQuestion, securityAnswer = @securityAnswer WHERE UserID = " + SLS.Static.ID + " "; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@fName", txtFN.Text); parameters.Add("@mName", txtMN.Text); parameters.Add("@lName", txtLN.Text); parameters.Add("@username", txtUser.Text); parameters.Add("@password", txtPass.Text); parameters.Add("@accountID", Convert.ToInt32(cmbAccount.SelectedIndex)); parameters.Add("@securityQuestion", Convert.ToString(cmbQuestion.SelectedItem)); parameters.Add("@securityAnswer", txtAnswer.Text); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a User Account is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); defaultAll(); this.Close(); } else { MessageBox.Show("Updating a User Account is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Some required fields are missing/invalid!", "Error"); } } }
private void btnOK_Click(object sender, EventArgs e) { if (checkValues() == 1) { MessageBox.Show("Some required field/s are missing or invalid.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO SAVINGSACCOUNT(MemberID, SavingsTypeID, dateOpened, currentBalance) VALUES (@MemberID, @SavingsTypeID, @dateOpened, @currentBalance)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@MemberID", MemberID); parameters.Add("@SavingsTypeID", SavingsID); parameters.Add("@dateOpened", Convert.ToDateTime(txtDate.Text)); parameters.Add("@currentBalance", txtDeposit.Text); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Creating a new savings account is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); sql = "INSERT INTO SAVINGSTRANSACTION(transactionDate, transactionType, transactionAmount, transactionRepresentative, currentBalance, SavingsAccountID) VALUES (@transactionDate, @transactionType, @transactionAmount, (SELECT CONCAT(fName,' ',mName,' ', lName) FROM MEMBER WHERE MemberID = @MemberID), @currentBalance, (SELECT MAX(SavingsAccountID) FROM SAVINGSACCOUNT))"; parameters = new Dictionary<string, object>(); parameters.Add("@transactionDate", Convert.ToDateTime(txtDate.Text)); parameters.Add("@transactionType", 1); parameters.Add("@transactionAmount", txtDeposit.Text); parameters.Add("@MemberID", MemberID); parameters.Add("@currentBalance", txtDeposit.Text); result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); this.Close(); } else { MessageBox.Show("Creating a new savings account is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnSave_Click(object sender, EventArgs e) { if (SLS.Static.ID == 0) { if (checkValues() == 1) { MessageBox.Show("Some required field/s are missing or invalid.", "Error", MessageBoxButtons.OK); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "INSERT INTO TIMEDEPOSITRATES (NoOfDays, minAmount, maxAmount, interest, [status]) VALUES (@NoOfDays, @minAmount, @maxAmount, @interest, @status)"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@NoOfDays", Convert.ToInt32(txtNoOfDays.Text)); parameters.Add("@minAmount", Convert.ToDecimal(txtMinAmount.Text)); parameters.Add("@maxAmount", Convert.ToDecimal(txtMaxAmount.Text)); parameters.Add("@interest", Convert.ToDecimal(txtInterest.Text)); parameters.Add("@status", true); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Adding a time deposit rate is successful.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); defaultAll(); this.Close(); } else { MessageBox.Show("Adding a time deposit rate is not successful.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { if (checkValues() == 1) { MessageBox.Show("Some required field/s are missing or invalid.", "Error", MessageBoxButtons.OK); } else { SQLStatement con = new SQLStatement(SLS.Static.Server, SLS.Static.Database); String sql = "UPDATE TIMEDEPOSITRATES SET noOfDays = @noOfDays, minAmount = @minAmount, maxAmount = @maxAmount, interest = @interest WHERE TimeDepositRatesID = @TimeDepositRatesID"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@noOfDays", Convert.ToInt32(txtNoOfDays.Text)); parameters.Add("@minAmount", Convert.ToDecimal(txtMinAmount.Text)); parameters.Add("@maxAmount", Convert.ToDecimal(txtMaxAmount.Text)); parameters.Add("@interest", Convert.ToDecimal(txtInterest.Text)); parameters.Add("@TimeDepositRatesID", SLS.Static.ID); int result = Convert.ToInt32(con.executeNonQuery(sql, parameters)); if (result == 1) { MessageBox.Show("Updating a time deposit rate is successful.", "Saved", MessageBoxButtons.OK); defaultAll(); this.Close(); } else { MessageBox.Show("Updating a time deposit rate is not successful.", "Error", MessageBoxButtons.OK); } } } }