public static RSVP EditRSVP(RSVP rsvp) { using (var con = Open()) { rsvp.EditDate = DateTime.Now; rsvp.ConfimationNumber = new Guid(); CommandDefinition command = new CommandDefinition(StoredProcedures.Proc_Custom_RSVPRepositories_EditRSVP.ToString(), new { rsvp.RSVPId, rsvp.CreateDate, rsvp.ConfimationNumber, rsvp.isAttending, rsvp.AttendingGuests, rsvp.FavoriteWine, rsvp.FirstName, rsvp.LastName, rsvp.ShortDescription, }, commandType: CommandType.StoredProcedure); rsvp = con.Query<RSVP>(command).FirstOrDefault(); } if (rsvp == null) { rsvp = new RSVP(); } return rsvp; }
public static void DeleteRSVP(int id) { RSVP rsvp = new RSVP(); using (var con = Open()) { CommandDefinition command = new CommandDefinition(StoredProcedures.Proc_Custom_RSVPRepositories_DeleteRSVP.ToString(), new { id = id }, commandType: CommandType.StoredProcedure); rsvp = con.Query<RSVP>(command).FirstOrDefault(); } }
public static RSVP GetRSVPByConfirmationNumber(string number) { RSVP rsvp = new RSVP(); using (var con = Open()) { CommandDefinition command = new CommandDefinition(StoredProcedures.Proc_Custom_RSVPRepositories_GetRSVPByConfimationNumber.ToString(), new { ConfimationNumber = number }, commandType: CommandType.StoredProcedure); rsvp = con.Query<RSVP>(command).FirstOrDefault(); } return rsvp; }