private bool LoadVolunteer(string testFBIDNbr, string testDate) { string testVolId = ""; if (testFBIDNbr != "") { clsVols.openWhere(" WHERE FBIDNbr = '" + testFBIDNbr + "'"); if (clsVols.RowCount > 0) { testVolId = clsVols.ID.ToString(); lblName.Text = clsVols.Name; clsVolHrs.openWhere("WHERE VolID = " + testVolId + " AND TrxDate = '" + testDate + "'"); if (clsVolHrs.IsValid == false) //no record means checkin { modeTimeIN = true; tbTimeIN.Tag = DateTime.Now.ToShortTimeString(); tbTimeIN.Text = tbTimeIN.Tag.ToString(); } else { modeTimeIN = false; tbTimeIN.Tag = clsVolHrs.VolTimeIn; string tmp = "01/01/2010 " + tbTimeIN.Tag; tbTimeIN.Text = Convert.ToDateTime(tmp).ToShortTimeString(); if (clsVolHrs.VolTimeOut == "") { tbTimeOUT.Tag = DateTime.Now.ToShortTimeString(); } else { tbTimeOUT.Tag = clsVolHrs.VolTimeOut; } tmp = "01/01/2010 " + tbTimeOUT.Tag; tbTimeOUT.Text = Convert.ToDateTime(tmp).ToShortTimeString(); tbHours.Tag = clsVolHrs.TotalHours(tbTimeIN.Tag.ToString(), tbTimeOUT.Tag.ToString()); formattedHours(); } return(true); } else { MessageBox.Show("I cannot find this Volunteer\r\nID Number: " + testFBIDNbr, "Find Volunteer Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } } return(false); }
private void loadVolsGrid() { bool hrsSet; int volId = 0; Single sumVolHrs = 0; Single volHrs = 0; int[] hrsGroup = new int[clsVolGroups.NbrGroups + 1]; dataGridViewVols.Rows.Clear(); Application.DoEvents(); if (groupVolIdList == "") { clsVols.openWhere(baseWhereClause); } else { clsVols.openWhere(baseWhereClause + " AND Id IN ( " + groupVolIdList + ")"); } for (int k = 0; k < clsVolGroups.NbrGroups; k++) { clsVolGroups.GroupIndex = k; clsVolGroups.VolunGroup.VolHrs = 0; } clsVolHrs.openWhere("WHERE TrxDate = '" + tbWorkDate.Tag.ToString() + "'"); int i = 0; foreach (DataRow drow in clsVols.DSet.Tables[0].Rows) //for (int i = 0; i < clsVols.RowCount; i++) { dataGridViewVols.Rows.Add(); dataGridViewVols["clmVol", i].Value = drow["Name"].ToString().ToUpper(); volId = Convert.ToInt32(drow["ID"]); dataGridViewVols["clmVolID", i].Value = volId.ToString(); hrsSet = false; if (clsVolHrs.findVolId(volId) == true) { if (Convert.ToInt32(clsVolHrs.GetDataValue("VolID")) == volId) { volHrs = Convert.ToSingle(clsVolHrs.GetDataValue("NumVolHours")); dataGridViewVols["clmTimeIn", i].Value = clsVolHrs.GetDataValue("VolTimeIn"); dataGridViewVols["clmTimeOut", i].Value = clsVolHrs.GetDataValue("VolTimeOut"); dataGridViewVols["clmHrs", i].Value = volHrs.ToString("F"); dataGridViewVols.Rows[i].Cells["clmHrs"].Style.BackColor = Color.Yellow; dataGridViewVols["clmVHID", i].Value = clsVolHrs.GetDataValue("ID").ToString(); hrsSet = true; sumVolHrs += volHrs; for (int j = 0; j < clsVolGroups.NbrGroups; j++) { clsVolGroups.GroupIndex = j; for (int k = 0; k < clsVolGroups.VolunGroup.NbrVols; k++) { if (volId == clsVolGroups.VolunGroup.GetVolId(k)) { clsVolGroups.VolunGroup.VolHrs += volHrs; break; } } } } } else { dataGridViewVols.Rows[i].Visible = (chkShowWithData.Checked == false); } if (hrsSet == false) { dataGridViewVols["clmHrs", i].Value = 0; dataGridViewVols["clmHrs", i].Style.BackColor = Color.White; } i++; } tbSumHrs.Text = sumVolHrs.ToString("F"); fillVolGroupHours(sumVolHrs); }