/// <summary> /// Update an entry in the PartyInvite table /// </summary> public static bool Update(PartyInvite partyInvite) { bool result = false; SqlConnection cn = GetConnection(); result = Update(cn, partyInvite); FinishedWithConnection(cn); return(result); }
/// <summary> /// Get an entry from the PartyInvite table /// </summary> public static PartyInvite Get(int id) { PartyInvite result = null; SqlConnection cn = GetConnection(); result = Get(cn, id); FinishedWithConnection(cn); return(result); }
private static bool Update(SqlConnection cn, PartyInvite partyInvite) { Int32 rowsAffected = 0; using (SqlCommand sqlCmd = cn.CreateCommand()) { sqlCmd.CommandText = "UPDATE PartyInvite SET PartyInvitePartyId=@PartyInvitePartyId,PartyInviteName=@PartyInviteName WHERE PartyInviteId=@PartyInviteId"; BuildSqlParameter(sqlCmd, "@PartyInviteId", SqlDbType.Int, partyInvite.Id); BuildSqlParameter(sqlCmd, "@PartyInvitePartyId", SqlDbType.Int, partyInvite.PartyId); BuildSqlParameter(sqlCmd, "@PartyInviteName", SqlDbType.Text, partyInvite.GuestName); rowsAffected = sqlCmd.ExecuteNonQuery(); } return(rowsAffected != 0); }
private static PartyInvite Get(SqlConnection cn, int id) { PartyInvite result = null; using (SqlCommand cmd = new SqlCommand("SELECT * FROM PartyInvite WHERE PartyInviteId=" + id, cn)) { using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { result = BuildPartyInvite(rdr); } } } return(result); }
/// <summary> /// Delete an entry from the PartyInvite table /// </summary> public static bool Delete(int id) { Int32 rowsAffected = 0; SqlConnection cn = GetConnection(); PartyInvite partyInvite = Get(cn, id); if (partyInvite != null) { using (SqlCommand sqlCmd = cn.CreateCommand()) { sqlCmd.CommandText = "DELETE FROM PartyInvite WHERE PartyInviteId=" + id; rowsAffected = sqlCmd.ExecuteNonQuery(); } } FinishedWithConnection(cn); return(rowsAffected != 0); }
/// <summary> /// Add a new entry to the PartyInvite table /// </summary> public static PartyInvite Add(int partyId, string guestName) { PartyInvite result = null; SqlConnection cn = GetConnection(); string cmd = "AddPartyInvite"; using (SqlCommand sqlCmd = new SqlCommand(cmd, cn)) { sqlCmd.CommandType = CommandType.StoredProcedure; BuildSqlParameter(sqlCmd, "@PartyInvitePartyId", SqlDbType.Int, partyId); BuildSqlParameter(sqlCmd, "@PartyInviteName", SqlDbType.Text, guestName); BuildSqlParameter(sqlCmd, "@PartyInviteId", SqlDbType.Int, ParameterDirection.ReturnValue); if (sqlCmd.ExecuteNonQuery() > 0) { result = new PartyInvite(Convert.ToInt32(sqlCmd.Parameters["@PartyInviteId"].Value), partyId, guestName); } } FinishedWithConnection(cn); return(result); }
public bool Update() { return(PartyInvite.Update(this)); }