private void btnSearch_Click(object sender, EventArgs e)
{
string qry = "";
if (cboSearch.Text == "First Name")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldFirstName='" + txtSearch.Text.Replace("'","''") + "' ORDER BY fldLastName";
}
if (cboSearch.Text == "Last Name")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldLastName LIKE'%" + txtSearch.Text.Replace("'", "''") + "%' ORDER BY fldFirstName";
}
if (cboSearch.Text == "Nick Name")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldNickName LIKE '%" + txtSearch.Text.Replace("'", "''") + "%' ORDER BY fldFirstName,fldLastName";
}
if (cboSearch.Text == "Birth Day")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldBirthday LIKE '%" + dtSearch.Value.ToShortDateString() + "%' ORDER BY fldFirstName, fldLastName";
}
if (cboSearch.Text == "Barcode")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldStudentID='" + txtSearch.Text.Replace("'", "''") + "'";
string q = qry;
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
lblStudentID.Text = js.RiD["fldStudentID"].ToString();
txtFirstName.Text = js.RiD["fldFirstName"].ToString();
txtLastName.Text = js.RiD["fldLastName"].ToString();
txtMiddleName.Text = js.RiD["fldMiddleName"].ToString();
txtNickName.Text = js.RiD["fldNickName"].ToString();
dtBirthdate.Value = Convert.ToDateTime(js.RiD["fldBirthday"].ToString());
cboGender.Text = js.RiD["Gender"].ToString();
txtChurch.Text = js.Lookup("fldChurch", "tblChurch", "fldID='" + js.RiD["fldChurch"].ToString() + "'");
fldAddressDetails = js.RiD["fldAddressDetails"].ToString();
fldContactDetails = js.RiD["fldContactDetails"].ToString();
fldNationality = js.RiD["fldNationality"].ToString();
cboNationality.Text = js.RiD["fldNationality"].ToString();
txtPoints.Text = js.RiD["fldPoints"].ToString();
fldKidsID = js.RiD["fldID"].ToString();
int age = js.GetAge(dtBirthdate.Value);
txtAge.Text = age.ToString();
txtAllergies.Text = js.RiD["fldAllergies"].ToString();
string status = js.RiD["fldUpdateStatus"].ToString();
txtStatus.Text = js.Lookup("fldStatus", "tblStatus", "fldID='" + status + "'");
txtRemarks.Text = js.RiD["fldRemarks"].ToString();
if (age >= 10)
{
//chkTick.Enabled = true;
}
else
{
//chkTick.Enabled = false;
}
//FOR LOADING PICTURE
string picture = js.GetPath() + "/Kids/" + js.RiD["fldPicture"].ToString();
string temppic = Application.StartupPath + "/Pictures/tmp/Kids/tmp1.jpg";
if (System.IO.File.Exists(picture))
{
pbImage.Image.Dispose();
System.IO.File.Copy(picture, temppic, true);
pbImage.Image = System.Drawing.Image.FromFile(temppic);
}
js.CloseConnection();
//For the Address Details
q = "SELECT * FROM tblAddress WHERE fldID='" + fldAddressDetails + "'";
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
if (js.RiD.HasRows)
{
txtAddress1.Text = js.RiD["fldAddress1"].ToString();
txtAddress2.Text = js.RiD["fldAddress2"].ToString();
txtCity.Text = js.RiD["fldCity"].ToString();
txtZipCode.Text = js.RiD["fldZipCode"].ToString();
}
js.CloseConnection();
//For Contact Details
q = "SELECT * FROM tblContactDetails WHERE fldID='" + fldContactDetails + "'";
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
if (js.RiD.HasRows)
{
txtContactNo.Text = js.RiD["fldContactNumber"].ToString();
}
js.CloseConnection();
return;
}
//js.searchquery = qry;
frmResults frm = new frmResults();
frm.Tag = qry;
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string q = frm.Tag.ToString();
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
lblStudentID.Text = js.RiD["fldStudentID"].ToString();
txtFirstName.Text = js.RiD["fldFirstName"].ToString();
txtLastName.Text = js.RiD["fldLastName"].ToString();
txtMiddleName.Text = js.RiD["fldMiddleName"].ToString();
txtNickName.Text = js.RiD["fldNickName"].ToString();
dtBirthdate.Value = Convert.ToDateTime(js.RiD["fldBirthday"].ToString());
cboGender.Text = js.RiD["Gender"].ToString();
txtChurch.Text = js.Lookup("fldChurch", "tblChurch", "fldID='" + js.RiD["fldChurch"].ToString() + "'");
fldAddressDetails = js.RiD["fldAddressDetails"].ToString();
fldContactDetails = js.RiD["fldContactDetails"].ToString();
fldNationality = js.RiD["fldNationality"].ToString();
cboNationality.Text = js.RiD["fldNationality"].ToString();
txtPoints.Text = js.RiD["fldPoints"].ToString();
fldKidsID = js.RiD["fldID"].ToString();
int age = js.GetAge(dtBirthdate.Value);
txtAge.Text = age.ToString();
txtAllergies.Text = js.RiD["fldAllergies"].ToString();
string status = js.RiD["fldUpdateStatus"].ToString();
txtStatus.Text = js.Lookup("fldStatus", "tblStatus", "fldID='" + status + "'");
txtRemarks.Text = js.RiD["fldRemarks"].ToString();
if (age >= 10)
{
//chkTick.Enabled = true;
}
else
{
//chkTick.Enabled = false;
}
//FOR LOADING PICTURE
string picture = js.GetPath() + "/Kids/" + js.RiD["fldPicture"].ToString();
string temppic = Application.StartupPath + "/Pictures/tmp/Kids/tmp1.jpg";
if (System.IO.File.Exists(picture))
{
//pbImage.Dispose();
pbImage.Image.Dispose();
System.IO.File.Copy(picture, temppic, true);
pbImage.Image = System.Drawing.Image.FromFile(temppic);
}
js.CloseConnection();
//For the Address Details
q = "SELECT * FROM tblAddress WHERE fldID='" + fldAddressDetails + "'";
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
if (js.RiD.HasRows)
{
txtAddress1.Text = js.RiD["fldAddress1"].ToString();
txtAddress2.Text = js.RiD["fldAddress2"].ToString();
txtCity.Text = js.RiD["fldCity"].ToString();
txtZipCode.Text = js.RiD["fldZipCode"].ToString();
}
js.CloseConnection();
//For Contact Details
q = "SELECT * FROM tblContactDetails WHERE fldID='" + fldContactDetails + "'";
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
js.ExecuteQuery(q);
js.RiD.Read();
if (js.RiD.HasRows)
{
txtContactNo.Text = js.RiD["fldContactNumber"].ToString();
}
js.CloseConnection();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (txtSearch.Text == "")
{
js.showExclamation("Cannot generate result with an empty field");
return;
}
string qry = "";
if (cboSearch.Text == "First Name")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldFirstName='" + txtSearch.Text.Replace("'", "''") + "' ORDER BY fldLastName";
}
if (cboSearch.Text == "Last Name")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldLastName='" + txtSearch.Text.Replace("'", "''") + "' ORDER BY fldFirstName";
}
if (cboSearch.Text == "Nick Name")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldNickName='" + txtSearch.Text.Replace("'", "''") + "' ORDER BY fldFirstName,fldLastName";
}
if (cboSearch.Text == "Birth Day")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldBirthday='" + dtSearch.Value.ToShortDateString() + "' ORDER BY fldFirstName,fldLastName";
}
if (cboSearch.Text == "Barcode")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldStudentID='" + txtSearch.Text.Replace("'", "''") + "' ORDER BY fldFirstName,fldLastName";
string q = qry;
try
{
js.ExecuteQuery(q);
}
catch(Exception ex )
{
MessageBox.Show(ex.Message,"", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
js.RiD.Read();
fetcherID = new string[3];
pbFetcher1.Image = Image.FromFile(Application.StartupPath + "/Pictures/download.jpg");
pbFetcher2.Image = Image.FromFile(Application.StartupPath + "/Pictures/download.jpg");
pbFetcher3.Image = Image.FromFile(Application.StartupPath + "/Pictures/download.jpg");
pbImage.Image = Image.FromFile(Application.StartupPath + "/Pictures/download.jpg");
lblStudentID.Text = js.RiD["fldStudentID"].ToString();
txtFirstName.Text = js.RiD["fldFirstName"].ToString().Replace("''","'");
txtLastName.Text = js.RiD["fldLastName"].ToString().Replace("''", "'");
txtMiddleName.Text = js.RiD["fldMiddleName"].ToString();
txtNickName.Text = js.RiD["fldNickName"].ToString();
DateTime bdate;
if (DateTime.TryParse(js.RiD["fldBirthday"].ToString(), out bdate))
{
dtBirthdate.Value = bdate;
}
//dtBirthdate.Value = Convert.ToDateTime(js.RiD["fldBirthday"].ToString());
cboGender.Text = js.RiD["Gender"].ToString();
txtChurch.Text = js.Lookup("fldChurch", "tblChurch", "fldID='" + js.RiD["fldChurch"].ToString() + "'");
fldAddressDetails = js.RiD["fldAddressDetails"].ToString();
fldContactDetails = js.RiD["fldContactDetails"].ToString();
fldNationality = js.RiD["fldNationality"].ToString();
cboNationality.Text = js.RiD["fldNationality"].ToString();
txtPoints.Text = js.RiD["fldPoints"].ToString();
fldKidsID = js.RiD["fldID"].ToString();
int status = 0;
bool parse;
parse = int.TryParse(js.Lookup("fldUpdateStatus", "tblKids", "fldID='" + fldKidsID + "'"), out status);
if (!parse)
{
status = 0;
}
txtStatus.Text = js.Lookup("fldStatus", "tblStatus", " fldID='" + status + "'");
int age = js.GetAge(dtBirthdate.Value);
string group = "";
if (Convert.ToDecimal(age) < 2)
{
group = "Nursery";
}
else if ((Convert.ToDecimal(age) >= 2) && (Convert.ToDecimal(age) < 3))
{
group = "Toddlers";
}
else if ((Convert.ToDecimal(age) >= 3) && (Convert.ToDecimal(age) <= 4))
{
group = "Preschool";
}
else if ((Convert.ToDecimal(age) >= 5) && (Convert.ToDecimal(age) <= 6))
{
group = "Kinder";
}
else if ((Convert.ToDecimal(age) >= 7) && (Convert.ToDecimal(age) <= 9))
{
group = "Primary";
}
else if ((Convert.ToDecimal(age) >= 10) && (Convert.ToDecimal(age) <= 12))
{
group = "Preteens";
}
else
{
group = "Adult";
}
txtGroup.Text = group;
//FOR LOADING PICTURE
pbImage.Image.Dispose();
string picture = js.GetPath() + "/Kids/" + js.RiD["fldPicture"].ToString().Replace("'","''");
string temppic = Application.StartupPath + "/Pictures/tmp/Kids/tmp1.jpg";
//try { System.IO.File.Delete(temppic); }
//catch (Exception ex) { }
if (System.IO.File.Exists(picture))
{
//pbImage.Dispose();
pbImage.Image.Dispose();
//System.IO.File.Copy(picture, temppic, true);
pbImage.Image = System.Drawing.Image.FromFile(picture);
}
js.CloseConnection();
//For the Address Details
q = "SELECT * FROM tblAddress WHERE fldID='" + fldAddressDetails + "'";
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
if (js.RiD.HasRows)
{
txtAddress1.Text = js.RiD["fldAddress1"].ToString();
txtAddress2.Text = js.RiD["fldAddress2"].ToString();
txtCity.Text = js.RiD["fldCity"].ToString();
txtZipCode.Text = js.RiD["fldZipCode"].ToString();
}
js.CloseConnection();
//For Contact Details
q = "SELECT * FROM tblContactDetails WHERE fldID='" + fldContactDetails + "'";
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
if (js.RiD.HasRows)
{
txtContactNo.Text = js.RiD["fldContactNumber"].ToString();
}
js.CloseConnection();
GetFectchers();
dgvFetchers.Rows.Clear();
for (int i = 0; i <= (fetcherID.Length - 1); i++)
{
string qq = "SELECT f.*,a.*,r.fldRelationship as Relationship,c.fldContactNumber FROM tblFetcher f " +
" LEFT OUTER JOIN tblAddress a ON a.fldID=f.fldAddressDetails " +
" LEFT OUTER JOIN tblContactDetails c ON c.fldID = f.fldContactDetails " +
" LEFT OUTER JOIN tblRelationship r ON r.fldID = f.fldRelationship" +
" WHERE f.fldID = '" + fetcherID[i] + "'";
js.ExecuteQuery(qq);
js.RiD.Read();
if (js.RiD.HasRows)
{
dgvFetchers.Rows.Add(js.RiD["fldID"], js.RiD["fldFirstName"], js.RiD["fldLastName"], js.RiD["fldMiddleName"], js.RiD["Relationship"], js.RiD["fldContactNumber"], js.RiD["fldAddress1"], js.RiD["fldAddress2"], js.RiD["fldCity"], js.RiD["fldZipCode"], js.RiD["fldPicture"].ToString().Replace("'","''"));
}
}
if (dgvFetchers.Rows.Count != 0)
{
if (dgvFetchers.Rows.Count == 1)
{
if (System.IO.File.Exists(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[0].Cells["Picture"].Value.ToString()))
{
pbFetcher1.Image = Image.FromFile(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[0].Cells["Picture"].Value.ToString());
}
}
else if (dgvFetchers.Rows.Count == 2)
{
if (System.IO.File.Exists(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[0].Cells["Picture"].Value.ToString()))
{
pbFetcher1.Image = Image.FromFile(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[0].Cells["Picture"].Value.ToString());
}
if (System.IO.File.Exists(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[1].Cells["Picture"].Value.ToString()))
{
pbFetcher2.Image = Image.FromFile(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[1].Cells["Picture"].Value.ToString());
}
}
else
{
if (System.IO.File.Exists(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[0].Cells["Picture"].Value.ToString()))
{
pbFetcher1.Image = Image.FromFile(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[0].Cells["Picture"].Value.ToString());
}
if (System.IO.File.Exists(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[1].Cells["Picture"].Value.ToString()))
{
pbFetcher2.Image = Image.FromFile(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[1].Cells["Picture"].Value.ToString());
}
if (System.IO.File.Exists(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[2].Cells["Picture"].Value.ToString()))
{
pbFetcher3.Image = Image.FromFile(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[2].Cells["Picture"].Value.ToString());
}
}
}
StartReader();
return;
}
//js.searchquery = qry;
frmResults frm = new frmResults();
frm.Tag = qry;
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string q = frm.Tag.ToString();
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
fetcherID = new string[3];
pbFetcher1.Image = Image.FromFile(Application.StartupPath + "/Pictures/download.jpg");
pbFetcher2.Image = Image.FromFile(Application.StartupPath + "/Pictures/download.jpg");
pbFetcher3.Image = Image.FromFile(Application.StartupPath + "/Pictures/download.jpg");
pbImage.Image = Image.FromFile(Application.StartupPath + "/Pictures/download.jpg");
lblStudentID.Text = js.RiD["fldStudentID"].ToString();
txtFirstName.Text = js.RiD["fldFirstName"].ToString().Replace("''", "'");
txtLastName.Text = js.RiD["fldLastName"].ToString().Replace("''", "'");
txtMiddleName.Text = js.RiD["fldMiddleName"].ToString();
txtNickName.Text = js.RiD["fldNickName"].ToString();
DateTime bdate;
if (DateTime.TryParse(js.RiD["fldBirthday"].ToString(),out bdate))
{
dtBirthdate.Value = bdate;
}
cboGender.Text = js.RiD["Gender"].ToString();
txtChurch.Text = js.Lookup("fldChurch", "tblChurch", "fldID='" + js.RiD["fldChurch"].ToString() + "'");
fldAddressDetails = js.RiD["fldAddressDetails"].ToString();
fldContactDetails = js.RiD["fldContactDetails"].ToString();
fldNationality = js.RiD["fldNationality"].ToString();
cboNationality.Text = js.RiD["fldNationality"].ToString();
txtPoints.Text = js.RiD["fldPoints"].ToString();
fldKidsID = js.RiD["fldID"].ToString();
int status = 0;
bool parse;
parse = int.TryParse(js.Lookup("fldUpdateStatus", "tblKids", "fldID='" + fldKidsID + "'"),out status);
if(!parse)
{
status = 0;
}
txtStatus.Text = js.Lookup("fldStatus", "tblStatus", " fldID='" + status + "'");
int age = js.GetAge(dtBirthdate.Value);
string group = "";
if (Convert.ToDecimal(age) < 2)
{
group = "Nursery";
}
else if ((Convert.ToDecimal(age) >= 2) && (Convert.ToDecimal(age) < 3))
{
group = "Toddlers";
}
else if ((Convert.ToDecimal(age) >= 3) && (Convert.ToDecimal(age) <= 4))
{
group = "Preschool";
}
else if ((Convert.ToDecimal(age) >= 5) && (Convert.ToDecimal(age) <= 6))
{
group = "Kinder";
}
else if ((Convert.ToDecimal(age) >= 7) && (Convert.ToDecimal(age) <= 9))
{
group = "Primary";
}
else if ((Convert.ToDecimal(age) >= 10) && (Convert.ToDecimal(age) <= 12))
{
group = "Preteens";
}
else
{
group = "Adult";
}
txtGroup.Text = group;
//FOR LOADING PICTURE
string picture = js.GetPath() + "/Kids/" + js.RiD["fldPicture"].ToString().Replace("'","''") + "";
string temppic = Application.StartupPath + "/Pictures/tmp/Kids/tmp1.jpg";
try { System.IO.File.Delete(temppic); } catch(Exception ex){}
if (System.IO.File.Exists(picture))
{
//pbImage.Dispose();
pbImage.Image.Dispose();
//System.IO.File.Copy(picture, temppic, true);
pbImage.Image = System.Drawing.Image.FromFile(picture);
}
js.CloseConnection();
//For the Address Details
q = "SELECT * FROM tblAddress WHERE fldID='" + fldAddressDetails + "'";
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
if (js.RiD.HasRows)
{
txtAddress1.Text = js.RiD["fldAddress1"].ToString();
txtAddress2.Text = js.RiD["fldAddress2"].ToString();
txtCity.Text = js.RiD["fldCity"].ToString();
txtZipCode.Text = js.RiD["fldZipCode"].ToString();
}
js.CloseConnection();
//For Contact Details
q = "SELECT * FROM tblContactDetails WHERE fldID='" + fldContactDetails + "'";
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
if (js.RiD.HasRows)
{
txtContactNo.Text = js.RiD["fldContactNumber"].ToString();
}
js.CloseConnection();
GetFectchers();
dgvFetchers.Rows.Clear();
for (int i = 0; i <= (fetcherID.Length - 1); i++)
{
string qq = "SELECT f.*,a.*,r.fldRelationship as Relationship,c.fldContactNumber FROM tblFetcher f " +
" LEFT OUTER JOIN tblAddress a ON a.fldID=f.fldAddressDetails " +
" LEFT OUTER JOIN tblContactDetails c ON c.fldID = f.fldContactDetails " +
" LEFT OUTER JOIN tblRelationship r ON r.fldID = f.fldRelationship" +
" WHERE f.fldID = '" + fetcherID[i] + "'";
try
{
js.ExecuteQuery(qq);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(qq);
js.RiD.Read();
if (js.RiD.HasRows)
{
dgvFetchers.Rows.Add(js.RiD["fldID"], js.RiD["fldFirstName"], js.RiD["fldLastName"], js.RiD["fldMiddleName"], js.RiD["Relationship"], js.RiD["fldContactNumber"], js.RiD["fldAddress1"], js.RiD["fldAddress2"], js.RiD["fldCity"], js.RiD["fldZipCode"], js.RiD["fldPicture"].ToString().Replace("'","''"));
}
}
if (dgvFetchers.Rows.Count != 0)
{
if (dgvFetchers.Rows.Count == 1)
{
if (System.IO.File.Exists(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[0].Cells["Picture"].Value.ToString()))
{
pbFetcher1.Image = Image.FromFile(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[0].Cells["Picture"].Value.ToString());
}
}
else if (dgvFetchers.Rows.Count == 2)
{
if (System.IO.File.Exists(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[0].Cells["Picture"].Value.ToString()))
{
pbFetcher1.Image = Image.FromFile(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[0].Cells["Picture"].Value.ToString());
}
if (System.IO.File.Exists(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[1].Cells["Picture"].Value.ToString()))
{
pbFetcher2.Image = Image.FromFile(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[1].Cells["Picture"].Value.ToString());
}
}
else
{
if (System.IO.File.Exists(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[0].Cells["Picture"].Value.ToString()))
{
pbFetcher1.Image = Image.FromFile(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[0].Cells["Picture"].Value.ToString());
}
if (System.IO.File.Exists(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[1].Cells["Picture"].Value.ToString()))
{
pbFetcher2.Image = Image.FromFile(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[1].Cells["Picture"].Value.ToString());
}
if (System.IO.File.Exists(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[2].Cells["Picture"].Value.ToString()))
{
pbFetcher3.Image = Image.FromFile(js.GetPath() + "/Fetchers/" + dgvFetchers.Rows[2].Cells["Picture"].Value.ToString());
}
}
}
StartReader();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
string qry = "";
if (txtSearch.Text == "")
{
js.showExclamation("Cannot generate result with an empty field");
return;
}
if(cboSearch.Text == "First Name")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldFirstName='" + txtSearch.Text.Replace("'","''") + "' ORDER BY fldLastName";
}
if(cboSearch.Text == "Last Name")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldLastName='" + txtSearch.Text.Replace("'", "''") + "' ORDER BY fldFirstName";
}
if (cboSearch.Text == "Nick Name")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldNickName='" + txtSearch.Text.Replace("'", "''") + "' ORDER BY fldFirstName,fldLastName";
}
if (cboSearch.Text == "Birth Day")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldBirthday='" + dtSearch.Value.ToShortDateString() + "' ORDER BY fldFirstName, fldLastName";
}
if (cboSearch.Text == "Barcode")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldStudentID='" + txtSearch.Text.Replace("'", "''") + "'";
string q = qry;
try
{
js.ExecuteQuery(q);
}
catch(Exception ex)
{
MessageBox.Show(ex.Message, "Error Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
fetcherID = new string[3];
pbImage.Image = Image.FromFile(Application.StartupPath + "/Pictures/download.jpg");
lblStudentID.Text = js.RiD["fldStudentID"].ToString();
txtFirstName.Text = js.RiD["fldFirstName"].ToString().Replace("''", "'");
txtLastName.Text = js.RiD["fldLastName"].ToString().Replace("''", "'");
txtMiddleName.Text = js.RiD["fldMiddleName"].ToString();
txtNickName.Text = js.RiD["fldNickName"].ToString();
DateTime bdate;
if (DateTime.TryParse(js.RiD["fldBirthday"].ToString(), out bdate))
{
dtBirthdate.Value = bdate;
}
cboGender.Text = js.RiD["Gender"].ToString();
txtChurch.Text = js.Lookup("fldChurch", "tblChurch", "fldID='" + js.RiD["fldChurch"].ToString() + "'");
fldAddressDetails = js.RiD["fldAddressDetails"].ToString();
fldContactDetails = js.RiD["fldContactDetails"].ToString();
fldNationality = js.RiD["fldNationality"].ToString();
cboNationality.Text = fldNationality;//js.Lookup("fldNationality", "tblNationality", "fldID='" + js.RiD["fldNationality"].ToString() + "'");
txtPoints.Text = js.RiD["fldPoints"].ToString();
fldKidsID = js.RiD["fldID"].ToString();
int age = js.GetAge(dtBirthdate.Value);
txtAge.Text = age.ToString();
txtAllergies.Text = js.RiD["fldAllergies"].ToString();
string status = js.RiD["fldUpdateStatus"].ToString();
txtStatus.Text = js.Lookup("fldStatus","tblStatus","fldID='" + status + "'");
txtRemarks.Text = js.RiD["fldRemarks"].ToString();
string group = "";
if(age>=10)
{
chkTick.Enabled = false;
}
else
{
chkTick.Enabled = false;
}
if (Convert.ToDecimal(age) < 2)
{
group = "Nursery";
}
else if ((Convert.ToDecimal(age) >= 2) && (Convert.ToDecimal(age) < 3))
{
group = "Toddlers";
}
else if ((Convert.ToDecimal(age) >= 3) && (Convert.ToDecimal(age) <= 4))
{
group = "Preschool";
}
else if ((Convert.ToDecimal(age) >= 5) && (Convert.ToDecimal(age) <= 6))
{
group = "Kinder";
}
else if ((Convert.ToDecimal(age) >= 7) && (Convert.ToDecimal(age) <= 9))
{
group = "Primary";
}
else if ((Convert.ToDecimal(age) >= 10) && (Convert.ToDecimal(age) <= 12))
{
group = "Preteens";
}
else
{
group = "Adult";
}
txtGroup.Text = group;
//FOR LOADING PICTURE
string picture = GetPath() + "/Kids/" + js.RiD["fldPicture"].ToString();
string temppic = Application.StartupPath + "/Pictures/tmp/Kids/tmp1.jpg";
//try { System.IO.File.Delete(temppic); }
//catch (Exception ex) { }
if(System.IO.File.Exists(picture))
{
pbImage.Image.Dispose();
///System.IO.File.Copy(picture, temppic,true);
pbImage.Image = System.Drawing.Image.FromFile(picture);
}
js.CloseConnection();
//For the Address Details
q = "SELECT * FROM tblAddress WHERE fldID='" + fldAddressDetails + "'";
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
if(js.RiD.HasRows)
{
txtAddress1.Text = js.RiD["fldAddress1"].ToString();
txtAddress2.Text = js.RiD["fldAddress2"].ToString();
txtCity.Text = js.RiD["fldCity"].ToString();
txtZipCode.Text = js.RiD["fldZipCode"].ToString();
}
js.CloseConnection();
//For Contact Details
q = "SELECT * FROM tblContactDetails WHERE fldID='" + fldContactDetails + "'";
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
if (js.RiD.HasRows)
{
txtContactNo.Text = js.RiD["fldContactNumber"].ToString();
}
js.CloseConnection();
return;
}
//js.searchquery = qry;
frmResults frm = new frmResults();
frm.Tag = qry;
if (frm.ShowDialog()== System.Windows.Forms.DialogResult.OK)
{
string q = frm.Tag.ToString();
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
fetcherID = new string[3]; //destroy string
pbImage.Image = Image.FromFile(Application.StartupPath + "/Pictures/download.jpg");
lblStudentID.Text = js.RiD["fldStudentID"].ToString();
txtFirstName.Text = js.RiD["fldFirstName"].ToString().Replace("''", "'");
txtLastName.Text = js.RiD["fldLastName"].ToString().Replace("''", "'");
txtMiddleName.Text = js.RiD["fldMiddleName"].ToString();
txtNickName.Text = js.RiD["fldNickName"].ToString();
DateTime bdate;
if (DateTime.TryParse(js.RiD["fldBirthday"].ToString(), out bdate))
{
dtBirthdate.Value = bdate;
}
cboGender.Text = js.RiD["Gender"].ToString();
txtChurch.Text = js.Lookup("fldChurch", "tblChurch", "fldID='" + js.RiD["fldChurch"].ToString() + "'");
fldAddressDetails = js.RiD["fldAddressDetails"].ToString();
fldContactDetails = js.RiD["fldContactDetails"].ToString();
fldNationality = js.RiD["fldNationality"].ToString();
cboNationality.Text = fldNationality;//js.Lookup("fldNationality", "tblNationality", "fldID='" + js.RiD["fldNationality"].ToString() + "'");
txtPoints.Text = js.RiD["fldPoints"].ToString();
fldKidsID = js.RiD["fldID"].ToString();
int age = js.GetAge(dtBirthdate.Value);
string group = "";
txtAge.Text = age.ToString();
txtAllergies.Text = js.RiD["fldAllergies"].ToString();
string status = js.RiD["fldUpdateStatus"].ToString();
txtStatus.Text = js.Lookup("fldStatus", "tblStatus", "fldID='" + status + "'");
txtRemarks.Text = js.RiD["fldRemarks"].ToString();
if (age >= 10)
{
chkTick.Visible = false;
}
else
{
chkTick.Visible = false;
}
if (Convert.ToDecimal(age) < 2)
{
group = "Nursery";
}
else if ((Convert.ToDecimal(age) >= 2) && (Convert.ToDecimal(age) < 3))
{
group = "Toddlers";
}
else if ((Convert.ToDecimal(age) >= 3) && (Convert.ToDecimal(age) <= 4))
{
group = "Preschool";
}
else if ((Convert.ToDecimal(age) >= 5) && (Convert.ToDecimal(age) <= 6))
{
group = "Kinder";
}
else if ((Convert.ToDecimal(age) >= 7) && (Convert.ToDecimal(age) <= 9))
{
group = "Primary";
}
else if ((Convert.ToDecimal(age) >= 10) && (Convert.ToDecimal(age) <= 12))
{
group = "Preteens";
}
else
{
group = "Adult";
}
txtGroup.Text = group;
//FOR LOADING PICTURE
string picture = GetPath() + "/Kids/" + js.RiD["fldPicture"].ToString().Replace("'","''");
string temppic = Application.StartupPath + "/Pictures/tmp/Kids/tmp1.jpg";
//try { System.IO.File.Delete(temppic); }
//catch (Exception ex) { }
if (System.IO.File.Exists(picture))
{
//pbImage.Dispose();
pbImage.Image.Dispose();
//System.IO.File.Copy(picture, temppic, true);
pbImage.Image = System.Drawing.Image.FromFile(picture);
}
js.CloseConnection();
//For the Address Details
q = "SELECT * FROM tblAddress WHERE fldID='" + fldAddressDetails + "'";
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//js.ExecuteQuery(q);
js.RiD.Read();
if(js.RiD.HasRows)
{
txtAddress1.Text = js.RiD["fldAddress1"].ToString();
txtAddress2.Text = js.RiD["fldAddress2"].ToString();
txtCity.Text = js.RiD["fldCity"].ToString();
txtZipCode.Text = js.RiD["fldZipCode"].ToString();
}
js.CloseConnection();
//For Contact Details
q = "SELECT * FROM tblContactDetails WHERE fldID='" + fldContactDetails + "'";
try
{
js.ExecuteQuery(q);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
js.ExecuteQuery(q);
js.RiD.Read();
if (js.RiD.HasRows)
{
txtContactNo.Text = js.RiD["fldContactNumber"].ToString();
}
js.CloseConnection();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
string qry = "";
if(cboSearch.Text == "First Name")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldFirstName='" + txtSearch.Text + "'";
}
if(cboSearch.Text == "Last Name")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldLastName='" + txtSearch.Text + "'";
}
if (cboSearch.Text == "Nick Name")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldNickName='" + txtSearch.Text + "'";
}
if (cboSearch.Text == "Birth Day")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldBirthday='" + dtSearch.Value.ToShortDateString() + "'";
}
if (cboSearch.Text == "Barcode")
{
qry = "SELECT k.*,g.fldGender as Gender FROM tblKids k " +
"LEFT OUTER JOIN tblGender g ON g.fldID=k.fldGender" +
" WHERE fldStudentID='" + txtSearch.Text + "'";
string q = qry;
js.ExecuteQuery(q);
js.RiD.Read();
lblStudentID.Text = js.RiD["fldStudentID"].ToString();
txtFirstName.Text = js.RiD["fldFirstName"].ToString();
txtLastName.Text = js.RiD["fldLastName"].ToString();
txtMiddleName.Text = js.RiD["fldMiddleName"].ToString();
txtNickName.Text = js.RiD["fldNickName"].ToString();
dtBirthdate.Value = Convert.ToDateTime(js.RiD["fldBirthday"].ToString());
cboGender.Text = js.RiD["Gender"].ToString();
txtChurch.Text = js.Lookup("fldChurch", "tblChurch", "fldID='" + js.RiD["fldChurch"].ToString() + "'");
fldAddressDetails = js.RiD["fldAddressDetails"].ToString();
fldContactDetails = js.RiD["fldContactDetails"].ToString();
fldNationality = js.RiD["fldNationality"].ToString();
cboNationality.Text = js.Lookup("fldNationality", "tblNationality", "fldID='" + js.RiD["fldNationality"].ToString() + "'");
txtPoints.Text = js.RiD["fldPoints"].ToString();
fldKidsID = js.RiD["fldID"].ToString();
//FOR LOADING PICTURE
string picture = js.RiD["fldPicture"].ToString();
string temppic = Application.StartupPath + "/Pictures/tmp/Kids/tmp1.jpg";
if(System.IO.File.Exists(picture))
{
pbImage.Image.Dispose();
System.IO.File.Copy(picture, temppic,true);
pbImage.Image = System.Drawing.Image.FromFile(temppic);
}
js.CloseConnection();
//For the Address Details
q = "SELECT * FROM tblAddress WHERE fldID='" + fldAddressDetails + "'";
js.ExecuteQuery(q);
js.RiD.Read();
if(js.RiD.HasRows)
{
txtAddress1.Text = js.RiD["fldAddress1"].ToString();
txtAddress2.Text = js.RiD["fldAddress2"].ToString();
txtCity.Text = js.RiD["fldCity"].ToString();
txtZipCode.Text = js.RiD["fldZipCode"].ToString();
}
js.CloseConnection();
//For Contact Details
q = "SELECT * FROM tblContactDetails WHERE fldID='" + fldContactDetails + "'";
js.ExecuteQuery(q);
js.RiD.Read();
if (js.RiD.HasRows)
{
txtContactNo.Text = js.RiD["fldContactNumber"].ToString();
}
js.CloseConnection();
return;
}
//js.searchquery = qry;
frmResults frm = new frmResults();
frm.Tag = qry;
if (frm.ShowDialog()== System.Windows.Forms.DialogResult.OK)
{
string q = frm.Tag.ToString();
js.ExecuteQuery(q);
js.RiD.Read();
lblStudentID.Text = js.RiD["fldStudentID"].ToString();
txtFirstName.Text = js.RiD["fldFirstName"].ToString();
txtLastName.Text = js.RiD["fldLastName"].ToString();
txtMiddleName.Text = js.RiD["fldMiddleName"].ToString();
txtNickName.Text = js.RiD["fldNickName"].ToString();
dtBirthdate.Value = Convert.ToDateTime(js.RiD["fldBirthday"].ToString());
cboGender.Text = js.RiD["Gender"].ToString();
txtChurch.Text = js.Lookup("fldChurch", "tblChurch", "fldID='" + js.RiD["fldChurch"].ToString() + "'");
fldAddressDetails = js.RiD["fldAddressDetails"].ToString();
fldContactDetails = js.RiD["fldContactDetails"].ToString();
fldNationality = js.RiD["fldNationality"].ToString();
cboNationality.Text = js.Lookup("fldNationality", "tblNationality", "fldID='" + js.RiD["fldNationality"].ToString() + "'");
txtPoints.Text = js.RiD["fldPoints"].ToString();
fldKidsID = js.RiD["fldID"].ToString();
//FOR LOADING PICTURE
string picture = js.RiD["fldPicture"].ToString();
string temppic = Application.StartupPath + "/Pictures/tmp/Kids/tmp1.jpg";
if (System.IO.File.Exists(picture))
{
//pbImage.Dispose();
pbImage.Image.Dispose();
System.IO.File.Copy(picture, temppic, true);
pbImage.Image = System.Drawing.Image.FromFile(temppic);
}
js.CloseConnection();
//For the Address Details
q = "SELECT * FROM tblAddress WHERE fldID='" + fldAddressDetails + "'";
js.ExecuteQuery(q);
js.RiD.Read();
if(js.RiD.HasRows)
{
txtAddress1.Text = js.RiD["fldAddress1"].ToString();
txtAddress2.Text = js.RiD["fldAddress2"].ToString();
txtCity.Text = js.RiD["fldCity"].ToString();
txtZipCode.Text = js.RiD["fldZipCode"].ToString();
}
js.CloseConnection();
//For Contact Details
q = "SELECT * FROM tblContactDetails WHERE fldID='" + fldContactDetails + "'";
js.ExecuteQuery(q);
js.RiD.Read();
if (js.RiD.HasRows)
{
txtContactNo.Text = js.RiD["fldContactNumber"].ToString();
}
js.CloseConnection();
}
}
