/// <summary> /// Update Adhoc task email flag in database /// </summary> static void AdhocUpdateTaskEmailFlag(int attachmentID) { try { string taskQuery = DbRepository.AdhocUpdateTaskEmailFlag(); List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@AttachmentID", attachmentID)); var result = SQLHelper.ExecuteScalar(taskQuery, CommandType.StoredProcedure, parameters.ToArray()); } catch (Exception ex) { LoggerHelper.ExcpLogger("WindowService Program", "AdhocUpdateTaskEmailFlag", ex); } }