private string BuildEventFileName(string ext, int id = -1)
{
int nextKey = 0;
if (id < 0)
{
clsDataGetter dg = new clsDataGetter(db.Database.Connection.ConnectionString);
nextKey = dg.GetScalarInteger("SELECT MAX(pKey) FROM Events WHERE DistKey=" + GlobalVariables.DistNumber);
nextKey += 1;
}
else
{
nextKey = id;
}
return("event_" + GlobalVariables.DistNumber + "_" + nextKey.ToString() + ext);
}
private int GetOTPayrollItem(string RegHoursID)
{
using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr))
{
string branchStr = GetCurrentBranch();
string nameSQL = "SELECT name FROM PayrollItem ";
nameSQL += "WHERE payItemID=" + RegHoursID;
string itemName = dg.GetScalarString(nameSQL);
string[] nameParts = itemName.Split('-');
itemName = nameParts[0] + "-" + nameParts[1];
string IDSql = "SELECT payItemID FROM PayrollItem ";
IDSql += "WHERE Name LIKE '%" + itemName + "-OT' ";
IDSql += "AND WageType = 'HourlyOvertime' ";
IDSql += "AND QBFile='" + GetCurrentCompany() + "'";
return(dg.GetScalarInteger(IDSql));
}
}