//check the amount of hours to set overtime and banking options public static decimal checkBankingHr(string date, string instance) { //open con to the api conOpen(); if (date == null) { date = DateTime.Now.Date.ToString("yyyy-MM-dd"); } decimal hours = 0; GeneralQuery gen = null; Instance currInstance = Dbms.GetInstanceInfo(instName); gen = new GeneralQuery(instance); gen.Prepare("LABOR_TICKET", "SELECT SUM(HOURS_WORKED) FROM VMFG.LABOR_TICKET WHERE DateDiff(wk,TRANSACTION_DATE,'" + date + "') = 0 AND SUBSTRING(REVERSE(DESCRIPTION), CHARINDEX(',',REVERSE(DESCRIPTION)) + 1, 2) = 'KB'"); gen.Execute(); if (gen.Tables["LABOR_TICKET"].Rows.Count > 0 && !gen.Tables["LABOR_TICKET"].Rows[0]["Column1"].ToString().Equals("")) { hours = Decimal.Parse(gen.Tables["LABOR_TICKET"].Rows[0]["Column1"].ToString()); Dbms.Close(instName); return(hours); } Dbms.Close(instName); return(hours); }