public bool TryRegisterMail(DbElectionCycleMail p) { try { return(Context.Connection.Execute("INSERT INTO fso_election_cyclemail (cycle_id, avatar_id, cycle_state) VALUES (@cycle_id, @avatar_id, @cycle_state)", new { p.avatar_id, p.cycle_id, cycle_state = p.cycle_state.ToString() }) > 0); } catch { //already exists, or foreign key fails return(false); } }
public bool EmailRegistered(DbElectionCycleMail p) { return(Context.Connection.Query <int>("SELECT count(*) FROM fso_election_cyclemail WHERE cycle_id = @cycle_id AND avatar_id = @avatar_id AND cycle_state = @cycle_state", new { p.avatar_id, p.cycle_id, cycle_state = p.cycle_state.ToString() }).First() > 0); }