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