private bool WasEmailSent(string objectID) { EsriForms data = new EsriForms(); DataTable dtSentEmail = data.Get_Parse_Sent_Email(); foreach (DataRow dr in dtSentEmail.Rows) { if (dr["ObjectId"] != DBNull.Value) { if (dr["ObjectId"].ToString() == objectID) return true; } } return false; }
private string CreateQueryString() { string query = "?"; EsriForms data = new EsriForms(); DataTable dt = data.Get_Parse_Sent_Email(); foreach (DataRow dr in dt.Rows) query += "objectId<>" + dr["ObjectId"].ToString() + "&"; query = query.TrimEnd('&'); return query; }