public static int DuplicateWorkDayExists(int pkWorkDay, DateTime WorkDate) { SQLStoredProc sp = new SQLStoredProc(config.ConnectionString, "haah.DuplicateWorkDayExists"); sp.AddInputParameter("@pkWorkDay", pkWorkDay); sp.AddInputParameter("@WorkDate", WorkDate); return sp.ScalarInteger(-1); }
public static int GetConfigValueInt(string itemKey) { SQLStoredProc sp = new SQLStoredProc(config.ConnectionString, "haah.GetConfigValueInt"); sp.AddInputParameter("@ItemKey", itemKey); return sp.ScalarInteger(0); }