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