private void btnClearPic_Click(object sender, EventArgs e)
{
string paths = PhotoPath.getPath();
picMember.Image = Image.FromFile(paths + "\\photos\\profile_img.png");
photoName = string.Empty;
}
private void btnLoadPic_Click(object sender, EventArgs e)
{
OpenFileDialog open = new OpenFileDialog();
open.InitialDirectory = "C:\\";
open.Filter = "Image Files(*.jpg)|*.jpg|All Files(*.*)|*.*";
open.FilterIndex = 1;
if (open.ShowDialog() == DialogResult.OK)
{
if (open.CheckFileExists)
{
string paths = PhotoPath.getPath();
string correctFileName = System.IO.Path.GetFileName(open.FileName);
string fileSuffix = DateTime.Now.ToString("dd_MM_yy_hh_mm_ss");
try
{
photoName = "userphoto" + fileSuffix + ".jpg";
System.IO.File.Copy(open.FileName, paths + "\\photos\\" + photoName);
picMember.Image = Image.FromFile(paths + "\\photos\\" + photoName);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
}
}
}
private void btnFindMember_Click(object sender, EventArgs e)
{
//Build Savings Table with Personal Savings Account Type and other Savings Account Type using the BuildTempSavingsAcctType Class
BuildTempSavingsAcctType.Create();
SqlConnection conn = ConnectDB.GetConnection();
string strQuery = "Select MemberID, FileNo, LastName + ' ' + FirstName + ' ' + MiddleName as FullName, Photo from Members " +
"where FileNo='" + txtFileNo.Text.Trim() + "'";
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = strQuery;
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
memberID = Convert.ToInt16(reader["MemberID"].ToString());
lblMemberProfile.Text = reader["FullName"].ToString() + "\n" + reader["FileNo"].ToString();
//display member photo
string paths = PhotoPath.getPath();
//MessageBox.Show(reader["Photo"].ToString());
if (reader["Photo"].ToString() != string.Empty)
{
picMember.Image = Image.FromFile(paths + "\\photos\\" + reader["Photo"].ToString());
}
else
{
picMember.Image = Image.FromFile(paths + "\\photos\\profile_img.png");
}
picMember.Visible = true;
lblMemberProfile.Visible = true;
grpBoxSavingsInfo.Enabled = true;
loadDataSetSavingsForward();
loadDataSetMemberSavings();
}
else
{
MessageBox.Show("Sorry, there is no Member with that File No.", "Savings", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
private void btnGetMember_Click(object sender, EventArgs e)
{
SqlConnection conn = ConnectDB.GetConnection();
string strQuery = "Select m.MemberID,m.FileNo,m.Title,m.FirstName,m.LastName,m.MiddleName,m.Photo " +
"from Members m where m.FileNo='" + txtFileNo.Text.Trim() + "'";
SqlCommand cmd = new SqlCommand(strQuery, conn);
string paths = PhotoPath.getPath();
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
if (reader.Read())
{
picMember.Visible = true;
lblMemberInfo.Visible = true;
lblMemberInfo.Text = reader["Title"].ToString() + ' ' + reader["LastName"].ToString() + ' ' + reader["FirstName"].ToString() + ' ' + reader["MiddleName"].ToString();
if (reader["Photo"].ToString() != string.Empty)
{
picMember.Image = Image.FromFile(paths + "\\photos\\" + reader["Photo"].ToString());
}
else
{
picMember.Image = Image.FromFile(paths + "\\photos\\profile_img.png");
}
memberID = reader["MemberID"].ToString();
//getMember Savings Account Types
cboSavingsType.DataSource = null;
getMemberSavingsAccountType(memberID);
getPreviousWithdrawals();
}
}
else
{
lblMemberInfo.Text = string.Empty;
picMember.Image = Image.FromFile(paths + "\\photos\\profile_img.png");
picMember.Visible = false;
lblMemberInfo.Visible = false;
MessageBox.Show("There is no record with that FileNo.", "Withdrawal", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
private int findMember(string fileNo, SqlConnection conn)
{
int memberID = 0;
string strQuery = "Select MemberID, FileNo, Title + ' ' + LastName + ' ' + MiddleName + ' ' + FirstName as FullName, Photo from Members where FileNo='" + fileNo + "'";
SqlCommand cmd = new SqlCommand(strQuery, conn);
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
string paths = PhotoPath.getPath();
if (reader.HasRows)
{
if (reader.Read())
{
memberID = Convert.ToInt16(reader["MemberID"]);
MemberProfileInfo.Text = reader["FullName"].ToString() + "\n" + reader["FileNo"].ToString();;
if (reader["Photo"].ToString() != string.Empty)
{
picMember.Image = Image.FromFile(paths + "\\photos\\" + reader["Photo"].ToString());
}
else
{
picMember.Image = Image.FromFile(paths + "\\photos\\profile_img.png");
}
MemberProfileInfo.Visible = true;
picMember.Visible = true;
btnSave.Enabled = true;
}
}
else
{
picMember.Image = Image.FromFile(paths + "\\photos\\profile_img.png");
picMember.Visible = false;
MemberProfileInfo.Visible = false;
btnSave.Enabled = false;
MessageBox.Show("Sorry, that Record is not Found!", "Make Contributions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(memberID);
}
private int fetchMemberProfileData(int memberID, string selectedRecordFileNo, SqlConnection conn)
{
string strQuery = "Select m.MemberID, m.FileNo, m.Title, m.FirstName, m.MiddleName, m.LastName, m.Gender, m.Address," +
"m.LGA, s.State, m.Phone, m.Email, d.DepartmentName, b.BankName, m.AccountNo, m.Photo,m.NOKFullName,m.NOKAddress," +
"m.NOKPhone from Members m inner join States s on m.StateID = s.StateID " +
"inner join Departments d on m.DepartmentID = d.DepartmentID " +
"inner join Banks b on m.BankID = b.BankID " +
"where m.FileNo='" + selectedRecordFileNo + "'";
SqlCommand cmd = new SqlCommand(strQuery, conn);
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
txtFileNo.Text = reader["FileNo"].ToString();
txtTitle.Text = reader["Title"].ToString();
txtFirstName.Text = reader["FirstName"].ToString();
txtMIddleName.Text = reader["MiddleName"].ToString();
txtLastName.Text = reader["LastName"].ToString();
txtGender.Text = (reader["Gender"].ToString() == "M" ? "Male" : "Female");
txtAddress.Text = reader["Address"].ToString();
txtLGA.Text = reader["LGA"].ToString();
txtState.Text = reader["State"].ToString();
txtPhone.Text = reader["Phone"].ToString();
txtEmail.Text = reader["EMail"].ToString();
txtDepartment.Text = reader["DepartmentName"].ToString();
txtBank.Text = reader["BankName"].ToString();
txtAccountNo.Text = reader["AccountNo"].ToString();
txtNOKName.Text = reader["NOKFullName"].ToString();
txtNOKAddress.Text = reader["NOKAddress"].ToString();
txtNOKPhone.Text = reader["NOKPhone"].ToString();
string paths = PhotoPath.getPath();
if (reader["Photo"].ToString() != string.Empty)
{
//Load User picture
//string paths = Application.StartupPath.Substring(0, (Application.StartupPath.Length - 9));
picMember.Image = Image.FromFile(paths + "\\photos\\" + reader["Photo"].ToString());
//MessageBox.Show(paths);
}
else
{
picMember.Image = Image.FromFile(paths + "\\photos\\profile_img.png");
}
memberID = (int)reader["MemberID"];
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(memberID);
}
private void getSuretyData(string strSender, string memberFileNo)
{
string memberProfile = string.Empty;
string memberID = string.Empty;
string memberPic = string.Empty;
string paths = PhotoPath.getPath();
SqlConnection conn = ConnectDB.GetConnection();
string strQuery = "Select MemberID,FileNo,Title,LastName,MiddleName,FirstName,Photo from Members where FileNo='" + memberFileNo + "'";
SqlCommand cmd = new SqlCommand(strQuery, conn);
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
memberProfile = reader["Title"].ToString() + " " + reader["LastName"].ToString() + " " + reader["FirstName"].ToString() + " " + reader["MiddleName"].ToString();
memberID = reader["MemberID"].ToString();
memberPic = reader["Photo"].ToString();
switch (strSender)
{
case "Surety1":
lblSurety1.Visible = true;
picSurety1.Visible = true;
lblSurety1.Text = "Surety 1\n" + memberProfile;
lblSuretyMemberID_1.Text = memberID;
if (memberPic != string.Empty)
{
picSurety1.Image = Image.FromFile(paths + "//photos//" + memberPic.ToString());
}
break;
case "Surety2":
lblSurety2.Visible = true;
picSurety2.Visible = true;
lblSurety2.Text = "Surety 2\n" + memberProfile;
lblSuretyMemberID_2.Text = memberID;
if (memberPic != string.Empty)
{
picSurety2.Image = Image.FromFile(paths + "//photos//" + memberPic.ToString());
}
break;
case "Witness":
lblWitness.Visible = true;
picWitness.Visible = true;
lblWitness.Text = "Witness\n" + memberProfile;
lblSuretyMemberID_3.Text = memberID;
if (memberPic != null || memberPic == string.Empty)
{
picWitness.Image = Image.FromFile(paths + "//photos//" + memberPic.ToString());
}
break;
}//end of Switch
}
else
{
MessageBox.Show("Sorry, there is no member with the File No. [" + memberFileNo + "]", "Loan Application", MessageBoxButtons.OK, MessageBoxIcon.Error);
switch (strSender)
{
case "Surety1":
txtSuretyFileNo1.Clear();
break;
case "Surety2":
txtSuretyFileNo2.Clear();
break;
case "Witness":
txtWitnessFileNo.Clear();
break;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
private void loadMemberRegisteredSavingsType()
{
decimal totalSavings = 0;
SqlConnection conn = ConnectDB.GetConnection();
string strQuery = "Select m.MemberID, m.FileNo, m.Title + ' ' + m.LastName + ' ' + m.MiddleName + ' ' + m.FirstName as [FullName], " +
"m.Photo, m.DateCreated as RegDateCreated, t.SavingsName, s.SavingsAcctID, s.Amount, s.Remark, " +
"s.DateCreated as SavingsDateCreated from Members m left join MemberSavingsTypeAcct s on m.MemberID=s.MemberID " +
"left join SavingsType t on s.SavingsTypeID=t.SavingsTypeID where m.FileNo='" + txtFileNo.Text.Trim() + "'";
/**
* string strSharesQuery = "Select m.MemberID, m.FileNo, s.Shares from Members m " +
* "inner join Shares s on m.MemberID=s.MemberID where m.FileNo='" + txtFileNo.Text.Trim() + "'";
**/
SqlCommand cmd = new SqlCommand(strQuery, conn);
//SqlCommand cmdShares = new SqlCommand(strSharesQuery, conn);
try
{
conn.Open();
/****Execute and read shares --- Modification after first Observation meeting with Client
* SqlDataReader reader = cmdShares.ExecuteReader();
* if (reader.HasRows)
* {
* if (reader.Read())
* {
* txtShares.Text = CheckForNumber.formatCurrency(reader["Shares"].ToString());
* }
* }
* reader.Close();
*
* ***/
//Execute and read Regular Savings and other savings
SqlDataReader reader = cmd.ExecuteReader();
int recordCount = 0;
lstVSavings.Items.Clear();
//Check if record is found and start performing operation
if (reader.HasRows)
{
string paths = PhotoPath.getPath();
picMember.Visible = true;
lblMemberProfileInfo.Visible = true;
lblRegistrationDate.Visible = true;
#region Read Data from Reader
while (reader.Read())
{
recordCount++;
if (recordCount == 1)
{
//MessageBox.Show("Record Count: " + recordCount.ToString());
if (reader["Photo"].ToString() != string.Empty)
{
picMember.Image = Image.FromFile(paths + "\\photos\\" + reader["Photo"].ToString());
}
else
{
picMember.Image = Image.FromFile(paths + "\\photos\\profile_img.png");
}
lblMemberProfileInfo.Text = reader["FullName"].ToString() + "\n" + reader["FileNo"].ToString();
lblRegistrationDate.Text = "Member since " + string.Format("{0:ddd, MMM d, yyyy}", reader["RegDateCreated"]);
myselectedmemberID = (int)reader["MemberID"];
}
if (reader["Remark"].ToString() == "Shares Savings")
{
txtRegularSavings.Text = CheckForNumber.formatCurrency(reader["Amount"].ToString());
totalSavings += Convert.ToDecimal(reader["Amount"]);
continue;
}
string[] row = { reader["SavingsAcctID"].ToString(), reader["Remark"].ToString(), CheckForNumber.formatCurrency(reader["Amount"].ToString()), string.Format("{0:ddd, MMM d, yyyy}", reader["SavingsDateCreated"]) };
ListViewItem item = new ListViewItem(row);
lstVSavings.Items.Add(item);
totalSavings += Convert.ToDecimal(reader["Amount"]);
}
#endregion
}
else
{
MessageBox.Show("Sorry, Record with that FileNo is not found", "Members Savings", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
lblRecordNo.Text = "No. of Records : " + recordCount;
lblTotalSavings.Text = "Savings Total: " + CheckForNumber.formatCurrency2(totalSavings.ToString());
lblTotalSavings.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "-- loadMemberRegisteredSavingsType -- ");
}
finally
{
conn.Close();
}
}
private void btnFindMember_Click(object sender, EventArgs e)
{
clearAndSetControls();
decimal totalSavings = 0;
SqlConnection conn = ConnectDB.GetConnection();
/** - Modified about First Meeting
* string strSharesQuery = "Select m.MemberID, m.FileNo, s.SharesID, s.Shares, s.DateCreated from Members m " +
* "inner join Shares s on m.MemberID=s.MemberID where m.FileNo='" + txtFileNo.Text.Trim() + "'";
*
* **/
string strQuery = "Select m.MemberID, m.FileNo, m.Title + ' ' + m.LastName + ' ' + m.MiddleName + ' ' + m.FirstName as [FullName], m.Photo, m.DateCreated as RegDateCreated," +
"t.SavingsName, s.SavingsAcctID, s.Amount, s.Remark, s.DateCreated as SavingsDateCreated from Members m left outer join MemberSavingsTypeAcct s on m.MemberID=s.MemberID " +
"left outer join SavingsType t on s.SavingsTypeID=t.SavingsTypeID where m.FileNo='" + txtFileNo.Text.Trim() + "'";
//SqlCommand cmdShares = new SqlCommand(strSharesQuery, conn);
SqlCommand cmd = new SqlCommand(strQuery, conn);
try
{
conn.Open();
lstVSavings.Items.Clear();
/** Modified after first meeting....Shares is type of Savings
* SqlDataReader reader = cmdShares.ExecuteReader();
* if (reader.HasRows)
* {
* if (reader.Read())
* {
* string[] row = { reader["SharesID"].ToString(), "Shares", CheckForNumber.formatCurrency(reader["Shares"].ToString()), string.Format("{0:ddd, MMM d, yyyy}", reader["DateCreated"]) };
* ListViewItem item = new ListViewItem(row);
* lstVSavings.Items.Add(item);
* }
* }
* reader.Close();
* */
int counter = 0;
string paths = PhotoPath.getPath();
//MessageBox.Show(Application.StartupPath.ToString());
//MessageBox.Show(paths.ToString());
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
picMember.Visible = true;
lblMemberProfileInfo.Visible = true;
lblRegistrationDate.Visible = true;
while (reader.Read())
{
string[] row = { reader["SavingsAcctID"].ToString(), reader["Remark"].ToString(), CheckForNumber.formatCurrency(reader["Amount"].ToString()), string.Format("{0:ddd, MMM d, yyyy}", reader["RegDateCreated"]) };
ListViewItem item = new ListViewItem(row);
lstVSavings.Items.Add(item);
counter++;
totalSavings += Convert.ToDecimal(reader["Amount"]);
if (counter == 1)
{
if (reader["Photo"].ToString() != string.Empty)
{
picMember.Image = Image.FromFile(paths + "\\photos\\" + reader["Photo"].ToString());
}
else
{
picMember.Image = Image.FromFile(paths + "\\photos\\profile_img.png");
}
lblMemberProfileInfo.Text = reader["FullName"].ToString() + "\n" + reader["FileNo"].ToString();
lblRegistrationDate.Text = "Member since " + string.Format("{0:ddd, MMM d, yyyy}", reader["RegDateCreated"]);
myselectedmemberID = (int)reader["MemberID"];
}
}
}
else
{
clearAndSetControls();
MessageBox.Show("Sorry, Record with File No. [" + txtFileNo.Text + "] is not Found!", "Edit Member Savings", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
lblRecordNo.Text = "No. of Records: " + counter.ToString();
lblTotalSavings.Text = "Savings Total: " + CheckForNumber.formatCurrency2(totalSavings.ToString());
lblTotalSavings.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}