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