public bool InsertActivationCode(ActivationCode activationCode) { var sql = $"insert into {SchemaName}.ActivationCodes (PhoneNumber, Code) values (@PhoneNumber, @Code)"; var rows = connection.Execute(sql, new { activationCode.PhoneNumber, activationCode.Code }, currentTransaction.Get()); return(rows > 0); }
public bool UpdateActivationCode(ActivationCode existing) { var sql = $"update {SchemaName}.ActivationCodes set Code=@code, UpdatedAt=@updatedAt where PhoneNumber=@phoneNumber"; var rows = connection.Execute(sql, new { existing.Code, existing.UpdatedAt, phoneNumber = existing.PhoneNumber }, currentTransaction.Get()); return(rows > 0); }
public ActivationCode GetActivationCode(string phoneNumber) { var sql = $"select * from {SchemaName}.ActivationCodes where PhoneNumber=@phoneNumber"; var dbEntities = connection.Query(sql, new { phoneNumber }, currentTransaction.Get()); var dbEntity = dbEntities.FirstOrDefault(); ActivationCode entity = null; if (dbEntity != null) { entity = new ActivationCode { PhoneNumber = dbEntity.PhoneNumber, CreatedAt = dbEntity.CreatedAt, UpdatedAt = dbEntity.UpdatedAt, Code = dbEntity.Code } } ; return(entity); }