if (hasTime == true)
            {
               
                string hourQuery = string.Format("SELECT contact.contactID, contact.firstName, contact.lastName, hours.hoursWorked" +
                           " FROM contact INNER JOIN hours ON contact.contactID=hours.contactID WHERE hours.fiscalYearID ={0}", selectedYearID.ToString());

            else if(isNewEntry == false)
            {
                string query = "UPDATE hours SET hoursWorked = @p3 WHERE contactID = @p1 AND fiscalYearID = @p2";

 private void manualEntry(object sender, EventArgs e)
        {

    oXL = new Microsoft.Office.Interop.Excel.Application();
            oXL.Visible = false;
            oWK = (Microsoft.Office.Interop.Excel._Workbook)(oXL.Workbooks.Add(System.Reflection.Missing.Value));
            oWK.SaveAs(path + "\\"

DirectorySecurity access = Directory.GetAccessControl(System.Environment.GetFolderPath(Environment.SpecialFolder.ProgramFiles));
                access.AddAccessRule(new FileSystemAccessRule(WindowsIdentity.GetCurrent().User,

SET @var1 = ''
SET @var2 = ''
SET @var3 = ''
SET @var4 = ''

SELECT @Counter = MIN(ID) FROM #TEMP WHERE ID>0

WHILE @Counter > 0
BEGIN
SELECT @key = Phase FROM #TEMP WHERE ID = @Counter
SELECT (CASE WHEN @Key = 1 THEN
         [B][U]@Var1 = (SELECT Agency[/][/]

CREATE TABLE #TEMP
(
ID INT Identity,

timeDiff = DateAdd("h", overTime * -1, endTime)

timeDiff

Shared offset as Integer
Shared currentgroup as Object

Public Function GetGroupPageNumber(group as Object, pagenumber as Integer) as Object
  
  If Not (group =  currentgroup)
              offset = 1
  Else 
  offset = offset + 1

  End If